ORM Basics Adjusting SQL Data Types

Overview

Using overrides to the ORMField attribute, developers can set what database type to store a field.

Below is a table displaying Type of ORM Field Convertors.

ORM Field Convertors	Decisions Type	Store as SQL Type
EnumFieldConverter	Enum	String
[ORMField(“Optional_FieldName”, typeof(EnumFieldConverter))]
KeyFieldConverter	PK	Primary Key
StringArrayFieldConverter	String[]	Serialized Text
TextFieldConverter	String	NVARCHAR(MAX)
ORMXmlSerializedFieldConverter	XML	XML
ORMDataPairFieldConverter	DataPair	Serialized Text
ORMBinaryFieldConverter	Binary	Binary
ORMWritableFieldConverter	Generic Serialized Object Graph	Binary
FixedLengthStringFieldConverter	String	VARCHAR(length)
[ORMField(“Optional_FieldName”, length, typeof( FixedLengthStringFieldConverter ))]
EncryptedConverter	Any	Encrypted Binary
BaseDateTimeConverter	DateTime	DateTime
BaseDateConverter	Date	DateTime
TimeFieldConverter	Time	Time
TimeSpanORMFieldConverter	TimeSpan	Long

Here is an example showing how to override for a long text field. This field will become a nvarchar(max) field in SQL.

 [ORMField(typeof(TextFieldConverter))]
[DataMember]
[WritableValue]
public string Description { get; set; }

Here is an example showing how to limit the text length of a field. This field will become a nvarchar(15) field in SQL.

 [ORMField("phone_number", 15, typeof(FixedLengthStringFieldConverter))]
[DataMember]
[WritableValue]
public string PhoneNumber { get; set; }