Announcement: System.Data.SqlClient package is now deprecated

we Announcing Microsoft.Data.SqlClient In the first half of 2019 We shipped the first stable one The package was released later that year. That release Concurrent with .NET Core 3.0. We have been developing Microsoft.Data.SqlClient at dotnet/SqlClient The repo has been around for the past 5 years. It’s time to start the deprecation process. System.Data.SqlClient Packages. We plan to proceed with a phased process of deprecation to align support changes and related code transition activities between these libraries with natural migration points between major versions of .NET.

All System.Data.SqlClient users are encouraged to migrate to Microsoft.Data.SqlClient, which provides improvements and significantly better support over the Microsoft.Data.SqlClient package.

plan

The System.Data.SqlClient package will be phased out.

• Prior to .NET 9 GA:
  • We are publishing a new 5.0.0 package with the following changes:
  • Removes support for .NET 7 and earlier and .NET Framework 4.6.1 and earlier.
  • Publish assets for the following target frameworks: .NET 8, .NET Framework 4.6.2, .NET Standard 2.0.
  • add Deprecated properties With .NET 8 and .NET Standard 2.0 assets. This will create new warnings for .NET 8+ and .NET Standard users.
  • We will continue to provide security services for users of .NET 8 and .NET Framework 4.6.2+ applications.
• .NET 9 GA and later:
  • No change
  • This package is not supported for users of .NET 9+ applications.
• After .NET 8 EOL:
  • Remove support for .NET 8 users (.NET 8 libraries will be removed).
  • Maintains support for users of .NET Framework 4.6.2 and later.
  • From that point on, security services will be provided through the .NET Framework rather than through packages.
  • We will not be updating the package again after this point.
  • This package is not marked as deprecated because it only supports .NET Framework users who use the implementation provided by the .NET Framework.

During various phases of this deprecation plan, we will remove package support for unsupported .NET and .NET Framework versions. Users affected by these changes are encouraged to move to supported .NET or .NET Framework versions and adopt the Microsoft.Data.SqlClient package.

We decided to remove support for .NET 6 as it will be EOL shortly after this new package is released, but .NET 6 will still be supported at that time. Publishing a .NET 8 library simplifies our planning considerably in terms of what we have to ship and what we have to describe.

For .NET dates, see: .NET release. .NET 9 is November GA This year, .NET 8 will reach EOL in November 2026.

Current package version System.Data.SqlClient At the time of writing, it was 4.8.6. These changes will be made in version 5.0.0 and later.

memo: This deprecation does not apply to the System.Data.SqlClient namespace in the .NET Framework.

Microsoft.Data.SqlClient

Microsoft.Data.SqlClient’s daily downloads on nuget.org are nearly 50% higher than System.Data.SqlClient’s. I expect the usage gap between the two libraries to continue to grow. Microsoft.Data.SqlClient is the best library available for accessing SQL Server.

We are committed to providing high-quality, performance-oriented, and secure data access technology. We strongly encourage our users to migrate to Microsoft.Data.SqlClient, which is actively maintained and supports the latest SQL Server features.

How do I migrate?

Add the NuGet package to your project, then update the references and usage statements. Porting Cheat Sheet Provides step-by-step instructions on what to change.

1. Update your project references: Replace references to System.Data.SqlClient with Microsoft.Data.SqlClient.
2. Please correct the sentence you are using: Update the using statements in your code files from System.Data.SqlClient to Microsoft.Data.SqlClient.
3. Test your application: After migration, test your application thoroughly to ensure it works as expected.

We are also planning Supports semi-automatic migration Through ~ .NET Upgrade Assistant.

Support & Feedback: If you have any questions or need assistance with the above, please contact us. Official Support Channels Or join our discussion GitHub Repository.

resources