SQL Server 2005 数据类型 | .NET Framework 数据类型 | LINQ 数据类型 |
bigint | System.Int64 | long |
binary | System.Byte[] | System.Data.Linq.Binary |
bit | System.Boolean | bool |
char | System.String | string |
datetime | System.DateTime | System.DateTime |
decimal | System.Decimal | decimal |
float | System.Double | double |
image | System.Byte[] | System.Data.Linq.Binary |
int | System.Int32 | int |
money | System..Decimal | decimal |
nchar | System.String | string |
ntext | System.String | string |
numeric | System.Decimal | decimal |
nvarchar | System.String | string |
real | System.Single | float |
smalltime | System.DateTime | System.DateTime |
smallint | System.Int16 | short |
smallmoney | System.Decimal | decimal |
sql_variant | System.Object | object |
text | System.String | string |
timestamp | System.Byte[] | System.Data.Linq.Binary |
tinyint | System.Byte | byte |
uniqueidentifier | System.Guid | System.Guid |
varbinary | System.Byte[] | System.Data.Linq.Binary |
varchar | System.String | string |
xml | System.String | System.Xml.Linq.XElement |