SQL Server 2005 数据类型和.Net数据类型的对应关系

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