SQL Server与CLR数据类型的对应关系

时间:2023-02-14 21:57:02

数据库

C#程序

int

int32

text

string

bigint

int64

binary

System.Byte[]

bit

Boolean

char

string

date

System.DateTime

datetime2

System.DateTime

datetimeoffset

System.DateTimeOffset

decimal

System.Decimal

float

System.Double

image

System.Byte[]

money

System.Decimal

nchar

String

ntext

String

numeric

System.Decimal

nvarchar

String

real

System.Single

smalldatetime

System.DateTime

smallint

Int16

smallmoney

System.Decimal

time

System.TimeSpan

timestamp

System.DateTime

tinyint

System.Byte

varbinary

System.Byte[]

varchar

String

Variant

Object

unique identifier

System.Guid