System.Data.SqlClient 4.7.0-preview.18571.3

API Differences between 4.7.0-preview.18571.3 and 4.4.0-preview1-25305-02

183 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 SqlFacetAttribute : Attribute
- public bool IsFixedLength { get; set; }
- public bool IsNullable { get; set; }
- public int MaxSize { get; set; }
- public int Precision { get; set; }
- public int Scale { get; set; }
- public SqlFacetAttribute()
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 enum PoolBlockingPeriod
- AlwaysBlock = 1
- Auto = 0
- NeverBlock = 2
public sealed class SqlBulkCopyColumnMappingCollection : CollectionBase
- public void Clear()
- public void RemoveAt(int index)
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 SqlNotificationRequest Notification { get; set; }
- public IAsyncResult BeginExecuteNonQuery()
- public IAsyncResult BeginExecuteNonQuery(AsyncCallback callback, object stateObject)
- public IAsyncResult BeginExecuteXmlReader()
- public IAsyncResult BeginExecuteXmlReader(AsyncCallback callback, object stateObject)
- public int EndExecuteNonQuery(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 PoolBlockingPeriod PoolBlockingPeriod { 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 class SqlDataReader : DbDataReader, IDbColumnSchemaGenerator, IDisposable
- public ReadOnlyCollection<DbColumn> GetColumnSchema()
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 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 sealed class SqlParameterCollection : DbParameterCollection
- public SqlParameter Add(string parameterName, SqlDbType sqlDbType, int size, string sourceColumn)

System.Data.SqlTypes

public sealed class SqlFileStream : Stream
- public string Name { get; }
- public byte[] TransactionContext { get; }
- public SqlFileStream(string path, byte[] transactionContext, FileAccess access)
- public SqlFileStream(string path, byte[] transactionContext, FileAccess access, FileOptions options, long allocationSize)