Hello olorin,

In order to map string (or binary) field to SQL column we analyze the value of Length property of Field attribute:

1. When Length is not specified, e.g.:

[Field] public string Name {get; set;}

we create SQL column of nvarchar type, with max available length. For MS SQL Server it is equal to 4000.

1. When Length is specified and it is less or equal to max available length for nvarchar type for current Storage provider, e.g.:

[Field(Length = 100)] public string Name {get; set;}

we create SQL column of nvarchar type, with specified Length (100 in this case).

1. When Length is specified and it is greater than max available length for nvarchar type for current Storage provider, e.g.:

[Field(Length = 4001)] public string Name {get; set;}

we create SQL column of nvarchar(max) type. nvarchar(max) type is the same as ntext type in MS SQL Server 2000.

In order to always get nvarchar(max) type for a field and to be independent of concrete storage provider properties (different database servers have different max available column length for nvarchar type) you may specify length in this way:

[Field(Length = Int32.MaxValue)] public string Name {get; set;}

Hope this helps.