Enum model property support? about entityframework-classic HOT 5 CLOSED

For what it's worth, this does work in EF Core, but you have to update the primary key field in the foreign key table to match the same enum and specify the database column type. So, a working version of my example would be:

public class EntitySimple
{
    [Key]
    public int ID { get; set; }
    public int ColumnInt { get; set; }
	
    [Column("TypeID", TypeName = "int")]
    public MyEnumType TypeID { get; set; }
    public MyEnumDbType EntityType { get; set; }
}

public enum MyEnumType  
{
    A = 1,
    B = 2,
    C = 3
}

public class MyEnumDbType
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.None)]
    [Column(TypeName = "int")]
    public MyEnumType ID { get; set; }
    public string Name { get; set; }
}

The DatabaseGeneratedOption.None flag tells the model generator to not enable auto-increment on the primary key field, with the assumption that the enum table is manually maintained.

from entityframework-classic.

Hello @tiesont ,

Thank you for reporting, we will look at it.

Best Regards,

Jonathan

from entityframework-classic.

Super. "Yeah, that doesn't work" is a perfectly acceptable response, by-the-way; I just need to know if it's supposed to work, and if so, how to set it up.

Thanks for the quick reply, too.

from entityframework-classic.

Hello @tiesont ,

My developer has looked at it.

He created a Fiddle with your example: https://dotnetfiddle.net/Gnmhda

However, he is not sure about the "My TypeID column is a foreign key, if it's relevant." part.

Do you think you could show him how you are doing it?

from entityframework-classic.

I think that's the issue, then. From that fiddle, my model would look something like

public class EntitySimple
{
    public int ID { get; set; }
    public int ColumnInt { get; set; }
	
    [Column("TypeID", TypeName = "int")]
    public MyEnumType TypeID { get; set; }
    public MyEnumDbType EntityType { get; set; }
}

public enum MyEnumType  
{
    A = 1,
    B = 2,
    C = 3
}

public class MyEnumDbType
{
    public int ID { get; set; }
    public string Name { get; set; }
}

The idea is that the values stored in the MyEnumDbType table are fixed values which are used internally in the application we're building. The table is mostly there for associating a descriptive text value (what we show in the application) with the fixed values of of MyEnumType; the ID value of MyEnumDbType corresponds to one of the MyEnumType constants.

So, this mostly likely the problem - EF is trying to match the data type, int, of MyEnumDbType.ID with the EntitySimple.TypeID value, which it can't do. I'll do some digging, but I think you've shown me what I want to do doesn't work.

from entityframework-classic.