Announcement: System.Data.SqlClient package is now deprecated

Microsoft. Data.SqlClient 5.2 preview 4 is out, and includes the new high performance SqlBatch API: execute multiple commands in a single network roundtrip 

ADO.Net has a very tedious API out of the box, so Weasel alleviates that with quite a few extension methods to make your code a little quicker to write and hopefully much easier to read later as well. 

• Added support for .NET 6.0. #1704
• Added support for DateOnly and TimeOnly for SqlParameter value and GetFieldValue. #1813
• Added support for TLS 1.3 on .NET Core and native SNI. #1821
• Added ServerCertificate setting for Encrypt=Mandatory or Encrypt=Strict. #1822 Read more
• Added Windows ARM64 support when targeting .NET Framework. #1828  

Use dependency injection and .NET logging with Microsoft.Data.SqlClient 

This package helps set up SqlClient in applications using dependency injection, notably ASP.NET and Worker Service applications. It allows easy configuration of your database connections and registers the appropriate services in your DI container. It also enables you to log events from Microsoft.Data.SqlClient using standard .NET logging (ILogger). 

The .NET 6 solution to this is the new DbBatch class. The goals in the Batching API proposal are;

• Provide a structured way to execute multiple SQL statements in a single roundtrip, without any need for client-side parsing of SQL. 

Fixed

• Fixed Kerberos authentication failure when using .NET 6. #1411
• Fixed connection failure when using SqlLocalDB instance pipe name. #1433
• Fixed a failure when executing concurrent queries requiring enclaves. #1451
• Updated obsolete API calls targeting .NET 6. #1401

Changed

• Added AppContext switch SuppressInsecureTLSWarning to allow suppression of TLS security warning when using Encrypt=false in the connection string. #1457  

server=.;database=LicenseManager;integrated security=True;Encrypt=False"

Microsoft.Data.SqlClient 4.0 Preview 1 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider for SQL Server.