Annotation for Key an MaxLength about sqlitecodefirst HOT 3 CLOSED

Thank you for the suggestion.
They Key Attribute should already working.
I'll add support for the MaxLenght constrain in the next couple of days.

from sqlitecodefirst.

[Key] does not work, even not without [MaxLength(31)]

from sqlitecodefirst.

MaxLength:
You can do something like this in SQLite: Column NVARCHAR (10) this will set the maximum length to 10 but SQLite will not enforce this value (e.g. by truncating or by throwing an error).
Anyway, I implemented this feature. But I discovered the following behavoir:
If you do something like this:
[Key] [MaxLength(5)] public string LastName { get; set; }

The SQLite EF provider will ignore the value in MaxLength and set the value to 128.
So this also means that each string column which is declard as key will have the MaxLengthset to 128.

Key
I did some refactorings and changed the code SQLite DDL Code generation so that now the PrimaryKeys are defined with the "PRIMARY KEY" constraint on the table level instead of the column level. This now also makes it possible to have primary key composites. If you whish to use primary key composites, please take into account that you have to annotate the primary key properties also with the [Column(Order = 1)] Column order annotation.

See v0.1-apha.2

from sqlitecodefirst.