ADO.NET in a Nutshell

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( )