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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.