Compartilhar via

.NET Framework Data Provider for SQL Server Types (Entity Framework)

  • Artigo

The .NET Framework Data Provider for SQL Server (SqlClient) provider manifest file includes the list of the provider primitive types, facets for each type, the mappings between the conceptual and storage model primitive types, and the promotion and conversion rules between the conceptual and storage model primitive types.

The following table describes types for SQL Server 2005 and SQL Server 2000 databases and how these types map to Entity Data Model (EDM) types. Some new types were introduced in SQL Server 2005 and are not supported in SQL Server 2000. These types are noted in the table below.

Provider type name Provider type attributes EDM type name EDM type facets

bit

n/a

Boolean

n/a

tinyint

n/a

Byte

n/a

smallint

n/a

Int16

n/a

int

n/a

Int32

n/a

bigint

n/a

Int64

n/a

float

n/a

Double

n/a

real

n/a

Single

n/a

decimal

n/a

Decimal
Facet name Attribute name Value
Precision Minimum Maximum Default Constant 1 38 18 False
Scale Minimum Maximum Default Constant 0 38 0 False

numeric

n/a

Decimal
Facet name Attribute name Value
Precision Minimum Maximum Default Constant 1 38 18 False
Scale Minimum Maximum Default Constant 0 38 0 False

smallmoney

n/a

Decimal
Facet name Attribute name Value
Precision Default Constant 10 True
Scale Default Constant 4 True

money

n/a

Decimal
Facet name Attribute name Value
Precision Default Constant 19 True
Scale Default Constant 4 True

binary

n/a

Binary
Facet name Attribute name Value
MaxLength Minimum Maximum Default Constant 1 8000 8000 False
FixedLength Default Constant True True

varbinary

n/a

Binary
Facet name Attribute name Value
MaxLength Minimum Maximum Default Constant 1 8000 8000 False
FixedLength Default Constant False True

varbinary(max)

NoteNote
This type is not supported in SQL Server 2000.

n/a

Binary
Facet name Attribute name Value
MaxLength Default Constant 214748364780 True
FixedLength Default Constant False True

image

n/a

Binary
Facet name Attribute name Value
MaxLength Default Constant 2147483647 True
FixedLength Default Constant False True

timestamp

n/a

Binary
Facet name Attribute name Value
MaxLength Default Constant 8 True
FixedLength Default Constant True True

rowversion

n/a

Binary
Facet name Attribute name Value
MaxLength Default Constant 8 True
FixedLength Default Constant True True

smalldatetime

n/a

DateTime
Facet name Attribute name Value
Precision Default Constant 0 True

datetime

n/a

DateTime
Facet name Attribute name Value
Precision Default Constant 3 True

date

NoteNote
This type is not supported in SQL Server 2005 and SQL Server 2000.

n/a

DateTime
Facet name Attribute name Value
Precision Default Constant 0 Flase

time

NoteNote
This type is not supported in SQL Server 2005 and SQL Server 2000.

n/a

Time
Facet name Attribute name Value
Precision Default Constant 7 Flalse

datetime2

NoteNote
This type is not supported in SQL Server 2005 and SQL Server 2000.

n/a

DateTime
Facet name Attribute name Value
Precision Default Constant 7 Flalse

datetimeoffset

NoteNote
This type is not supported in SQL Server 2005 and SQL Server 2000.

n/a

DateTimeOffset
Facet name Attribute name Value
Precision Default Constant 7 Flalse

nvarchar

NoteNote
This type is not supported in SQL Server 2000.

n/a

String
Facet name Attribute name Value
MaxLength Minimum Maximum Default Constant 1 4000 4000 False
Unicode Default Constant True True
FixedLength Default Constant False True

varchar

NoteNote
This type is not supported in SQL Server 2000.

n/a

String
Facet name Attribute name Value
MaxLength Minimum Maximum Default Constant 1 8000 8000 False
Unicode Default Constant False True
FixedLength Default Constant False True

char

n/a

String
Facet name Attribute name Value
MaxLength Minimum Maximum Default Constant 1 8000 8000 False
Unicode Default Constant False True
FixedLength Default Constant True True

nchar

n/a

String
Facet name Attribute name Value
MaxLength Minimum Maximum Default Constant 1 4000 4000 False
Unicode Default Constant True True
FixedLength Default Constant True True

varchar(max)

n/a

String
Facet name Attribute name Value
MaxLength Default Constant 2147483647 True
Unicode Default Constant False True
FixedLength Default Constant False True

nvarchar(max)

n/a

String
Facet name Attribute name Value
MaxLength Default Constant 1073741823 True
Unicode Default Constant True True
FixedLength Default Constant False True

ntext
Attribute name Value
Equal comparable False
Order comparable False

String
Facet name Attribute name Value
MaxLength Default Constant 1073741823 True
Unicode Default Constant False True
FixedLength Default Constant False True

text
Attribute name Value
Equal comparable False
Order comparable False

String
Facet name Attribute name Value
MaxLength Default Constant 2147483647 True
Unicode Default Constant False True
FixedLength Default Constant False True

Unique

identifier
Attribute name Value
Equal comparable True
Order comparable True

Guid

n/a

xml
Attribute name Value
Equal comparable False
Order comparable False

String
Facet name Attribute name Value
MaxLength Default Constant 1073741823 True
Unicode Default Constant True True
FixedLength Default Constant False True

See Also

Concepts

Simple Types (EDM)