Tipo SQL Server Tipo de .NET
Framework
Enumeración
SqlDbType
SqlDataReader
SqlTypes
Enumeración DbType SqlDataReader
DbType
Bigint Int64 BigInt GetSqlInt64 Int64 GetInt64
binaria Byte[] VarBinary GetSqlBinary Binary GetBytes
Bits Boolean Bit GetSqlBoolean Boolean GetBoolean
Char String
Char[]
Char GetSqlString AnsiStringFixedLength,
String
GetString
GetChars
fecha DateTime Date 1GetSqlDateTime Date 1GetDateTime
Datetime DateTime DateTime GetSqlDateTime DateTime GetDateTime
datetime2 DateTime DateTime2 Ninguna DateTime2 GetDateTime
datetimeoffset DateTimeOffset DateTimeOffset ninguna DateTimeOffset GetDateTimeOffset
decimal Decimal Decimal GetSqlDecimal Decimal GetDecimal
FILESTREAM
(varbinary(max))
Byte[] VarBinary GetSqlBytes Binary GetBytes
float Double Float GetSqlDouble Double GetDouble
imagen Byte[] Binary GetSqlBinary Binary GetBytes
int Int32 Int GetSqlInt32 Int32 GetInt32
money Decimal Money GetSqlMoney Decimal GetDecimal
nchar String
Char[]
NChar GetSqlString StringFixedLength GetString
GetChars
ntext String
Char[]
NText GetSqlString String GetString
GetChars
numéricas Decimal Decimal GetSqlDecimal Decimal GetDecimal
nvarchar String
Char[]
NVarChar GetSqlString String GetString
GetChars
reales Single Real GetSqlSingle Single GetFloat
rowversion Byte[] Timestamp GetSqlBinary Binary GetBytes
smalldatetime DateTime DateTime GetSqlDateTime DateTime GetDateTime
smallint Int16 SmallInt GetSqlInt16 Int16 GetInt16
smallmoney Decimal SmallMoney GetSqlMoney Decimal GetDecimal
sql_variant Objeto 2Variant GetSqlValue 2Object GetValue 2
Texto String
Char[]
Text GetSqlString String GetString
GetChars
Hora TimeSpan Time ninguna Time GetDateTime
marca de tiempo Byte[] Timestamp GetSqlBinary Binary GetBytes
tinyint Byte TinyInt GetSqlByte Byte GetByte
uniqueidentifier Guid UniqueIdentifier GetSqlGuid Guid GetGuid
varbinary Byte[] VarBinary GetSqlBinary Binary GetBytes
varchar String
Char[]
VarChar GetSqlString AnsiString, String GetString
GetChars
xml Xml Xml GetSqlXml Xml ninguna