CodeLogic.Data.MySql 5.0.119-preview

.NET 11.0 This package targets .NET 11.0. The package is compatible with this framework or higher.
This is a prerelease version of CodeLogic.Data.MySql.
This package has a SemVer 2.0.0 package version: 5.0.119-preview+8f1045e. 
dotnet add package CodeLogic.Data.MySql --version 5.0.119-preview
                    


                    

                
NuGet\Install-Package CodeLogic.Data.MySql -Version 5.0.119-preview
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="CodeLogic.Data.MySql" Version="5.0.119-preview" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="CodeLogic.Data.MySql" Version="5.0.119-preview" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="CodeLogic.Data.MySql" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add CodeLogic.Data.MySql --version 5.0.119-preview
                    


                    

                
#r "nuget: CodeLogic.Data.MySql, 5.0.119-preview"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#:package CodeLogic.Data.MySql@5.0.119-preview
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=CodeLogic.Data.MySql&version=5.0.119-preview&prerelease
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=CodeLogic.Data.MySql&version=5.0.119-preview&prerelease
                    


                            Install as a Cake Tool

CodeLogic.Data.MySql

Status: 5.0 preview.

The MySQL and MariaDB provider for CodeLogic.Data, built on MySqlConnector.

dotnet add package CodeLogic.Data.MySql
  • With the CodeLogic runtime: load MySqlDataLibrary next to DataLibrary, and set "provider": "mysql" on a connection in config.data.json.
  • Without it: pass MySqlDataProvider.Instance to Database.Create.

Bulk copy uses MySqlBulkCopy (set mySql.allowLoadLocalInfile and the server's local_infile); slow-query plans use EXPLAIN FORMAT=TREE; replica lag comes from SHOW REPLICA STATUS; failoverHosts enables driver failover. Extras: db.MySql.OptimizeTableAsync<T>(), AnalyzeTableAsync<T>().

Pooled connections skip MySqlConnector's reset on every open (one round trip per command). CL.Data resets a connection before it goes back to the pool only when it may carry session state: raw SET/CALL/transaction control/user variables/locks/temporary tables, WithConnectionAsync, interrupted commands. mySql.connectionReset (WhenDirty, Always, Never) chooses; keep mySql.connectionIdleTimeoutSeconds below any proxy's idle timeout.

Documentation: Providers.

Product Compatible and additional computed target framework versions.
.NET net11.0 is compatible. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
5.0.119-preview 0 11/8/2026
5.0.118-preview 0 11/8/2026
5.0.117-preview 49 11/7/2026
5.0.116-preview 50 11/1/2026
5.0.115-preview 104 11/1/2026
5.0.114-preview 37 10/31/2026
5.0.113-preview 38 10/31/2026

# Changelog

## 5.0 (unreleased)

### Breaking

- `MySqlOptions.ConnectionReset` is a `ConnectionResetMode` (was `MySqlConnectionReset`); configuration values are unchanged.

### Changed

- **No reset round trip on every open (behaviour change):** the pool runs with MySqlConnector's `ConnectionReset=false`, and CL.Data resets a connection (`COM_RESET_CONNECTION`, then `SET NAMES utf8mb4` and the database restored) before it returns to the pool only when it may carry session state. Generated queries and writes skip the reset, which halves point-lookup latency against a remote server (get by key against MySQL in Docker Desktop: 1,166 µs → 622 µs, and about 2 KB less allocated per call). Statements that user code prepared through `WithConnectionAsync` keep working: the driver then runs its full reset at the next open.

### Added

- `MySqlOptions.ConnectionReset` (`WhenDirty` default, `Always`, `Never`; overrides a `ConnectionReset` key in the connection string) and `MySqlOptions.ConnectionIdleTimeoutSeconds` (default 180).
- `MySqlDataProvider.MayChangeSession`: the raw-SQL rules (neutral: one `SELECT`/`WITH`/`VALUES`/`TABLE`/`SHOW`/`EXPLAIN`/`DESCRIBE`/`INSERT`/`REPLACE`/`UPDATE`/`DELETE` or DDL statement without user variables, `GET_LOCK`, `TEMPORARY`, `LAST_INSERT_ID`, `SQL_LOG_BIN` or executable comments).

- New package: the MySQL and MariaDB provider for CodeLogic.Data (CL.Data), built on MySqlConnector. Part of the CL.Data
 database framework that replaces CL.MySQL2 in the CodeLogic 5 line. Targets .NET 11 and CodeLogic 5.
- `MySqlDatabaseAdmin` (information_schema.SCHEMATA; CREATE DATABASE with the connection charset/collation); batched deletes with DELETE ... LIMIT.

### Fixed

- The package depends on CodeLogic `[5.0.35-preview, 6.0.0)`; the old `[5.0.0-preview, 6.0.0)` floor let NuGet pick the unsigned 5.0.28-preview (CS0012).
- `OptimizeTableAsync` and `AnalyzeTableAsync` run on the primary as a side effect (`SqlIntent.SideEffect`). Before, they went through the read path and could be sent to a replica or retried.
- The schema introspector always reads the primary.