<PackageReference Include="Microsoft.Data.SqlClient" Version="7.1.1" />

---

API Differences between 7.1.1 and 7.0.0-preview4.26064.3

79 Additions 4 Removals

Microsoft.Data.SqlClient

• public enum RegisteredApplication
  • AspNetCoreDistributedSqlServerCache = 7
  • AzureFunctionsSqlExtension = 9
  • DataApiBuilder = 13
  • DataTierApplicationFramework = 5
  • DurableTaskSqlServer = 11
  • EntityFramework = 8
  • EntityFrameworkCore = 1
  • ManagementStudio = 3
  • OrleansAdoNet = 10
  • SemanticKernel = 2
  • SqlManagementObjects = 4
  • SqlPackage = 12
  • SqlToolsService = 6
  • Unknown = 0
• public class SqlBatch : IAsyncDisposable, IDisposable
  • 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, 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(CommandBehavior behavior, CancellationToken cancellationToken = default)
  • public Task<SqlDataReader> ExecuteReaderAsync(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; set; }
  • public SqlCommandColumnEncryptionSetting ColumnEncryptionSetting { get; set; }
  • public CommandBehavior CommandBehavior { get; set; }
  • public string CommandText { get; set; }
  • public CommandType CommandType { get; set; }
  • protected virtual DbParameterCollection DbParameterCollection { get; }
  • public SqlParameterCollection Parameters { get; }
  • public int RecordsAffected { get; }
  • public SqlBatchCommand()
  • public SqlBatchCommand(string commandText, CommandType commandType = 1, IEnumerable<SqlParameter> parameters = null, SqlCommandColumnEncryptionSetting columnEncryptionSetting = 0)
  • public DbParameter CreateParameter()
• public class SqlBatchCommandCollection : ICollection<SqlBatchCommand>, IEnumerable<SqlBatchCommand>, IEnumerable, IList<SqlBatchCommand>
  • public int Count { get; }
  • public bool IsReadOnly { get; }
  • public SqlBatchCommand this[int index] { get; set; }
  • public SqlBatchCommandCollection()
  • 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 WriteToServer(DataRow[] rows)
  • public void WriteToServer(DataRow[] rows)
• public abstract class SqlColumnEncryptionKeyStoreProvider
  • public virtual Task<byte[]> DecryptColumnEncryptionKeyAsync(string masterKeyPath, string encryptionAlgorithm, byte[] encryptedColumnEncryptionKey, CancellationToken cancellationToken = default)
  • public virtual Task<byte[]> EncryptColumnEncryptionKeyAsync(string masterKeyPath, string encryptionAlgorithm, byte[] columnEncryptionKey, CancellationToken cancellationToken = default)
  • public virtual Task<byte[]> SignColumnMasterKeyMetadataAsync(string masterKeyPath, bool allowEnclaveComputations, CancellationToken cancellationToken = default)
  • public virtual Task<bool> VerifyColumnMasterKeyMetadataAsync(string masterKeyPath, bool allowEnclaveComputations, byte[] signature, CancellationToken cancellationToken = default)
• public sealed class SqlConnection : DbConnection, ICloneable
  • public RegisteredApplication RegisteredApplication { get; set; }
  • public Task<DataTable> GetSchemaAsync(string collectionName, string[] restrictionValues, CancellationToken cancellationToken = default)
  • public Task<DataTable> GetSchemaAsync(string collectionName, CancellationToken cancellationToken = default)
  • public Task<DataTable> GetSchemaAsync(CancellationToken cancellationToken = default)
• public sealed class SqlConnectionEncryptOption
  • public static SqlConnectionEncryptOption op_Implicit(bool value)
  • public static SqlConnectionEncryptOption op_Implicit(bool value)
• public sealed class SqlConnectionStringBuilder : DbConnectionStringBuilder
  • public int IdleTimeout { get; set; }
• public sealed class SqlErrorCollection : ICollection, IEnumerable
  • public void CopyTo(Array array, int index)
  • public void CopyTo(Array array, int index)
• public sealed class SqlException : DbException
  • public SqlBatchCommand BatchCommand { get; }
• public abstract class SqlRetryLogicBaseProvider
  • public abstract Task<TResult> ExecuteAsync<TResult>(object sender, Func<Task<TResult>> function, CancellationToken cancellationToken = default)
  • public abstract Task<TResult> ExecuteAsync<TResult>(object sender, Func<Task<TResult>> function, CancellationToken cancellationToken = default)