ADO.NET in a Nutshell

Name

DbType

Synopsis

This enumeration specifies a data type of a field, property, or parameter in the data source. It sets the IDataParameter.DbType property, which identifies the data type of a Command parameter, typically for a stored procedure. Most ADO.NET providers include an enumeration for the data types supported by the data source. For example, the OLE DB provider includes a System.Data.OleDb.OleDbType enumeration, which can be used to set the System.Data.OleDb.OleDbParameter.OleDbType property. When you set the System.Data.OleDb.OleDbParameter.OleDbType property, the System.Data.OleDb.OleDbParameter.DbType property is updated automatically with the closest compatible type from the DbType enumeration.

public enum DbType {

   AnsiString = 0,

   Binary = 1,

   Byte = 2,

   Boolean = 3,

   Currency = 4,

   Date = 5,

   DateTime = 6,

   Decimal = 7,

   Double = 8,

   Guid = 9,

   Int16 = 10,

   Int32 = 11,

   Int64 = 12,

   Object = 13,

   SByte = 14,

   Single = 15,

   String = 16,

   Time = 17,

   UInt16 = 18,

   UInt32 = 19,

   UInt64 = 20,

   VarNumeric = 21,

   AnsiStringFixedLength = 22,

   StringFixedLength = 23

}

Hierarchy

System.Object → System.ValueType → System.Enum(System.IComparable, System.IFormattable, System.IConvertible) → DbType

Returned By

IDataParameter.DbType, System.Data.OleDb.OleDbParameter.DbType, System.Data.OracleClient.OracleParameter.DbType, System.Data.SqlClient.SqlParameter.DbType

Passed To

IDataParameter.DbType, System.Data.OleDb.OleDbParameter.DbType, System.Data.OracleClient.OracleParameter.DbType, System.Data.SqlClient.SqlParameter.DbType ...