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

Precision

Minimum

Maximum

Default

Constant

1

38

18

False

Scale

Minimum

Maximum

Default

Constant

0

38

0

False

numeric

n/a

Edm.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

Edm.Decimal

 

Facet name Attribute name Value

Precision

Default

Constant

10

True

Scale

Default

Constant

4

True

money

n/a

Edm.Decimal

 

Facet name Attribute name Value

Precision

Default

Constant

19

True

Scale

Default

Constant

4

True

binary

n/a

Edm.Binary

 

Facet name Attribute name Value

MaxLength

Minimum

Maximum

Default

Constant

1

8000

8000

False

FixedLength

Default

Constant

True

True

varbinary

n/a

Edm.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

Edm.Binary

 

Facet name Attribute name Value

MaxLength

Default

Constant

214748364780

True

FixedLength

Default

Constant

False

True

image

n/a

Edm.Binary

 

Facet name Attribute name Value

MaxLength

Default

Constant

2147483647

True

FixedLength

Default

Constant

False

True

timestamp

n/a

Edm.Binary

 

Facet name Attribute name Value

MaxLength

Default

Constant

8

True

FixedLength

Default

Constant

True

True

rowversion

n/a

Edm.Binary

 

Facet name Attribute name Value

MaxLength

Default

Constant

8

True

FixedLength

Default

Constant

True

True

smalldatetime

n/a

Edm.DateTime

 

Facet name Attribute name Value

Precision

Default

Constant

0

True

datetime

n/a

Edm.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

Edm.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

Edm.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

Edm.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

Edm.DateTimeOffset

 

Facet name Attribute name Value

Precision

Default

Constant

7

Flalse

nvarchar

noteNote:
This type is not supported

in SQL Server 2000.

n/a

Edm.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

Edm.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

Edm.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

Edm.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

Edm.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

Edm.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

Edm.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

Edm.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

Edm.Guid

n/a

xml

 

Attribute name Value

Equal

comparable

False

Order

comparable

False

Edm.String

 

Facet name Attribute name Value

MaxLength

Default

Constant

1073741823

True

Unicode

Default

Constant

True

True

FixedLength

Default

Constant

False

True

See Also




Build Date:

2012-08-02
Show:
© 2014 Microsoft