<PackageReference Include="System.Data.Common" Version="4.1.0" />

---

API Differences between 4.1.0 and 4.0.0

410 Additions 0 Removals

System

• public sealed class DBNull
  • public static readonly DBNull Value
  • public string ToString(IFormatProvider provider)

System.Data

• public enum CommandBehavior
  • CloseConnection = 32
  • Default = 0
  • KeyInfo = 4
  • SchemaOnly = 2
  • SequentialAccess = 16
  • SingleResult = 1
  • SingleRow = 8
• public enum CommandType
  • StoredProcedure = 4
  • TableDirect = 512
  • Text = 1
• public enum ConnectionState
  • Broken = 16
  • Closed = 0
  • Connecting = 2
  • Executing = 4
  • Fetching = 8
  • Open = 1
• public enum DataRowVersion
  • Default = 1536
• public class DataTable
• public enum DbType
  • AnsiString = 0
  • AnsiStringFixedLength = 22
  • Binary = 1
  • Boolean = 3
  • Byte = 2
  • Currency = 4
  • Date = 5
  • DateTime = 6
  • DateTime2 = 26
  • DateTimeOffset = 27
  • Decimal = 7
  • Double = 8
  • Guid = 9
  • Int16 = 10
  • Int32 = 11
  • Int64 = 12
  • Object = 13
  • SByte = 14
  • Single = 15
  • String = 16
  • StringFixedLength = 23
  • Time = 17
  • UInt16 = 18
  • UInt32 = 19
  • UInt64 = 20
  • VarNumeric = 21
  • Xml = 25
• public interface IDataParameter
  • DbType DbType { get; set; }
  • ParameterDirection Direction { get; set; }
  • bool IsNullable { get; }
  • string ParameterName { get; set; }
  • string SourceColumn { get; set; }
  • DataRowVersion SourceVersion { get; set; }
  • object Value { get; set; }
• public interface IDataParameterCollection : IList, ICollection, IEnumerable
  • object this[string parameterName] { get; set; }
  • bool Contains(string parameterName)
  • int IndexOf(string parameterName)
  • void RemoveAt(string parameterName)
• public interface IDataReader : IDisposable, IDataRecord
  • int Depth { get; }
  • bool IsClosed { get; }
  • int RecordsAffected { get; }
  • void Close()
  • DataTable GetSchemaTable()
  • bool NextResult()
  • bool Read()
• public interface IDataRecord
  • int FieldCount { get; }
  • object this[int i] { get; }
  • object this[string name] { get; }
  • bool GetBoolean(int i)
  • byte GetByte(int i)
  • long GetBytes(int i, long fieldOffset, byte[] buffer, int bufferoffset, int length)
  • char GetChar(int i)
  • long GetChars(int i, long fieldoffset, char[] buffer, int bufferoffset, int length)
  • IDataReader GetData(int i)
  • string GetDataTypeName(int i)
  • DateTime GetDateTime(int i)
  • decimal GetDecimal(int i)
  • double GetDouble(int i)
  • Type GetFieldType(int i)
  • float GetFloat(int i)
  • Guid GetGuid(int i)
  • short GetInt16(int i)
  • int GetInt32(int i)
  • long GetInt64(int i)
  • string GetName(int i)
  • int GetOrdinal(string name)
  • string GetString(int i)
  • object GetValue(int i)
  • int GetValues(object[] values)
  • bool IsDBNull(int i)
• public interface IDbCommand : IDisposable
  • string CommandText { get; set; }
  • int CommandTimeout { get; set; }
  • CommandType CommandType { get; set; }
  • IDbConnection Connection { get; set; }
  • IDataParameterCollection Parameters { get; }
  • IDbTransaction Transaction { get; set; }
  • UpdateRowSource UpdatedRowSource { get; set; }
  • void Cancel()
  • IDbDataParameter CreateParameter()
  • int ExecuteNonQuery()
  • IDataReader ExecuteReader()
  • IDataReader ExecuteReader(CommandBehavior behavior)
  • object ExecuteScalar()
  • void Prepare()
• public interface IDbConnection : IDisposable
  • string ConnectionString { get; set; }
  • int ConnectionTimeout { get; }
  • string Database { get; }
  • ConnectionState State { get; }
  • IDbTransaction BeginTransaction()
  • IDbTransaction BeginTransaction(IsolationLevel il)
  • void ChangeDatabase(string databaseName)
  • void Close()
  • IDbCommand CreateCommand()
  • void Open()
• public interface IDbDataParameter : IDataParameter
  • byte Precision { get; set; }
  • byte Scale { get; set; }
  • int Size { get; set; }
• public interface IDbTransaction : IDisposable
  • IDbConnection Connection { get; }
  • IsolationLevel IsolationLevel { get; }
  • void Commit()
  • void Rollback()
• public enum IsolationLevel
  • Chaos = 16
  • ReadCommitted = 4096
  • ReadUncommitted = 256
  • RepeatableRead = 65536
  • Serializable = 1048576
  • Snapshot = 16777216
  • Unspecified = -1
• public enum ParameterDirection
  • Input = 1
  • InputOutput = 3
  • Output = 2
  • ReturnValue = 6
• public sealed class StateChangeEventArgs : EventArgs
  • public ConnectionState CurrentState { get; }
  • public ConnectionState OriginalState { get; }
  • public StateChangeEventArgs(ConnectionState originalState, ConnectionState currentState)
• public sealed delegate StateChangeEventHandler : MulticastDelegate
  • public StateChangeEventHandler(object object, IntPtr method)
  • public virtual IAsyncResult BeginInvoke(object sender, StateChangeEventArgs e, AsyncCallback callback, object object)
  • public virtual void EndInvoke(IAsyncResult result)
  • public virtual void Invoke(object sender, StateChangeEventArgs e)
• public enum UpdateRowSource
  • Both = 3
  • FirstReturnedRecord = 2
  • None = 0
  • OutputParameters = 1

System.Data.Common

• public abstract class DbColumn
  • public bool? AllowDBNull { get; protected set; }
  • public string BaseCatalogName { get; protected set; }
  • public string BaseColumnName { get; protected set; }
  • public string BaseSchemaName { get; protected set; }
  • public string BaseServerName { get; protected set; }
  • public string BaseTableName { get; protected set; }
  • public string ColumnName { get; protected set; }
  • public int? ColumnOrdinal { get; protected set; }
  • public int? ColumnSize { get; protected set; }
  • public Type DataType { get; protected set; }
  • public string DataTypeName { get; protected set; }
  • public bool? IsAliased { get; protected set; }
  • public bool? IsAutoIncrement { get; protected set; }
  • public bool? IsExpression { get; protected set; }
  • public bool? IsHidden { get; protected set; }
  • public bool? IsIdentity { get; protected set; }
  • public bool? IsKey { get; protected set; }
  • public bool? IsLong { get; protected set; }
  • public bool? IsReadOnly { get; protected set; }
  • public bool? IsUnique { get; protected set; }
  • public virtual object this[string property] { get; }
  • public int? NumericPrecision { get; protected set; }
  • public int? NumericScale { get; protected set; }
  • public string UdtAssemblyQualifiedName { get; protected set; }
  • protected DbColumn()
• public abstract class DbCommand : IDbCommand, IDisposable
  • public abstract string CommandText { get; set; }
  • public abstract int CommandTimeout { get; set; }
  • public abstract CommandType CommandType { get; set; }
  • public DbConnection Connection { get; set; }
  • protected abstract DbConnection DbConnection { get; protected set; }
  • protected abstract DbParameterCollection DbParameterCollection { get; }
  • protected abstract DbTransaction DbTransaction { get; protected set; }
  • public abstract bool DesignTimeVisible { get; set; }
  • public DbParameterCollection Parameters { get; }
  • public DbTransaction Transaction { get; set; }
  • public abstract UpdateRowSource UpdatedRowSource { get; set; }
  • protected DbCommand()
  • public abstract void Cancel()
  • protected abstract DbParameter CreateDbParameter()
  • public DbParameter CreateParameter()
  • public void Dispose()
  • protected virtual void Dispose(bool disposing)
  • protected abstract DbDataReader ExecuteDbDataReader(CommandBehavior behavior)
  • protected virtual Task<DbDataReader> ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
  • public abstract int ExecuteNonQuery()
  • public Task<int> ExecuteNonQueryAsync()
  • public virtual Task<int> ExecuteNonQueryAsync(CancellationToken cancellationToken)
  • public DbDataReader ExecuteReader()
  • public DbDataReader ExecuteReader(CommandBehavior behavior)
  • public Task<DbDataReader> ExecuteReaderAsync()
  • public Task<DbDataReader> ExecuteReaderAsync(CancellationToken cancellationToken)
  • public Task<DbDataReader> ExecuteReaderAsync(CommandBehavior behavior)
  • public Task<DbDataReader> ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
  • public abstract object ExecuteScalar()
  • public Task<object> ExecuteScalarAsync()
  • public virtual Task<object> ExecuteScalarAsync(CancellationToken cancellationToken)
  • public abstract void Prepare()
• public abstract class DbConnection : IDbConnection, IDisposable
  • public abstract string ConnectionString { get; set; }
  • public virtual int ConnectionTimeout { get; }
  • public abstract string Database { get; }
  • public abstract string DataSource { get; }
  • public abstract string ServerVersion { get; }
  • public abstract ConnectionState State { get; }
  • public event StateChangeEventHandler StateChange
  • protected DbConnection()
  • protected abstract DbTransaction BeginDbTransaction(IsolationLevel isolationLevel)
  • public DbTransaction BeginTransaction()
  • public DbTransaction BeginTransaction(IsolationLevel isolationLevel)
  • public abstract void ChangeDatabase(string databaseName)
  • public abstract void Close()
  • public DbCommand CreateCommand()
  • protected abstract DbCommand CreateDbCommand()
  • public void Dispose()
  • protected virtual void Dispose(bool disposing)
  • protected virtual void OnStateChange(StateChangeEventArgs stateChange)
  • public abstract void Open()
  • public Task OpenAsync()
  • public virtual Task OpenAsync(CancellationToken cancellationToken)
• public class DbConnectionStringBuilder : IDictionary, ICollection, IEnumerable
  • public string ConnectionString { get; set; }
  • public virtual int Count { get; }
  • public virtual bool IsFixedSize { get; }
  • public bool IsReadOnly { get; }
  • public virtual object this[string keyword] { get; set; }
  • public virtual ICollection Keys { get; }
  • public virtual ICollection Values { get; }
  • public DbConnectionStringBuilder()
  • public static void AppendKeyValuePair(StringBuilder builder, string keyword, string value)
  • public void Add(string keyword, object value)
  • public virtual void Clear()
  • public virtual bool ContainsKey(string keyword)
  • public virtual bool EquivalentTo(DbConnectionStringBuilder connectionStringBuilder)
  • public virtual bool Remove(string keyword)
  • public virtual bool ShouldSerialize(string keyword)
  • public virtual bool TryGetValue(string keyword, out object value)
• public abstract class DbDataReader : IDataReader, IDisposable, IDataRecord, IEnumerable
  • public abstract int Depth { get; }
  • public abstract int FieldCount { get; }
  • public abstract bool HasRows { get; }
  • public abstract bool IsClosed { get; }
  • public abstract object this[int ordinal] { get; }
  • public abstract object this[string name] { get; }
  • public abstract int RecordsAffected { get; }
  • public virtual int VisibleFieldCount { get; }
  • protected DbDataReader()
  • public virtual void Close()
  • public void Dispose()
  • protected virtual void Dispose(bool disposing)
  • public abstract bool GetBoolean(int ordinal)
  • public abstract byte GetByte(int ordinal)
  • public abstract long GetBytes(int ordinal, long dataOffset, byte[] buffer, int bufferOffset, int length)
  • public abstract char GetChar(int ordinal)
  • public abstract long GetChars(int ordinal, long dataOffset, char[] buffer, int bufferOffset, int length)
  • public DbDataReader GetData(int ordinal)
  • public abstract string GetDataTypeName(int ordinal)
  • public abstract DateTime GetDateTime(int ordinal)
  • protected virtual DbDataReader GetDbDataReader(int ordinal)
  • public abstract decimal GetDecimal(int ordinal)
  • public abstract double GetDouble(int ordinal)
  • public abstract IEnumerator GetEnumerator()
  • public abstract Type GetFieldType(int ordinal)
  • public virtual T GetFieldValue<T>(int ordinal)
  • public Task<T> GetFieldValueAsync<T>(int ordinal)
  • public virtual Task<T> GetFieldValueAsync<T>(int ordinal, CancellationToken cancellationToken)
  • public abstract float GetFloat(int ordinal)
  • public abstract Guid GetGuid(int ordinal)
  • public abstract short GetInt16(int ordinal)
  • public abstract int GetInt32(int ordinal)
  • public abstract long GetInt64(int ordinal)
  • public abstract string GetName(int ordinal)
  • public abstract int GetOrdinal(string name)
  • public virtual Type GetProviderSpecificFieldType(int ordinal)
  • public virtual object GetProviderSpecificValue(int ordinal)
  • public virtual int GetProviderSpecificValues(object[] values)
  • public virtual DataTable GetSchemaTable()
  • public virtual Stream GetStream(int ordinal)
  • public abstract string GetString(int ordinal)
  • public virtual TextReader GetTextReader(int ordinal)
  • public abstract object GetValue(int ordinal)
  • public abstract int GetValues(object[] values)
  • public abstract bool IsDBNull(int ordinal)
  • public Task<bool> IsDBNullAsync(int ordinal)
  • public virtual Task<bool> IsDBNullAsync(int ordinal, CancellationToken cancellationToken)
  • public abstract bool NextResult()
  • public Task<bool> NextResultAsync()
  • public virtual Task<bool> NextResultAsync(CancellationToken cancellationToken)
  • public abstract bool Read()
  • public Task<bool> ReadAsync()
  • public virtual Task<bool> ReadAsync(CancellationToken cancellationToken)
• public static class DbDataReaderExtensions
  • public static bool CanGetColumnSchema(this DbDataReader reader)
  • public static ReadOnlyCollection<DbColumn> GetColumnSchema(this DbDataReader reader)
• public abstract class DbDataRecord : IDataRecord
  • public abstract int FieldCount { get; }
  • public abstract object this[int i] { get; }
  • public abstract object this[string name] { get; }
  • protected DbDataRecord()
  • public abstract bool GetBoolean(int i)
  • public abstract byte GetByte(int i)
  • public abstract long GetBytes(int i, long dataIndex, byte[] buffer, int bufferIndex, int length)
  • public abstract char GetChar(int i)
  • public abstract long GetChars(int i, long dataIndex, char[] buffer, int bufferIndex, int length)
  • public IDataReader GetData(int i)
  • public abstract string GetDataTypeName(int i)
  • public abstract DateTime GetDateTime(int i)
  • protected virtual DbDataReader GetDbDataReader(int i)
  • public abstract decimal GetDecimal(int i)
  • public abstract double GetDouble(int i)
  • public abstract Type GetFieldType(int i)
  • public abstract float GetFloat(int i)
  • public abstract Guid GetGuid(int i)
  • public abstract short GetInt16(int i)
  • public abstract int GetInt32(int i)
  • public abstract long GetInt64(int i)
  • public abstract string GetName(int i)
  • public abstract int GetOrdinal(string name)
  • public abstract string GetString(int i)
  • public abstract object GetValue(int i)
  • public abstract int GetValues(object[] values)
  • public abstract bool IsDBNull(int i)
• public class DbEnumerator : IEnumerator
  • public object Current { get; }
  • public DbEnumerator(IDataReader reader, bool closeReader)
  • public bool MoveNext()
  • public void Reset()
• public abstract class DbException : Exception
  • protected DbException()
  • protected DbException(string message)
  • protected DbException(string message, Exception innerException)
• public abstract class DbParameter : IDbDataParameter, IDataParameter
  • public abstract DbType DbType { get; set; }
  • public abstract ParameterDirection Direction { get; set; }
  • public abstract bool IsNullable { get; set; }
  • public abstract string ParameterName { get; set; }
  • public virtual byte Precision { get; set; }
  • public virtual byte Scale { get; set; }
  • public abstract int Size { get; set; }
  • public abstract string SourceColumn { get; set; }
  • public abstract bool SourceColumnNullMapping { get; set; }
  • public virtual DataRowVersion SourceVersion { get; set; }
  • public abstract object Value { get; set; }
  • protected DbParameter()
  • public abstract void ResetDbType()
• public abstract class DbParameterCollection : IDataParameterCollection, IList, ICollection, IEnumerable
  • public abstract int Count { get; }
  • public virtual bool IsReadOnly { get; }
  • public virtual bool IsSynchronized { get; }
  • public DbParameter this[int index] { get; set; }
  • public DbParameter this[string parameterName] { get; set; }
  • public abstract object SyncRoot { get; }
  • protected DbParameterCollection()
  • public abstract int Add(object value)
  • public abstract void AddRange(Array values)
  • public abstract void Clear()
  • public abstract bool Contains(object value)
  • public abstract bool Contains(string value)
  • public abstract void CopyTo(Array array, int index)
  • public abstract IEnumerator GetEnumerator()
  • protected abstract DbParameter GetParameter(int index)
  • protected abstract DbParameter GetParameter(string parameterName)
  • public abstract int IndexOf(object value)
  • public abstract int IndexOf(string parameterName)
  • public abstract void Insert(int index, object value)
  • public abstract void Remove(object value)
  • public abstract void RemoveAt(int index)
  • public abstract void RemoveAt(string parameterName)
  • protected abstract void SetParameter(int index, DbParameter value)
  • protected abstract void SetParameter(string parameterName, DbParameter value)
• public abstract class DbProviderFactory
  • protected DbProviderFactory()
  • public virtual DbCommand CreateCommand()
  • public virtual DbConnection CreateConnection()
  • public virtual DbConnectionStringBuilder CreateConnectionStringBuilder()
  • public virtual DbParameter CreateParameter()
• public abstract class DbTransaction : IDbTransaction, IDisposable
  • public DbConnection Connection { get; }
  • protected abstract DbConnection DbConnection { get; }
  • public abstract IsolationLevel IsolationLevel { get; }
  • protected DbTransaction()
  • public abstract void Commit()
  • public void Dispose()
  • protected virtual void Dispose(bool disposing)
  • public abstract void Rollback()
• public interface IDbColumnSchemaGenerator
  • ReadOnlyCollection<DbColumn> GetColumnSchema()