Share via


Facets (SSDL)

Facets in store schema definition language (SSDL) represent constraints on column types that are specified in Property elements. Facets are implemented as XML attributes on Property elements.

The following table describes the facets that are supported in SSDL:

Facet Description

Collation

Specifies the collating sequence (or sorting sequence) to be used when performing comparison and ordering operations on values of the property.

FixedLength

Specifies whether the length of the column value can vary.

MaxLength

Specifies the maximum length of the column value.

Precision

For properties of type Decimal, specifies the number of digits a property value can have. For properties of type Time, DateTime, and DateTimeOffset, specifies the number of digits for the fractional part of seconds of the column value.

Scale

Specifies the number of digits to the right of the decimal point for the column value.

Unicode

Indicates whether the column value is stored as Unicode.

See Also

Concepts

Entity Framework Overview
SSDL Specification

Other Resources

CSDL, SSDL, and MSL Specifications
ADO.NET Entity Data Model Tools