| Sql Server | C# | 简写 |
|---|
| bigint |
System.Int64 |
long |
| tinyint |
System.Byte |
byte |
| binary(50) |
System.Byte[] |
byte[] |
| image |
System.Byte[] |
byte[] |
| varbinary(50) |
System.Byte[] |
byte[] |
| timestamp |
System.Byte[] |
byte[] |
| bit |
System.Boolean |
bool |
| char(10) |
System.String |
string |
| nchar(10) |
System.String |
string |
| ntext |
System.String |
string |
| nvarchar(50) |
System.String |
string |
| varchar(50) |
System.String |
string |
| text |
System.String |
string |
| date |
System.DateTime |
System.DateTime |
| datetime |
System.DateTime |
System.DateTime |
| datetime2(7) |
System.DateTime |
System.DateTime |
| smalldatetime |
System.DateTime |
System.DateTime |
| datetimeoffset(7) |
System.DateTimeOffset |
System.DateTimeOffset |
| time(7) |
System.TimeSpan |
System.TimeSpan |
| decimal(18,0) |
System.Decimal |
decimal |
| money |
System.Decimal |
decimal |
| numeric(18,0) |
System.Decimal |
decimal |
| smallmoney |
System.Decimal |
decimal |
| float |
System.Double |
double |
| int |
System.Int32 |
int |
| real |
System.Single |
float |
| smallint |
System.Int16 |
short |
Sql Server 数据类型与 C# 数据类型对照
原文：https://www.cnblogs.com/firstcsharp/p/9041516.html
