ADO.NET in a Nutshell

Name

SqlDbType

Synopsis

This enumeration is used to specify the SQL Server data types. For information about what .NET type each SQL Server data type maps, refer to Appendix A.

public enum SqlDbType {

   BigInt = 0,

   Binary = 1,

   Bit = 2,

   Char = 3,

   DateTime = 4,

   Decimal = 5,

   Float = 6,

   Image = 7,

   Int = 8,

   Money = 9,

   NChar = 10,

   NText = 11,

   NVarChar = 12,

   Real = 13,

   UniqueIdentifier = 14,

   SmallDateTime = 15,

   SmallInt = 16,

   SmallMoney = 17,

   Text = 18,

   Timestamp = 19,

   TinyInt = 20,

   VarBinary = 21,

   VarChar = 22,

   Variant = 23

}

Hierarchy

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

Returned By

System.Data.SqlClient.SqlParameter.SqlDbType

Passed To

System.Data.SqlClient.SqlParameter.{SqlDbType, SqlParameter( )}, System.Data.SqlClient.SqlParameterCollection.Add( )