SQL Server data type | CLR data type (.NET Framework) |
| varbinary | Byte[] |
| binary | Byte[] |
| varbinary(1), binary(1) | byte, Byte[] |
| nvarchar(1), nchar(1) | Char, String, Char[] |
| nvarchar / nchar | String, Char[] |
| uniqueidentifier | Guid |
| bit | Boolean |
| tinyint | Byte |
| smallint | Int16 |
| int | Int32 |
| bigint | Int64 |
| smallmoney | Decimal |
| money | Decimal |
| numeric | Decimal |
| decimal | Decimal |
| real | Single |
| float | Double |
| smalldatetime | DateTime |
| datetime | DateTime |