Entity Framework 5 Enum Naming

Posted by Tyrel Van Niekerk on Stack Overflow See other posts from Stack Overflow or by Tyrel Van Niekerk
Published on 2012-04-13T17:03:31Z Indexed on 2012/04/13 17:29 UTC
Read the original article Hit count: 251

Filed under:
|
|
|

I am using EF 5 with migrations and code first. It all works rather nicely, but there are some issues/questions I would like to resolve.

Let's start with a simple example. Lets say I have a User table and a user type table. The user type table is an enum/lookup table in my app. So the user table has a UserTypeId column and a foreign key ref etc to UserType. In my poco, I have a property called UserType which has the enum type.

To add the initial values to the UserType table (or add/change values later) and to create the table in the initial migrator etc. I need a UserType table poco to represent the actual table in the database and to use in the map files. I mapped the UserType property in the User poco to UserTypeId in the UserType poco. So now I have a poco for code first/migrations/context mapping etc and I have an enum. Can't have the same name for both, so do I have a poco called UserType and something else for the enum or have the poco for UserType be UserTypeTable or something?

More importantly however, am I missing some key element in how code first works? I tried the example above, ran Add-Migration and it does not add the lookup table for the enum.

© Stack Overflow or respective owner

Related posts about c#

Related posts about enums