SQL Server 2005 資料型別和.Net資料型別的對應關係

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