CodeLogic.Data.SqlServer 5.0.116-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.SqlServer.
This package has a SemVer 2.0.0 package version: 5.0.116-preview+258072a. 
dotnet add package CodeLogic.Data.SqlServer --version 5.0.116-preview
                    


                    

                
NuGet\Install-Package CodeLogic.Data.SqlServer -Version 5.0.116-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.SqlServer" Version="5.0.116-preview" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="CodeLogic.Data.SqlServer" Version="5.0.116-preview" />
                    


                            Directory.Packages.props
                        

                    

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


                            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.SqlServer --version 5.0.116-preview
                    


                    

                
#r "nuget: CodeLogic.Data.SqlServer, 5.0.116-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.SqlServer@5.0.116-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.SqlServer&version=5.0.116-preview&prerelease
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=CodeLogic.Data.SqlServer&version=5.0.116-preview&prerelease
                    


                            Install as a Cake Tool

CodeLogic.Data.SqlServer

Status: 5.0 preview.

The SQL Server and Azure SQL provider for CodeLogic.Data, built on Microsoft.Data.SqlClient.

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

SQL, integrated and Entra ID authentication; bulk copy uses SqlBulkCopy; JSON columns get an ISJSON check; replicas use ApplicationIntent=ReadOnly and report lag from sys.dm_hadr_database_replica_states; multiSubnetFailover and failoverPartner for failover. Extras: db.SqlServer.UpdateStatisticsAsync<T>().

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.116-preview 0 11/1/2026
5.0.115-preview 33 11/1/2026
5.0.114-preview 31 10/31/2026
5.0.113-preview 31 10/31/2026

# Changelog

## 5.0 (unreleased)

### Added

- New package: the SQL Server and Azure SQL provider for CodeLogic.Data (CL.Data), built on Microsoft.Data.SqlClient. Part
 of the CL.Data database framework that replaces CL.MSSQL in the CodeLogic 5 line. Targets .NET 11 and CodeLogic 5.

### Changed

- `Encrypt` and `TrustServerCertificate` written in a connection string are no longer overridden by the `SqlServer` option defaults. An explicit `sslMode` still applies.

### Fixed

- `SqlFn.BucketUtc` works for dates after January 2038. Before, SQL Server failed with an arithmetic overflow (error 8115), because `DATEADD` takes an `int` number of seconds.
- `UpdateStatisticsAsync` runs on the primary as a side effect (`SqlIntent.SideEffect`). Before, it went through the read path and could be sent to a replica.
- The schema introspector always reads the primary.
- `[SqlServerTable]` hints are applied when a table is created: `FileGroup` gives `ON [filegroup]`, `DataCompression` (`NONE`, `ROW`, `PAGE`) gives `WITH (DATA_COMPRESSION = ...)`. Before, they were ignored.
- `sslCaCertificatePath` is rejected by connection validation instead of being ignored: SqlClient only trusts the machine's certificate store. Install the CA there, or pin the server certificate with `Server Certificate=<path>` in the connection string.
- Dropping a column with a default constraint quotes the catalog's constraint name with `QUOTENAME`, and both that statement and column renames (`sp_rename`) address the table with quoted names. Before, a constraint or table name holding `]` or `.` broke out of the generated SQL or resolved to another object.