将SQL Server数据类型映射到.NET

将SQL Server数据类型映射到.NET

表4-3将SQL Server数据类型映射到.NET中它们的对应类型，这有助于你在编写ADO.NET代码时选择使用什么。

表4-3

SQL Server类型

SqlDbType

DbType

SqlType

.NET基本类型

BIGINT

BigInt

SqlInt64

Int64

BINARY

Binary

SqlBinary

SqlBytes

Byte[]

BIT

Bit

Boolean

SqlBoolean

Boolean

CHAR

Char

AnsiString

FixedLength

SqlString

SqlChars

SqlStreamChars

String

Char[]

DATETIME

DateTime

Date

DateTime

Time

SqlDateTime

DateTime

DECIMAL

Decimal

Decimal

UInt32

UInt64

VarNumeric

SqlDecimal

Decimal

FLOAT

Float

Double

SqlDouble

Double

IMAGE

Image

SqlBinary

SqlBytes

Byte[]

INT

Int

Int32

UInt16

SqlInt32

Int32

MONEY

Money

Currency

SqlMoney

Decimal

NCHAR

Nchar

StringFixed

Length

SqlString

SqlChars

SqlStreamChars

String

Char[]

续表

SQL Server类型

SqlDbType

DbType

SqlType

.NET基本类型

NTEXT/

VARBINARY

(MAX)

Ntext

SqlString

SqlChars

SqlStreamChars

String

Char[]

NUMERIC

Decimal

SqlDecimal

Decimal

NVARCHAR

NvarChar

String

SqlString

SqlChars

SqlStreamChars

String

Char[]

REAL

Real

Single

SqlSingle

Single

SMALL-

DATETIME

SmallDateTime

SqlDateTime

DateTime

SMALLINT

SmallInt

Int16

SByte

SqlInt16

Int16

SMALLMONEY

SmallMoney

SqlMoney

Decimal

SQL_VARIANT

Variant

Object

Object

Object

SYSNAME

NVarchar

SqlString

String

TEXT/

VARCHAR(MAX)

Text

SqlString

SqlChars

String

Char[]

TIMESTAMP

Timestamp

SqlBinary

Byte[]

TINYINT

TinyInt

Byte

SqlByte

Byte

UNIQUE-

IDENTIFIER

UniqueIdentifier

Guid

SqlGuid

Guid

VARBINARY

VarBinary

Binary

SqlBinary

SqlBytes

Byte[]

VARCHAR

VarChar

AnsiString

SqlString

SqlChars

String

Char[]

XML

Xml

SqlXml

XmlDocument

XmlNode

XmlElement

String