| 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 |