<PackageReference Include="Microsoft.Data.SqlClient" Version="7.1.0-preview2.26190.5" />

---

API Differences between 7.1.0-preview2.26190.5 and 7.0.0-preview2.25289.6

58 Additions 7 Removals

Interop.Windows.Kernel32

• public enum IoControlCodeAccess
• public enum IoControlTransferType

Microsoft.Data.SqlClient

• public sealed class ActiveDirectoryAuthenticationProvider : SqlAuthenticationProvider
• public enum SqlAuthenticationMethod
• public class SqlAuthenticationParameters
• public abstract class SqlAuthenticationProvider
• public class SqlAuthenticationToken
• public class SqlBatch : IDisposable, IAsyncDisposable
  • public SqlBatchCommandCollection BatchCommands { get; }
  • public List<SqlBatchCommand> Commands { get; }
  • public SqlConnection Connection { get; set; }
  • protected virtual DbConnection DbConnection { get; protected set; }
  • protected virtual DbTransaction DbTransaction { get; protected set; }
  • public int Timeout { get; set; }
  • public SqlTransaction Transaction { get; set; }
  • public SqlBatch()
  • public SqlBatch(SqlConnection connection = null, SqlTransaction transaction = null)
  • public void Cancel()
  • public void Dispose()
  • public virtual ValueTask DisposeAsync()
  • protected virtual DbDataReader ExecuteDbDataReader(CommandBehavior behavior)
  • protected virtual Task<DbDataReader> ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
  • public int ExecuteNonQuery()
  • public Task<int> ExecuteNonQueryAsync(CancellationToken cancellationToken = default)
  • public SqlDataReader ExecuteReader()
  • public SqlDataReader ExecuteReader(CommandBehavior behavior)
  • public Task<SqlDataReader> ExecuteReaderAsync(CancellationToken cancellationToken = default)
  • public Task<SqlDataReader> ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken = default)
  • public object ExecuteScalar()
  • public Task<object> ExecuteScalarAsync(CancellationToken cancellationToken = default)
  • public void Prepare()
  • public Task PrepareAsync(CancellationToken cancellationToken = default)
• public class SqlBatchCommand
  • public bool CanCreateParameter { get; }
  • public DbParameter CreateParameter()
• public class SqlBatchCommandCollection : IList<SqlBatchCommand>, ICollection<SqlBatchCommand>, IEnumerable<SqlBatchCommand>, IEnumerable
  • public int Count { get; }
  • public bool IsReadOnly { get; }
  • public SqlBatchCommand this[int index] { get; set; }
  • public void Add(SqlBatchCommand item)
  • public void Clear()
  • public bool Contains(SqlBatchCommand item)
  • public void CopyTo(SqlBatchCommand[] array, int arrayIndex)
  • public int IndexOf(SqlBatchCommand item)
  • public void Insert(int index, SqlBatchCommand item)
  • public bool Remove(SqlBatchCommand item)
  • public void RemoveAt(int index)
• public sealed class SqlBulkCopy : IDisposable
  • public void ClearCachedMetadata()
• public enum SqlBulkCopyOptions
  • CacheMetadata = 128
• public sealed class SqlConfigurableRetryFactory
  • public static ReadOnlyCollection<int> BaselineTransientErrors { get; }
• public sealed class SqlConnection : DbConnection, ICloneable
  • public SspiContextProvider SspiContextProvider { get; set; }
  • public Task<DataTable> GetSchemaAsync(CancellationToken cancellationToken = default)
  • public Task<DataTable> GetSchemaAsync(string collectionName, CancellationToken cancellationToken = default)
  • public Task<DataTable> GetSchemaAsync(string collectionName, string[] restrictionValues, CancellationToken cancellationToken = default)
• public sealed class SqlConnectionStringBuilder : DbConnectionStringBuilder
  • public int IdleTimeout { get; set; }
• public sealed class SqlException : DbException
  • public SqlBatchCommand BatchCommand { get; }
• public sealed class SspiAuthenticationParameters
  • public string DatabaseName { get; }
  • public string Password { get; }
  • public string Resource { get; }
  • public string ServerName { get; }
  • public string UserId { get; }
  • public SspiAuthenticationParameters(string serverName, string resource, string userId = null, string databaseName = null, string password = null)
• public abstract class SspiContextProvider
  • protected SspiContextProvider()
  • protected abstract bool GenerateContext(ReadOnlySpan<byte> incomingBlob, IBufferWriter<byte> outgoingBlobWriter, SspiAuthenticationParameters authParams)