How can i save an enum in my context in EF code first version 6

Question

Hi I need to save a single enum in my context, I tryed this:

  public class Context : DbContext
  {
      public Context() : base("name=Context"){}

      MyEnum MyEnum  { get; set; }
      public DbSet<Object1> Objects{ get; set; }

}

, when I modify MyEnum it changes its value but after saving changes when I want to use it goes back to the enum of value 0. Heres my modification code:

 MyEnum example = MyEnum.Value1;
 using (var ctx = new Context())
        {
            ctx.CriterioPlanificacion = example;
            ctx.SaveChanges();
        }

What SQL is being generated? https://msdn.microsoft.com/en-us/data/dn469464.aspx — Steve Greene, Jun 15 '15 at 13:19

score 0 · Answer 1 · edited May 23 '17 at 12:22

0

Enum default type is an int. It is normal that the value is 0 because it is the first element. If you want to put a description for your elements you can use the description attribute and retrieve it as shown here.

edited May 23 '17 at 12:22

Community

1
1

answered Jun 14 '15 at 21:11

AlexB

3,518
4
29
46

In the database and in the memory the enum is saved like an int i know, but my problem is that the conext method SaveChanges() isnt changing my db – Fernando Acosta y Lara Jun 14 '15 at 21:19

Fernando Acosta y Lara · Accepted Answer · 2016-06-04T17:00:46.380

0

So I found this old question I made, so i tested it. The migrations after adding a enum to the DbContext are empty, so EF doesnt saves the ints in a DbContext.

Microsoft documentation recommends only using DbSets that only exposes DbSets with collections of TEntities in it

edited Jun 04 '16 at 17:00

answered May 31 '16 at 21:44

Fernando Acosta y Lara

51
1
8

score 0 · Answer 3 · answered Jul 02 '17 at 19:19

0

In my case, the problem was that the Enum field had property "StoreGeneratedPattern" with value = "Computed". After changing to 'None' - everything started working correctly.

answered Jul 02 '17 at 19:19

reesly

1

If you have a question just use Ask Question or provide a good solution for the user – yass Jul 02 '17 at 20:19

How can i save an enum in my context in EF code first version 6

3 Answers3