Microsoft.Data.SqlClient 7.1.0

API Differences between 7.1.0 and 7.0.0-preview3.25342.7

93 Additions 9 Removals

Microsoft.Data.SqlClient

public sealed class ActiveDirectoryAuthenticationProvider : SqlAuthenticationProvider
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 enum SqlAuthenticationMethod
public class SqlAuthenticationParameters
public abstract class SqlAuthenticationProvider
public class SqlAuthenticationToken
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 ClearCachedMetadata()
- public void WriteToServer(DataRow[] rows)
- public void WriteToServer(DataRow[] rows)
public enum SqlBulkCopyOptions
- CacheMetadata = 128
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 SqlConfigurableRetryFactory
- public static ReadOnlyCollection<int> BaselineTransientErrors { get; }
public sealed class SqlConnection : DbConnection, ICloneable
- public RegisteredApplication RegisteredApplication { get; set; }
- public SspiContextProvider SspiContextProvider { 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)
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)