1SQL Server data type CLR data type (SQL Server) CLR data type (.NET Framework)
2varbinary SqlBytes, SqlBinary Byte[]
3binary SqlBytes, SqlBinary Byte[]
4varbinary(1), binary(1) SqlBytes, SqlBinary byte, Byte[]
5image None None
6
7varchar None None
8char None None
9nvarchar(1), nchar(1) SqlChars, SqlString Char, String, Char[]
10nvarchar SqlChars, SqlString String, Char[]
11nchar SqlChars, SqlString String, Char[]
12text None None
13ntext None None
14
15uniqueidentifier SqlGuid Guid
16rowversion None Byte[]
17bit SqlBoolean Boolean
18tinyint SqlByte Byte
19smallint SqlInt16 Int16
20int SqlInt32 Int32
21bigint SqlInt64 Int64
22
23smallmoney SqlMoney Decimal
24money SqlMoney Decimal
25numeric SqlDecimal Decimal
26decimal SqlDecimal Decimal
27real SqlSingle Single
28float SqlDouble Double
29
30smalldatetime SqlDateTime DateTime
31datetime SqlDateTime DateTime
32
33sql_variant None Object
34User-defined type(UDT) None user-defined type
35table None None
36cursor None None
37timestamp None None
38xml SqlXml None
39