Oliver
Reputation: 11597
Constrain nvarchar columns in entity framework codefirst?
I am writing an application that makes use of entity framework.
One of my tables is called Individuals, it needs a column Sex which should only allow the values Male, Female or Unknown.
How should this be implemented with entity framework? Of course, I can just restrict the input that the user is allowed to enter, but I'd like there to be a constraint on the database also.
Upvotes: 0
Views: 159
Answers (1)
Justin Niessner
Reputation: 245389
The column should be of type int and then mapped to a field that is an Enum that has the values Unknown, Male, Female.
Upvotes: 1
Related Questions
- How do I set a column in SQL Server to varchar(max) using ASP.net EF Codefirst Data Annotations?
- Set EF6 Code First strings fluently to nvarchar(max)
- EF Code First - Globally set varchar mapping over nvarchar
- Force Entity Framework 6 (EF6) to use nvarchar(MAX)
- EF Code First 4.1 doesn't support nvarchar(max) at all?
- EF Code First - Map Dictionary or custom type as an nvarchar
- Entity Framework: Code First - Column Mapping
- How to handle an Entity Framework CodeFirst Column that could be an int OR a long
- Can I change the convention for string column generation by EF Code First?
- EF4 CodeFirst CTP5 nvarchar(max) via attribute