SqlServerData type CLR data type(SqlServer)CLR data type(.NETFramework)varbinarySqlBytes, SqlBinary Byte[]BinarySqlBytes, SqlBinary Byte[]varbinary(1),Binary(1) SqlBytes, SqlBinary Byte, Byte[]ImageNone NonevarcharNone NoneChar None Nonenvarchar(1),NChar(1) SqlChars, SqlString Char, String, Char[]nvarcharSqlChars, SqlString String, Char[]NCharSqlChars, SqlString String, Char[]TextNone NonentextNone NoneuniqueidentifierSqlGuid GuidRowVersionNone Byte[]BitSqlBoolean BooleantinyintSqlByte BytesmallintSqlInt16 Int16 Int SqlInt32 Int32bigintSqlInt64 Int64SmallMoneySqlMoney DecimalMoneySqlMoney DecimalNumericSqlDecimal Decimal Decimal SqlDecimal DecimalRealSqlSingle Single Float SqlDouble DoublesmalldatetimeSqlDateTime DatetimeDatetimeSqlDateTime datetime sql_variant noneobject user-defined< Span class= "PLN" > Type (udtnone User-defined type Table none none cursor nonetimestamp none none XML sqlxml none
SQL and. NET Framework data type correspondence table