Skip to content

Latest commit

 

History

History
118 lines (94 loc) · 4.82 KB

4.0.0-preview3.md

File metadata and controls

118 lines (94 loc) · 4.82 KB
Raw

Release Notes

Microsoft.Data.SqlClient 4.0.0-preview3.21293.2 released 20 October 2021

This update brings the below changes over the previous release:

Breaking changes over preview release v4.0.0-preview2

  • Dropped support for .NET Core 2.1 #1272
  • [.NET Framework] Exception will not be thrown if a User ID is provided in the connection string when using Active Directory Integrated authentication #1359

Added

  • Add GetFieldValueAsync<T> and GetFieldValue<T> support for XmlReader, TextReader, Stream #1019. Read more

Fixed

  • Fixed FormatException when opening a connection with event tracing enabled #1291
  • Fixed improper initialization of ActiveDirectoryAuthenticationProvider #1328
  • Fixed MissingMethodException when accessing SqlAuthenticationParameters.ConnectionTimeout #1336
  • Fixed data corruption issues by reverting changes to async cancellations #1352
  • Fixed performance degradation by reverting changes to MARS state machine #1357
  • Fixed bug where environment variables are ignored when using Active Directory Default authentication #1360

Changed

  • Removed attributes for classes used in Microsoft.VSDesigner due to lack of support for Microsoft.Data.SqlClient #1296
  • Disable encryption when connecting to SQL LocalDB #1312
  • Various code health and performance improvements. See milestone for more info.

New features over preview release v4.0.0-preview2

GetFieldValueAsync<T> and GetFieldValue<T> support for XmlReader, TextReader, Stream types

XmlReader, TextReader, Stream types are now supported when using GetFieldValueAsync<T> and GetFieldValue<T>.

Example usage:

using (SqlConnection connection = new SqlConnection(connectionString))
{
    using (SqlCommand command = new SqlCommand(query, connection))
    {
        connection.Open();
        using (SqlDataReader reader = await command.ExecuteReaderAsync())
        {
            if (await reader.ReadAsync())
            {
                using (Stream stream = await reader.GetFieldValueAsync<Stream>(1))
                {
                    // Continue to read from stream
                }
            }
        }
    }
}

Target Platform Support

  • .NET Framework 4.6.1+ (Windows x86, Windows x64)
  • .NET Core 3.1+ (Windows x86, Windows x64, Windows ARM64, Windows ARM, Linux, macOS)
  • .NET Standard 2.0+ (Windows x86, Windows x64, Windows ARM64, Windows ARM, Linux, macOS)

Dependencies

.NET Framework

  • Microsoft.Data.SqlClient.SNI 4.0.0-preview1.21232.1
  • Azure.Identity 1.3.0
  • Microsoft.Identity.Client 4.22.0
  • Microsoft.IdentityModel.JsonWebTokens 6.8.0
  • Microsoft.IdentityModel.Protocols.OpenIdConnect 6.8.0
  • System.Buffers 4.5.1
  • System.Configuration.ConfigurationManager 5.0.0
  • System.IO 4.3.0
  • System.Runtime.InteropServices.RuntimeInformation 4.3.0
  • System.Security.Cryptography.Algorithms 4.3.1
  • System.Security.Cryptography.Primitives 4.3.0
  • System.Text.Encodings.Web 4.7.2

.NET Core

  • Microsoft.Data.SqlClient.SNI.runtime 4.0.0-preview1.21232.1
  • Azure.Identity 1.3.0
  • Microsoft.Identity.Client 4.22.0
  • Microsoft.IdentityModel.Protocols.OpenIdConnect 6.8.0
  • Microsoft.IdentityModel.JsonWebTokens 6.8.0
  • Microsoft.Win32.Registry 5.0.0
  • System.Buffers 4.5.1
  • System.Configuration.ConfigurationManager 5.0.0
  • System.Diagnostics.DiagnosticSource 5.0.0
  • System.IO 4.3.0
  • System.Runtime.Caching 5.0.0
  • System.Text.Encoding.CodePages 5.0.0
  • System.Text.Encodings.Web 4.7.2
  • System.Resources.ResourceManager 4.3.0
  • System.Security.Cryptography.Cng 5.0.0
  • System.Security.Principal.Windows 5.0.0

.NET Standard

  • Microsoft.Data.SqlClient.SNI.runtime 4.0.0-preview1.21232.1
  • Azure.Identity 1.3.0
  • Microsoft.Identity.Client 4.22.0
  • Microsoft.IdentityModel.Protocols.OpenIdConnect 6.8.0
  • Microsoft.IdentityModel.JsonWebTokens 6.8.0
  • Microsoft.Win32.Registry 5.0.0
  • System.Buffers 4.5.1
  • System.Configuration.ConfigurationManager 5.0.0
  • System.IO 4.3.0
  • System.Runtime.Caching 5.0.0
  • System.Text.Encoding.CodePages 5.0.0
  • System.Text.Encodings.Web 4.7.2
  • System.Resources.ResourceManager 4.3.0
  • System.Runtime.Loader 4.3.0
  • System.Security.Cryptography.Cng 5.0.0
  • System.Security.Principal.Windows 5.0.0