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 ...

Get ADO.NET in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.