Sql Server 数据类型与 C# 数据类型对照
# 数据库 2024-05-05 23:02 0 151 来源： 云博客
| 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 |
