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

---

API Differences between 4.9.0 and 4.4.1

155 Additions 0 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 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 DbType DbType { get; }
  • public Type Type { get; }
  • 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 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.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 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 sealed class SqlBulkCopyColumnMappingCollection : CollectionBase
  • public void Clear()
  • public void RemoveAt(int index)
• public sealed class SqlCommand : DbCommand, ICloneable
  • public SqlNotificationRequest Notification { get; set; }
  • public IAsyncResult BeginExecuteNonQuery()
  • public IAsyncResult BeginExecuteNonQuery(AsyncCallback callback, object stateObject)
  • public IAsyncResult BeginExecuteReader()
  • public IAsyncResult BeginExecuteReader(AsyncCallback callback, object stateObject)
  • public IAsyncResult BeginExecuteReader(AsyncCallback callback, object stateObject, CommandBehavior behavior)
  • public IAsyncResult BeginExecuteReader(CommandBehavior behavior)
  • public IAsyncResult BeginExecuteXmlReader()
  • public IAsyncResult BeginExecuteXmlReader(AsyncCallback callback, object stateObject)
  • public int EndExecuteNonQuery(IAsyncResult asyncResult)
  • public SqlDataReader EndExecuteReader(IAsyncResult asyncResult)
  • public XmlReader EndExecuteXmlReader(IAsyncResult asyncResult)
  • 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 SqlCredential Credential { get; set; }
  • 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 sealed class SqlConnectionStringBuilder : DbConnectionStringBuilder
  • public bool Enlist { get; set; }
  • public string TransactionBinding { get; set; }
• public sealed class SqlCredential
  • public SecureString Password { get; }
  • public string UserId { get; }
  • public SqlCredential(string userId, SecureString password)
• 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 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 string UdtTypeName { get; set; }
  • public SqlParameter(string parameterName, SqlDbType dbType, int size, ParameterDirection direction, bool isNullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value)
• public sealed class SqlParameterCollection : DbParameterCollection
  • public SqlParameter Add(string parameterName, SqlDbType sqlDbType, int size, string sourceColumn)