Export (0) Print
Expand All

SqlClient for Entity FrameworkTypes

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 2008, SQL Server 2005, and SQL Server 2000 databases and how these types map to conceptual model types. Some new types were introduced in later versions of SQL Server are not supported in the older versions of SQL Server. These types are noted in the table below.

Provider type name Provider type attributes EDMSimpleType name Facets

bit

n/a

Edm.Boolean

n/a

tinyint

n/a

Edm.Byte

n/a

smallint

n/a

Edm.Int16

n/a

int

n/a

Edm.Int32

n/a

bigint

n/a

Edm.Int64

n/a

float

n/a

Edm.Double

n/a

real

n/a

Edm.Double

n/a

decimal

n/a

Edm.Decimal

Facet name Attribute name Value
PrecisionMinimumMaximumDefaultConstant13818False
ScaleMinimumMaximumDefaultConstant0380False

numeric

n/a

Edm.Decimal

Facet name Attribute name Value
PrecisionMinimumMaximumDefaultConstant13818False
ScaleMinimumMaximumDefaultConstant0380False

smallmoney

n/a

Edm.Decimal

Facet name Attribute name Value
PrecisionDefaultConstant10True
ScaleDefaultConstant4True

money

n/a

Edm.Decimal

Facet name Attribute name Value
PrecisionDefaultConstant19True
ScaleDefaultConstant4True

binary

n/a

Edm.Binary

Facet name Attribute name Value
MaxLengthMinimumMaximumDefaultConstant180008000False
FixedLengthDefaultConstantTrueTrue

varbinary

n/a

Edm.Binary

Facet name Attribute name Value
MaxLengthMinimumMaximumDefaultConstant180008000False
FixedLengthDefaultConstantFalseTrue

varbinary(max)

Bb896344.note(en-us,VS.100).gifNote:
This type is not supported in SQL Server 2000.

n/a

Edm.Binary

Facet name Attribute name Value
MaxLengthDefaultConstant214748364780True
FixedLengthDefaultConstantFalseTrue

image

n/a

Edm.Binary

Facet name Attribute name Value
MaxLengthDefaultConstant2147483647True
FixedLengthDefaultConstantFalseTrue

timestamp

n/a

Edm.Binary

Facet name Attribute name Value
MaxLengthDefaultConstant8True
FixedLengthDefaultConstantTrueTrue

rowversion

n/a

Edm.Binary

Facet name Attribute name Value
MaxLengthDefaultConstant8True
FixedLengthDefaultConstantTrueTrue

smalldatetime

n/a

Edm.DateTime

Facet name Attribute name Value
PrecisionDefaultConstant0True

datetime

n/a

Edm.DateTime

Facet name Attribute name Value
PrecisionDefaultConstant3True

date

Bb896344.note(en-us,VS.100).gifNote:
This type is not supported in SQL Server 2005 and SQL Server 2000.

n/a

Edm.DateTime

Facet name Attribute name Value
PrecisionDefaultConstant0Flase

time

Bb896344.note(en-us,VS.100).gifNote:
This type is not supported in SQL Server 2005 and SQL Server 2000.

n/a

Edm.Time

Facet name Attribute name Value
PrecisionDefaultConstant7Flalse

datetime2

Bb896344.note(en-us,VS.100).gifNote:
This type is not supported in SQL Server 2005 and SQL Server 2000.

n/a

Edm.DateTime

Facet name Attribute name Value
PrecisionDefaultConstant7Flalse

datetimeoffset

Bb896344.note(en-us,VS.100).gifNote:
This type is not supported in SQL Server 2005 and SQL Server 2000.

n/a

Edm.DateTimeOffset

Facet name Attribute name Value
PrecisionDefaultConstant7Flalse

nvarchar

Bb896344.note(en-us,VS.100).gifNote:
This type is not supported in SQL Server 2000.

n/a

Edm.String

Facet name Attribute name Value
MaxLengthMinimumMaximumDefaultConstant140004000False
UnicodeDefaultConstantTrueTrue
FixedLengthDefaultConstantFalseTrue

varchar

Bb896344.note(en-us,VS.100).gifNote:
This type is not supported in SQL Server 2000.

n/a

Edm.String

Facet name Attribute name Value
MaxLengthMinimumMaximumDefaultConstant180008000False
UnicodeDefaultConstantFalseTrue
FixedLengthDefaultConstantFalseTrue

char

n/a

Edm.String

Facet name Attribute name Value
MaxLengthMinimumMaximumDefaultConstant180008000False
UnicodeDefaultConstantFalseTrue
FixedLengthDefaultConstantTrueTrue

nchar

n/a

Edm.String

Facet name Attribute name Value
MaxLengthMinimumMaximumDefaultConstant140004000False
UnicodeDefaultConstantTrueTrue
FixedLengthDefaultConstantTrueTrue

varchar(max)

n/a

Edm.String

Facet name Attribute name Value
MaxLengthDefaultConstant2147483647True
UnicodeDefaultConstantFalseTrue
FixedLengthDefaultConstantFalseTrue

nvarchar(max)

n/a

Edm.String

Facet name Attribute name Value
MaxLengthDefaultConstant1073741823True
UnicodeDefaultConstantTrueTrue
FixedLengthDefaultConstantFalseTrue

ntext

Attribute name Value
Equal comparableFalse
OrdercomparableFalse

Edm.String

Facet name Attribute name Value
MaxLengthDefaultConstant1073741823True
UnicodeDefaultConstantFalseTrue
FixedLengthDefaultConstantFalseTrue

text

Attribute name Value
Equal comparableFalse
Order comparableFalse

Edm.String

Facet name Attribute name Value
MaxLengthDefaultConstant2147483647True
UnicodeDefaultConstantFalseTrue
FixedLengthDefaultConstantFalseTrue

Unique

identifier

Attribute name Value
EqualcomparableTrue
Order comparableTrue

Edm.Guid

n/a

xml

Attribute name Value
Equal comparableFalse
Order comparableFalse

Edm.String

Facet name Attribute name Value
MaxLengthDefaultConstant1073741823True
UnicodeDefaultConstantTrueTrue
FixedLengthDefaultConstantFalseTrue

See Also

Community Additions

ADD
Show:
© 2014 Microsoft