| C# Data Type | SQL Server Data Type | |
|---|---|---|
| byte | sbyte | TINYINT |
| ushort | short | SMALLINT |
| uint | int | INT |
| ulong | long | BIGINT |
| float | SINGLE | |
| double | FLOAT | |
| bool | BIT | |
| GUID | UNIQUEIDENTIFIER | |
| decimal | DECIMAL | |
| SMALLMONEY | ||
| MONEY | ||
| NUMERIC | ||
| byte[] | BINARY(n) | |
| VARBINARY | ||
| IMAGE | ||
| TimeSpan | TIME | |
| DateTime | DATE | |
| DATETIME | ||
| SMALLDATETIME | ||
| string | VARCHAR(n) | |
| NVARCHAR(n) | ||
| TEXT(n) | ||
| NTEXT(n) | ||
| CHAR(n) | ||
| NCHAR(n) | ||