Home
%3CLINGO-SUB%20id%3D%22lingo-sub-1250891%22%20slang%3D%22en-US%22%3EReleased%3A%20Microsoft.Data.SqlClient%202.0%20Preview%202%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1250891%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20SqlClient%20team%20is%20moving%20forward%20with%20continuous%20updates%20and%20improvements%20to%20the%20Microsoft.Data.SqlClient%20data%20provider%20for%20SQL%20Server.%20Our%20plan%20is%20to%20provide%20GA%20releases%20twice%20a%20year%20with%20two%20preview%20releases%20in%20between.%20This%20cadence%20should%20provide%20time%20for%20feedback%20and%20allow%20us%20to%20deliver%20features%20and%20fixes%20in%20a%20timely%20manner.%20This%20second%202.0%20preview%20includes%20over%20a%20dozen%20fixes%20and%20changes%20over%20the%20previous%201.1%20GA%20release.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20of%20the%20main%20changes%20to%20note%2C%20is%20related%20to%20security%20and%20is%20likely%20to%20be%20a%20breaking%20change%20to%20clients%20if%20they%20rely%20on%20the%20previous%20default%20settings%20and%20encryption%20is%20enforced%20a%20server%20with%20an%20invalid%20certificate.%20SqlClient%20will%20now%20validate%20server%20certificates%20by%20default%20if%20encryption%20is%20enforced%20from%20the%20server%20side%20but%20the%20client%20has%20not%20specified%20Encrypt%3Dtrue.%20If%20this%20breaks%20your%20clients%2C%20your%20options%20are%20to%20use%20a%20certificate%20on%20the%20server%20which%20is%20part%20of%20your%20client's%20trust%20chain%20(recommended)%20or%20to%20change%20your%20clients%20to%20use%20TrustServerCertificate%3Dtrue%20(not%20recommended).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20the%20full%20list%20of%20changes%20in%20Microsoft.Data.SqlClient%202.0%20Preview%202%2C%20please%20see%20the%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fdotnet%2FSqlClient%2Fblob%2Fmaster%2Frelease-notes%2F2.0%2F2.0.0-preview2.md%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ERelease%20Notes%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20try%20out%20the%20new%20package%2C%20add%20a%20%3CA%20href%3D%22https%3A%2F%2Fwww.nuget.org%2Fpackages%2FMicrosoft.Data.SqlClient%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3ENuGet%20reference%20to%20Microsoft.Data.SqlClient%3C%2FA%3E%26nbsp%3Bin%20your%20application%20and%20pick%20the%202.0%20preview%202%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20appreciate%20the%20time%20and%20effort%20you%20spend%20checking%20out%20our%20previews.%20It%20makes%20the%20final%20product%20that%20much%20better.%20If%20you%20encounter%20any%20issues%20or%20have%20any%20feedback%2C%20head%20over%20to%20the%20SqlClient%20GitHub%20repository%20and%20submit%20an%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDavid%20Engel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1250891%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20SqlClient%20team%20is%20moving%20forward%20with%20continuous%20updates%20and%20improvements%20to%20the%20Microsoft.Data.SqlClient%20data%20provider%20for%20SQL%20Server.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1250891%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Senior Member

The SqlClient team is moving forward with continuous updates and improvements to the Microsoft.Data.SqlClient data provider for SQL Server. Our plan is to provide GA releases twice a year with two preview releases in between. This cadence should provide time for feedback and allow us to deliver features and fixes in a timely manner. This second 2.0 preview includes over a dozen fixes and changes over the previous 1.1 GA release.

 

One of the main changes to note, is related to security and is likely to be a breaking change to clients if they rely on the previous default settings and encryption is enforced a server with an invalid certificate. SqlClient will now validate server certificates by default if encryption is enforced from the server side but the client has not specified Encrypt=true. If this breaks your clients, your options are to use a certificate on the server which is part of your client's trust chain (recommended) or to change your clients to use TrustServerCertificate=true (not recommended).

 

For the full list of changes in Microsoft.Data.SqlClient 2.0 Preview 2, please see the Release Notes.

 

To try out the new package, add a NuGet reference to Microsoft.Data.SqlClient in your application and pick the 2.0 preview 2 version.

 

We appreciate the time and effort you spend checking out our previews. It makes the final product that much better. If you encounter any issues or have any feedback, head over to the SqlClient GitHub repository and submit an issue.

 

David Engel