Asp.Net MVC Code First Column not created

Question

I am using EF4.3.1 and MVC4 code first. My database is being created except for one column and no error is given. Why would this column not be created? Should I be using the EnumDataType attribute (it doesn't seem to do anything)?

public class Setting
{
    public Guid SettingId { get; set; }
    public string Key { get; set; }
    public string Value { get; set; }

    [Column("DataType", TypeName = "varchar")]
    public SettingDataType DataType { get; set; }
    }


    public enum SettingDataType
    {
        [Description("String")]
        text,
        [Description("Integer")]
        integer,
        [Description("Boolean")]
        boolean
    }

ntziolis · Accepted Answer · 2012-03-13 22:56:13Z

2

Enums are still not supported in EF 4.3. It does not make a difference whether you specify another DataType in the attribute.

Enums are simply completely ignored by EF when analyzing the class and generating the tables.

Enum support is promised for EF 5.0 though ... finally!

For now use an int Property instead and add another Property that casts the int to the enum value on the fly. Also just to be sure nothing breaks with the next EF version add the Ignore keyword.

public class Setting
{
    public Guid SettingId { get; set; }
    public string Key { get; set; }
    public string Value { get; set; }

    [Column("DataType", TypeName = "varchar")]
    public int DataTypeInt { get; set; }

    [Ignore]
    public SettingDataType DataType
    { 
        get { return (SettingDataType)this.DataTypeInt; }
        set { return this.DataTypeInt = (int)value; }
    }
}

edited Mar 13, 2012 at 22:56

answered Mar 13, 2012 at 22:50

ntziolis

10.2k1 gold badge36 silver badges50 bronze badges

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

Comments

Davin Tryon · Accepted Answer · 2012-03-13 22:51:06Z

2

Enums are not supported in EF until version 5.0. So, you are probably just hitting this limit.

answered Mar 13, 2012 at 22:51

Davin Tryon

67.4k15 gold badges149 silver badges139 bronze badges

Collectives™ on Stack Overflow

Asp.Net MVC Code First Column not created

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related