Enum to string with Entity Framework

Question

I have a class, and properties like. I am using Entity Framework with Mysql. After migration using add-migration, it will create an INT(11) column. But I need VARCHAR because, I need Dept or Credit value.

I tried a lot, but it didn't.

How can I do?

public class trns
{
     public trans_type enm_trans_type { get; set; } 
}

 public enum trans_type {
    [Description("Dept")]
    Dept,
    [Description("Credit")]
    Credit   
 }

It will be by using CodeFirst, and you will need the reverse version of the following stackoverflow.com/questions/7437952/… A good article will be nodogmablog.bryanhogan.net/2014/11/… — Orel Eraki
– Orel Eraki, Commented Oct 1, 2016 at 14:06
yes, this is correct. nodogmablog.bryanhogan.net/2014/11/… — Caner
– Caner, Commented Oct 1, 2016 at 14:17

Community · Accepted Answer · 2017-05-23 12:19:26Z

1

Your enumeration is based on an integral value and EF will create an int column behind the scene to store the value of the enum. It is better to store the int value of enumn in database instead of its description and use lookup tables. Then you can simply get description of them using a single join. You can use ef-enum-to-lookup by Tim Abell.

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Oct 1, 2016 at 14:09

Hamid Pourjam

20.8k9 gold badges61 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Enum to string with Entity Framework

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related