<PackageReference Include="System.Data.SqlClient" Version="4.6.1" />

---

API Differences between 4.6.1 and 1.0.0-beta2

574 Additions 1 Removals

Microsoft.SqlServer.Server

• public enum DataAccessKind
  • None = 0
  • Read = 1
• public enum Format
  • Native = 1
  • Unknown = 0
  • UserDefined = 2
• public interface IBinarySerialize
  • void Read(BinaryReader r)
  • void Write(BinaryWriter w)
• public sealed class InvalidUdtException : SystemException
• public class SqlDataRecord : IDataRecord
  • public virtual int FieldCount { get; }
  • public virtual object this[int ordinal] { get; }
  • public virtual object this[string name] { get; }
  • public SqlDataRecord(SqlMetaData[] metaData)
  • public virtual bool GetBoolean(int ordinal)
  • public virtual byte GetByte(int ordinal)
  • public virtual long GetBytes(int ordinal, long fieldOffset, byte[] buffer, int bufferOffset, int length)
  • public virtual char GetChar(int ordinal)
  • public virtual long GetChars(int ordinal, long fieldOffset, char[] buffer, int bufferOffset, int length)
  • public virtual string GetDataTypeName(int ordinal)
  • public virtual DateTime GetDateTime(int ordinal)
  • public virtual DateTimeOffset GetDateTimeOffset(int ordinal)
  • public virtual decimal GetDecimal(int ordinal)
  • public virtual double GetDouble(int ordinal)
  • public virtual Type GetFieldType(int ordinal)
  • public virtual float GetFloat(int ordinal)
  • public virtual Guid GetGuid(int ordinal)
  • public virtual short GetInt16(int ordinal)
  • public virtual int GetInt32(int ordinal)
  • public virtual long GetInt64(int ordinal)
  • public virtual string GetName(int ordinal)
  • public virtual int GetOrdinal(string name)
  • public virtual SqlBinary GetSqlBinary(int ordinal)
  • public virtual SqlBoolean GetSqlBoolean(int ordinal)
  • public virtual SqlByte GetSqlByte(int ordinal)
  • public virtual SqlBytes GetSqlBytes(int ordinal)
  • public virtual SqlChars GetSqlChars(int ordinal)
  • public virtual SqlDateTime GetSqlDateTime(int ordinal)
  • public virtual SqlDecimal GetSqlDecimal(int ordinal)
  • public virtual SqlDouble GetSqlDouble(int ordinal)
  • public virtual Type GetSqlFieldType(int ordinal)
  • public virtual SqlGuid GetSqlGuid(int ordinal)
  • public virtual SqlInt16 GetSqlInt16(int ordinal)
  • public virtual SqlInt32 GetSqlInt32(int ordinal)
  • public virtual SqlInt64 GetSqlInt64(int ordinal)
  • public virtual SqlMetaData GetSqlMetaData(int ordinal)
  • public virtual SqlMoney GetSqlMoney(int ordinal)
  • public virtual SqlSingle GetSqlSingle(int ordinal)
  • public virtual SqlString GetSqlString(int ordinal)
  • public virtual object GetSqlValue(int ordinal)
  • public virtual int GetSqlValues(object[] values)
  • public virtual SqlXml GetSqlXml(int ordinal)
  • public virtual string GetString(int ordinal)
  • public virtual TimeSpan GetTimeSpan(int ordinal)
  • public virtual object GetValue(int ordinal)
  • public virtual int GetValues(object[] values)
  • public virtual bool IsDBNull(int ordinal)
  • public virtual void SetBoolean(int ordinal, bool value)
  • public virtual void SetByte(int ordinal, byte value)
  • public virtual void SetBytes(int ordinal, long fieldOffset, byte[] buffer, int bufferOffset, int length)
  • public virtual void SetChar(int ordinal, char value)
  • public virtual void SetChars(int ordinal, long fieldOffset, char[] buffer, int bufferOffset, int length)
  • public virtual void SetDateTime(int ordinal, DateTime value)
  • public virtual void SetDateTimeOffset(int ordinal, DateTimeOffset value)
  • public virtual void SetDBNull(int ordinal)
  • public virtual void SetDecimal(int ordinal, decimal value)
  • public virtual void SetDouble(int ordinal, double value)
  • public virtual void SetFloat(int ordinal, float value)
  • public virtual void SetGuid(int ordinal, Guid value)
  • public virtual void SetInt16(int ordinal, short value)
  • public virtual void SetInt32(int ordinal, int value)
  • public virtual void SetInt64(int ordinal, long value)
  • public virtual void SetSqlBinary(int ordinal, SqlBinary value)
  • public virtual void SetSqlBoolean(int ordinal, SqlBoolean value)
  • public virtual void SetSqlByte(int ordinal, SqlByte value)
  • public virtual void SetSqlBytes(int ordinal, SqlBytes value)
  • public virtual void SetSqlChars(int ordinal, SqlChars value)
  • public virtual void SetSqlDateTime(int ordinal, SqlDateTime value)
  • public virtual void SetSqlDecimal(int ordinal, SqlDecimal value)
  • public virtual void SetSqlDouble(int ordinal, SqlDouble value)
  • public virtual void SetSqlGuid(int ordinal, SqlGuid value)
  • public virtual void SetSqlInt16(int ordinal, SqlInt16 value)
  • public virtual void SetSqlInt32(int ordinal, SqlInt32 value)
  • public virtual void SetSqlInt64(int ordinal, SqlInt64 value)
  • public virtual void SetSqlMoney(int ordinal, SqlMoney value)
  • public virtual void SetSqlSingle(int ordinal, SqlSingle value)
  • public virtual void SetSqlString(int ordinal, SqlString value)
  • public virtual void SetSqlXml(int ordinal, SqlXml value)
  • public virtual void SetString(int ordinal, string value)
  • public virtual void SetTimeSpan(int ordinal, TimeSpan value)
  • public virtual void SetValue(int ordinal, object value)
  • public virtual int SetValues(object[] values)
• public class SqlFunctionAttribute : Attribute
  • public DataAccessKind DataAccess { get; set; }
  • public string FillRowMethodName { get; set; }
  • public bool IsDeterministic { get; set; }
  • public bool IsPrecise { get; set; }
  • public string Name { get; set; }
  • public SystemDataAccessKind SystemDataAccess { get; set; }
  • public string TableDefinition { get; set; }
  • public SqlFunctionAttribute()
• public sealed class SqlMetaData
  • public static long Max { get; }
  • public SqlCompareOptions CompareOptions { get; }
  • public DbType DbType { get; }
  • public bool IsUniqueKey { get; }
  • public long LocaleId { get; }
  • public long MaxLength { get; }
  • public string Name { get; }
  • public byte Precision { get; }
  • public byte Scale { get; }
  • public SortOrder SortOrder { get; }
  • public int SortOrdinal { get; }
  • public SqlDbType SqlDbType { get; }
  • public Type Type { get; }
  • public string TypeName { get; }
  • public bool UseServerDefault { get; }
  • public string XmlSchemaCollectionDatabase { get; }
  • public string XmlSchemaCollectionName { get; }
  • public string XmlSchemaCollectionOwningSchema { get; }
  • public SqlMetaData(string name, SqlDbType dbType)
  • public SqlMetaData(string name, SqlDbType dbType, bool useServerDefault, bool isUniqueKey, SortOrder columnSortOrder, int sortOrdinal)
  • public SqlMetaData(string name, SqlDbType dbType, byte precision, byte scale)
  • public SqlMetaData(string name, SqlDbType dbType, byte precision, byte scale, bool useServerDefault, bool isUniqueKey, SortOrder columnSortOrder, int sortOrdinal)
  • public SqlMetaData(string name, SqlDbType dbType, long maxLength)
  • public SqlMetaData(string name, SqlDbType dbType, long maxLength, bool useServerDefault, bool isUniqueKey, SortOrder columnSortOrder, int sortOrdinal)
  • public SqlMetaData(string name, SqlDbType dbType, long maxLength, byte precision, byte scale, long locale, SqlCompareOptions compareOptions, Type userDefinedType)
  • public SqlMetaData(string name, SqlDbType dbType, long maxLength, byte precision, byte scale, long localeId, SqlCompareOptions compareOptions, Type userDefinedType, bool useServerDefault, bool isUniqueKey, SortOrder columnSortOrder, int sortOrdinal)
  • public SqlMetaData(string name, SqlDbType dbType, long maxLength, long locale, SqlCompareOptions compareOptions)
  • public SqlMetaData(string name, SqlDbType dbType, long maxLength, long locale, SqlCompareOptions compareOptions, bool useServerDefault, bool isUniqueKey, SortOrder columnSortOrder, int sortOrdinal)
  • public SqlMetaData(string name, SqlDbType dbType, string database, string owningSchema, string objectName)
  • public SqlMetaData(string name, SqlDbType dbType, string database, string owningSchema, string objectName, bool useServerDefault, bool isUniqueKey, SortOrder columnSortOrder, int sortOrdinal)
  • public SqlMetaData(string name, SqlDbType dbType, Type userDefinedType)
  • public SqlMetaData(string name, SqlDbType dbType, Type userDefinedType, string serverTypeName)
  • public SqlMetaData(string name, SqlDbType dbType, Type userDefinedType, string serverTypeName, bool useServerDefault, bool isUniqueKey, SortOrder columnSortOrder, int sortOrdinal)
  • public static SqlMetaData InferFromValue(object value, string name)
  • public bool Adjust(bool value)
  • public byte Adjust(byte value)
  • public byte[] Adjust(byte[] value)
  • public char Adjust(char value)
  • public char[] Adjust(char[] value)
  • public SqlBinary Adjust(SqlBinary value)
  • public SqlBoolean Adjust(SqlBoolean value)
  • public SqlByte Adjust(SqlByte value)
  • public SqlBytes Adjust(SqlBytes value)
  • public SqlChars Adjust(SqlChars value)
  • public SqlDateTime Adjust(SqlDateTime value)
  • public SqlDecimal Adjust(SqlDecimal value)
  • public SqlDouble Adjust(SqlDouble value)
  • public SqlGuid Adjust(SqlGuid value)
  • public SqlInt16 Adjust(SqlInt16 value)
  • public SqlInt32 Adjust(SqlInt32 value)
  • public SqlInt64 Adjust(SqlInt64 value)
  • public SqlMoney Adjust(SqlMoney value)
  • public SqlSingle Adjust(SqlSingle value)
  • public SqlString Adjust(SqlString value)
  • public SqlXml Adjust(SqlXml value)
  • public DateTime Adjust(DateTime value)
  • public DateTimeOffset Adjust(DateTimeOffset value)
  • public decimal Adjust(decimal value)
  • public double Adjust(double value)
  • public Guid Adjust(Guid value)
  • public short Adjust(short value)
  • public int Adjust(int value)
  • public long Adjust(long value)
  • public object Adjust(object value)
  • public float Adjust(float value)
  • public string Adjust(string value)
  • public TimeSpan Adjust(TimeSpan value)
• public sealed class SqlMethodAttribute : SqlFunctionAttribute
  • public bool InvokeIfReceiverIsNull { get; set; }
  • public bool IsMutator { get; set; }
  • public bool OnNullCall { get; set; }
  • public SqlMethodAttribute()
• public sealed class SqlUserDefinedAggregateAttribute : Attribute
  • public const int MaxByteSizeValue = 8000
  • public Format Format { get; }
  • public bool IsInvariantToDuplicates { get; set; }
  • public bool IsInvariantToNulls { get; set; }
  • public bool IsInvariantToOrder { get; set; }
  • public bool IsNullIfEmpty { get; set; }
  • public int MaxByteSize { get; set; }
  • public string Name { get; set; }
  • public SqlUserDefinedAggregateAttribute(Format format)
• public sealed class SqlUserDefinedTypeAttribute : Attribute
  • public Format Format { get; }
  • public bool IsByteOrdered { get; set; }
  • public bool IsFixedLength { get; set; }
  • public int MaxByteSize { get; set; }
  • public string Name { get; set; }
  • public string ValidationMethodName { get; set; }
  • public SqlUserDefinedTypeAttribute(Format format)
• public enum SystemDataAccessKind
  • None = 0
  • Read = 1

System.Data

• public enum KeyRestrictionBehavior
• public sealed class OperationAbortedException : SystemException

System.Data.Sql

• public sealed class SqlNotificationRequest
  • public string Options { get; set; }
  • public int Timeout { get; set; }
  • public string UserData { get; set; }
  • public SqlNotificationRequest()
  • public SqlNotificationRequest(string userData, string options, int timeout)

System.Data.SqlClient

• public enum ApplicationIntent
  • ReadOnly = 1
  • ReadWrite = 0
• public sealed delegate OnChangeEventHandler : MulticastDelegate
  • public OnChangeEventHandler(object object, IntPtr method)
  • public virtual IAsyncResult BeginInvoke(object sender, SqlNotificationEventArgs e, AsyncCallback callback, object object)
  • public virtual void EndInvoke(IAsyncResult result)
  • public virtual void Invoke(object sender, SqlNotificationEventArgs e)
• public enum SortOrder
  • Ascending = 0
  • Descending = 1
  • Unspecified = -1
• public sealed class SqlBulkCopy : IDisposable
  • public int BatchSize { get; set; }
  • public int BulkCopyTimeout { get; set; }
  • public SqlBulkCopyColumnMappingCollection ColumnMappings { get; }
  • public string DestinationTableName { get; set; }
  • public bool EnableStreaming { get; set; }
  • public int NotifyAfter { get; set; }
  • public event SqlRowsCopiedEventHandler SqlRowsCopied
  • public SqlBulkCopy(SqlConnection connection)
  • public SqlBulkCopy(SqlConnection connection, SqlBulkCopyOptions copyOptions, SqlTransaction externalTransaction)
  • public SqlBulkCopy(string connectionString)
  • public SqlBulkCopy(string connectionString, SqlBulkCopyOptions copyOptions)
  • public void Close()
  • public void WriteToServer(DbDataReader reader)
  • public void WriteToServer(DataRow[] rows)
  • public void WriteToServer(DataTable table)
  • public void WriteToServer(DataTable table, DataRowState rowState)
  • public void WriteToServer(IDataReader reader)
  • public Task WriteToServerAsync(DbDataReader reader)
  • public Task WriteToServerAsync(DbDataReader reader, CancellationToken cancellationToken)
  • public Task WriteToServerAsync(DataRow[] rows)
  • public Task WriteToServerAsync(DataRow[] rows, CancellationToken cancellationToken)
  • public Task WriteToServerAsync(DataTable table)
  • public Task WriteToServerAsync(DataTable table, DataRowState rowState)
  • public Task WriteToServerAsync(DataTable table, DataRowState rowState, CancellationToken cancellationToken)
  • public Task WriteToServerAsync(DataTable table, CancellationToken cancellationToken)
  • public Task WriteToServerAsync(IDataReader reader)
  • public Task WriteToServerAsync(IDataReader reader, CancellationToken cancellationToken)
• public sealed class SqlBulkCopyColumnMapping
  • public string DestinationColumn { get; set; }
  • public int DestinationOrdinal { get; set; }
  • public string SourceColumn { get; set; }
  • public int SourceOrdinal { get; set; }
  • public SqlBulkCopyColumnMapping()
  • public SqlBulkCopyColumnMapping(int sourceColumnOrdinal, int destinationOrdinal)
  • public SqlBulkCopyColumnMapping(int sourceColumnOrdinal, string destinationColumn)
  • public SqlBulkCopyColumnMapping(string sourceColumn, int destinationOrdinal)
  • public SqlBulkCopyColumnMapping(string sourceColumn, string destinationColumn)
• public sealed class SqlBulkCopyColumnMappingCollection : CollectionBase
  • public SqlBulkCopyColumnMapping this[int index] { get; }
  • public SqlBulkCopyColumnMapping Add(SqlBulkCopyColumnMapping bulkCopyColumnMapping)
  • public SqlBulkCopyColumnMapping Add(int sourceColumnIndex, int destinationColumnIndex)
  • public SqlBulkCopyColumnMapping Add(int sourceColumnIndex, string destinationColumn)
  • public SqlBulkCopyColumnMapping Add(string sourceColumn, int destinationColumnIndex)
  • public SqlBulkCopyColumnMapping Add(string sourceColumn, string destinationColumn)
  • public void Clear()
  • public bool Contains(SqlBulkCopyColumnMapping value)
  • public void CopyTo(SqlBulkCopyColumnMapping[] array, int index)
  • public int IndexOf(SqlBulkCopyColumnMapping value)
  • public void Insert(int index, SqlBulkCopyColumnMapping value)
  • public void Remove(SqlBulkCopyColumnMapping value)
  • public void RemoveAt(int index)
• public enum SqlBulkCopyOptions
  • CheckConstraints = 2
  • Default = 0
  • FireTriggers = 16
  • KeepIdentity = 1
  • KeepNulls = 8
  • TableLock = 4
  • UseInternalTransaction = 32
• public sealed class SqlClientFactory : DbProviderFactory
  • public static readonly SqlClientFactory Instance
• public static class SqlClientMetaDataCollectionNames
  • public static readonly string Columns
  • public static readonly string Databases
  • public static readonly string ForeignKeys
  • public static readonly string IndexColumns
  • public static readonly string Indexes
  • public static readonly string Parameters
  • public static readonly string ProcedureColumns
  • public static readonly string Procedures
  • public static readonly string Tables
  • public static readonly string UserDefinedTypes
  • public static readonly string Users
  • public static readonly string ViewColumns
  • public static readonly string Views
• public sealed class SqlCommand : DbCommand, ICloneable
  • public SqlConnection Connection { get; set; }
  • public SqlNotificationRequest Notification { get; set; }
  • public SqlParameterCollection Parameters { get; }
  • public SqlTransaction Transaction { get; set; }
  • public event StatementCompletedEventHandler StatementCompleted
  • public SqlCommand()
  • public SqlCommand(string cmdText)
  • public SqlCommand(string cmdText, SqlConnection connection)
  • public SqlCommand(string cmdText, SqlConnection connection, SqlTransaction transaction)
  • public IAsyncResult BeginExecuteNonQuery()
  • public IAsyncResult BeginExecuteNonQuery(AsyncCallback callback, object stateObject)
  • public IAsyncResult BeginExecuteXmlReader()
  • public IAsyncResult BeginExecuteXmlReader(AsyncCallback callback, object stateObject)
  • public SqlCommand Clone()
  • public SqlParameter CreateParameter()
  • public int EndExecuteNonQuery(IAsyncResult asyncResult)
  • public XmlReader EndExecuteXmlReader(IAsyncResult asyncResult)
  • public SqlDataReader ExecuteReader()
  • public SqlDataReader ExecuteReader(CommandBehavior behavior)
  • public Task<SqlDataReader> ExecuteReaderAsync()
  • public Task<SqlDataReader> ExecuteReaderAsync(CommandBehavior behavior)
  • public Task<SqlDataReader> ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
  • public Task<SqlDataReader> ExecuteReaderAsync(CancellationToken cancellationToken)
  • public XmlReader ExecuteXmlReader()
  • public Task<XmlReader> ExecuteXmlReaderAsync()
  • public Task<XmlReader> ExecuteXmlReaderAsync(CancellationToken cancellationToken)
  • public void ResetCommandTimeout()
• public sealed class SqlCommandBuilder : DbCommandBuilder
  • public SqlDataAdapter DataAdapter { get; set; }
  • public SqlCommandBuilder()
  • public SqlCommandBuilder(SqlDataAdapter adapter)
  • public static void DeriveParameters(SqlCommand command)
  • public SqlCommand GetDeleteCommand()
  • public SqlCommand GetDeleteCommand(bool useColumnsForParameterNames)
  • public SqlCommand GetInsertCommand()
  • public SqlCommand GetInsertCommand(bool useColumnsForParameterNames)
  • public SqlCommand GetUpdateCommand()
  • public SqlCommand GetUpdateCommand(bool useColumnsForParameterNames)
• public sealed class SqlConnection : DbConnection, ICloneable
  • public string AccessToken { get; set; }
  • public Guid ClientConnectionId { get; }
  • public SqlCredential Credential { get; set; }
  • public bool FireInfoMessageEventOnUserErrors { get; set; }
  • public int PacketSize { get; }
  • public bool StatisticsEnabled { get; set; }
  • public string WorkstationId { get; }
  • public event SqlInfoMessageEventHandler InfoMessage
  • public SqlConnection()
  • public SqlConnection(string connectionString)
  • public SqlConnection(string connectionString, SqlCredential credential)
  • public static void ChangePassword(string connectionString, SqlCredential credential, SecureString newPassword)
  • public static void ChangePassword(string connectionString, string newPassword)
  • public static void ClearAllPools()
  • public static void ClearPool(SqlConnection connection)
  • public SqlTransaction BeginTransaction()
  • public SqlTransaction BeginTransaction(IsolationLevel iso)
  • public SqlTransaction BeginTransaction(IsolationLevel iso, string transactionName)
  • public SqlTransaction BeginTransaction(string transactionName)
  • public SqlCommand CreateCommand()
  • public void ResetStatistics()
  • public IDictionary RetrieveStatistics()
• public sealed class SqlConnectionStringBuilder : DbConnectionStringBuilder
  • public ApplicationIntent ApplicationIntent { get; set; }
  • public string ApplicationName { get; set; }
  • public string AttachDBFilename { get; set; }
  • public int ConnectRetryCount { get; set; }
  • public int ConnectRetryInterval { get; set; }
  • public int ConnectTimeout { get; set; }
  • public string CurrentLanguage { get; set; }
  • public string DataSource { get; set; }
  • public bool Encrypt { get; set; }
  • public bool Enlist { get; set; }
  • public string FailoverPartner { get; set; }
  • public string InitialCatalog { get; set; }
  • public bool IntegratedSecurity { get; set; }
  • public int LoadBalanceTimeout { get; set; }
  • public int MaxPoolSize { get; set; }
  • public int MinPoolSize { get; set; }
  • public bool MultipleActiveResultSets { get; set; }
  • public bool MultiSubnetFailover { get; set; }
  • public int PacketSize { get; set; }
  • public string Password { get; set; }
  • public bool PersistSecurityInfo { get; set; }
  • public bool Pooling { get; set; }
  • public bool Replication { get; set; }
  • public string TransactionBinding { get; set; }
  • public bool TrustServerCertificate { get; set; }
  • public string TypeSystemVersion { get; set; }
  • public string UserID { get; set; }
  • public bool UserInstance { get; set; }
  • public string WorkstationID { get; set; }
  • public SqlConnectionStringBuilder()
  • public SqlConnectionStringBuilder(string connectionString)
• public sealed class SqlCredential
  • public SecureString Password { get; }
  • public string UserId { get; }
  • public SqlCredential(string userId, SecureString password)
• public sealed class SqlDataAdapter : DbDataAdapter, IDataAdapter, IDbDataAdapter, ICloneable
  • public SqlCommand DeleteCommand { get; set; }
  • public SqlCommand InsertCommand { get; set; }
  • public SqlCommand SelectCommand { get; set; }
  • public SqlCommand UpdateCommand { get; set; }
  • public event SqlRowUpdatedEventHandler RowUpdated
  • public event SqlRowUpdatingEventHandler RowUpdating
  • public SqlDataAdapter()
  • public SqlDataAdapter(SqlCommand selectCommand)
  • public SqlDataAdapter(string selectCommandText, SqlConnection selectConnection)
  • public SqlDataAdapter(string selectCommandText, string selectConnectionString)
• public class SqlDataReader : DbDataReader, IDisposable
  • protected SqlConnection Connection { get; }
  • public virtual DateTimeOffset GetDateTimeOffset(int i)
  • public virtual SqlBinary GetSqlBinary(int i)
  • public virtual SqlBoolean GetSqlBoolean(int i)
  • public virtual SqlByte GetSqlByte(int i)
  • public virtual SqlBytes GetSqlBytes(int i)
  • public virtual SqlChars GetSqlChars(int i)
  • public virtual SqlDateTime GetSqlDateTime(int i)
  • public virtual SqlDecimal GetSqlDecimal(int i)
  • public virtual SqlDouble GetSqlDouble(int i)
  • public virtual SqlGuid GetSqlGuid(int i)
  • public virtual SqlInt16 GetSqlInt16(int i)
  • public virtual SqlInt32 GetSqlInt32(int i)
  • public virtual SqlInt64 GetSqlInt64(int i)
  • public virtual SqlMoney GetSqlMoney(int i)
  • public virtual SqlSingle GetSqlSingle(int i)
  • public virtual SqlString GetSqlString(int i)
  • public virtual object GetSqlValue(int i)
  • public virtual int GetSqlValues(object[] values)
  • public virtual SqlXml GetSqlXml(int i)
  • public virtual TimeSpan GetTimeSpan(int i)
  • public virtual XmlReader GetXmlReader(int i)
• public sealed class SqlDependency
  • public bool HasChanges { get; }
  • public string Id { get; }
  • public event OnChangeEventHandler OnChange
  • public SqlDependency()
  • public SqlDependency(SqlCommand command)
  • public SqlDependency(SqlCommand command, string options, int timeout)
  • public static bool Start(string connectionString)
  • public static bool Start(string connectionString, string queue)
  • public static bool Stop(string connectionString)
  • public static bool Stop(string connectionString, string queue)
  • public void AddCommandDependency(SqlCommand command)
• public sealed class SqlError
  • public byte Class { get; }
  • public int LineNumber { get; }
  • public string Message { get; }
  • public int Number { get; }
  • public string Procedure { get; }
  • public string Server { get; }
  • public string Source { get; }
  • public byte State { get; }
• public sealed class SqlErrorCollection : ICollection, IEnumerable
  • public int Count { get; }
  • public SqlError this[int index] { get; }
  • public void CopyTo(Array array, int index)
  • public void CopyTo(SqlError[] array, int index)
  • public IEnumerator GetEnumerator()
• public sealed class SqlException : DbException
  • public byte Class { get; }
  • public Guid ClientConnectionId { get; }
  • public SqlErrorCollection Errors { get; }
  • public int LineNumber { get; }
  • public int Number { get; }
  • public string Procedure { get; }
  • public string Server { get; }
  • public byte State { get; }
• public sealed class SqlInfoMessageEventArgs : EventArgs
  • public SqlErrorCollection Errors { get; }
  • public string Message { get; }
  • public string Source { get; }
• public sealed delegate SqlInfoMessageEventHandler : MulticastDelegate
  • public SqlInfoMessageEventHandler(object object, IntPtr method)
  • public virtual IAsyncResult BeginInvoke(object sender, SqlInfoMessageEventArgs e, AsyncCallback callback, object object)
  • public virtual void EndInvoke(IAsyncResult result)
  • public virtual void Invoke(object sender, SqlInfoMessageEventArgs e)
• public class SqlNotificationEventArgs : EventArgs
  • public SqlNotificationInfo Info { get; }
  • public SqlNotificationSource Source { get; }
  • public SqlNotificationType Type { get; }
  • public SqlNotificationEventArgs(SqlNotificationType type, SqlNotificationInfo info, SqlNotificationSource source)
• public enum SqlNotificationInfo
  • AlreadyChanged = -2
  • Alter = 5
  • Delete = 3
  • Drop = 4
  • Error = 7
  • Expired = 12
  • Insert = 1
  • Invalid = 9
  • Isolation = 11
  • Merge = 16
  • Options = 10
  • PreviousFire = 14
  • Query = 8
  • Resource = 13
  • Restart = 6
  • TemplateLimit = 15
  • Truncate = 0
  • Unknown = -1
  • Update = 2
• public enum SqlNotificationSource
  • Client = -2
  • Data = 0
  • Database = 3
  • Environment = 6
  • Execution = 7
  • Object = 2
  • Owner = 8
  • Statement = 5
  • System = 4
  • Timeout = 1
  • Unknown = -1
• public enum SqlNotificationType
  • Change = 0
  • Subscribe = 1
  • Unknown = -1
• public sealed class SqlParameter : DbParameter, ICloneable
  • public SqlCompareOptions CompareInfo { get; set; }
  • public int LocaleId { get; set; }
  • public int Offset { get; set; }
  • public byte Precision { get; set; }
  • public byte Scale { get; set; }
  • public SqlDbType SqlDbType { get; set; }
  • public object SqlValue { get; set; }
  • public string TypeName { get; set; }
  • public string UdtTypeName { get; set; }
  • public string XmlSchemaCollectionDatabase { get; set; }
  • public string XmlSchemaCollectionName { get; set; }
  • public string XmlSchemaCollectionOwningSchema { get; set; }
  • public SqlParameter()
  • public SqlParameter(string parameterName, SqlDbType dbType)
  • public SqlParameter(string parameterName, SqlDbType dbType, int size)
  • public SqlParameter(string parameterName, SqlDbType dbType, int size, ParameterDirection direction, bool isNullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value)
  • public SqlParameter(string parameterName, SqlDbType dbType, int size, ParameterDirection direction, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, bool sourceColumnNullMapping, object value, string xmlSchemaCollectionDatabase, string xmlSchemaCollectionOwningSchema, string xmlSchemaCollectionName)
  • public SqlParameter(string parameterName, SqlDbType dbType, int size, string sourceColumn)
  • public SqlParameter(string parameterName, object value)
  • public void ResetSqlDbType()
• public sealed class SqlParameterCollection : DbParameterCollection
  • public SqlParameter this[int index] { get; set; }
  • public SqlParameter this[string parameterName] { get; set; }
  • public SqlParameter Add(SqlParameter value)
  • public SqlParameter Add(string parameterName, SqlDbType sqlDbType)
  • public SqlParameter Add(string parameterName, SqlDbType sqlDbType, int size)
  • public SqlParameter Add(string parameterName, SqlDbType sqlDbType, int size, string sourceColumn)
  • public void AddRange(SqlParameter[] values)
  • public SqlParameter AddWithValue(string parameterName, object value)
  • public bool Contains(SqlParameter value)
  • public void CopyTo(SqlParameter[] array, int index)
  • public int IndexOf(SqlParameter value)
  • public void Insert(int index, SqlParameter value)
  • public void Remove(SqlParameter value)
• public class SqlRowsCopiedEventArgs : EventArgs
  • public bool Abort { get; set; }
  • public long RowsCopied { get; }
  • public SqlRowsCopiedEventArgs(long rowsCopied)
• public sealed delegate SqlRowsCopiedEventHandler : MulticastDelegate
  • public SqlRowsCopiedEventHandler(object object, IntPtr method)
  • public virtual IAsyncResult BeginInvoke(object sender, SqlRowsCopiedEventArgs e, AsyncCallback callback, object object)
  • public virtual void EndInvoke(IAsyncResult result)
  • public virtual void Invoke(object sender, SqlRowsCopiedEventArgs e)
• public sealed class SqlRowUpdatedEventArgs : RowUpdatedEventArgs
  • public SqlCommand Command { get; }
  • public SqlRowUpdatedEventArgs(DataRow row, IDbCommand command, StatementType statementType, DataTableMapping tableMapping)
• public sealed delegate SqlRowUpdatedEventHandler : MulticastDelegate
  • public SqlRowUpdatedEventHandler(object object, IntPtr method)
  • public virtual IAsyncResult BeginInvoke(object sender, SqlRowUpdatedEventArgs e, AsyncCallback callback, object object)
  • public virtual void EndInvoke(IAsyncResult result)
  • public virtual void Invoke(object sender, SqlRowUpdatedEventArgs e)
• public sealed class SqlRowUpdatingEventArgs : RowUpdatingEventArgs
  • public SqlCommand Command { get; set; }
  • public SqlRowUpdatingEventArgs(DataRow row, IDbCommand command, StatementType statementType, DataTableMapping tableMapping)
• public sealed delegate SqlRowUpdatingEventHandler : MulticastDelegate
  • public SqlRowUpdatingEventHandler(object object, IntPtr method)
  • public virtual IAsyncResult BeginInvoke(object sender, SqlRowUpdatingEventArgs e, AsyncCallback callback, object object)
  • public virtual void EndInvoke(IAsyncResult result)
  • public virtual void Invoke(object sender, SqlRowUpdatingEventArgs e)
• public sealed class SqlTransaction : DbTransaction
  • public SqlConnection Connection { get; }
  • public void Rollback(string transactionName)
  • public void Save(string savePointName)