How to map tinyint to c# byte using entityframework code first migration

Question

I am trying to map tinyint column to byte property in c#How to achieve this efficiently. I want to store the values null, 0 and 1 to the database column. Please find below my code. Can anyone help me whether the following is the right approach?

public enum TriState : byte
{
    Null = 0,
    True = 1,
    False =2
}

[NotMapped]
public TriState AuthorisationStatus { get; set; }

[Column("AuthorisationStatus")]
public byte AuthorisationStatusByte {
    get
    {
        return Convert.ToByte(AuthorisationStatus.ToString());
    }
    private set
    {
        AuthorisationStatus = EnumExtensions.ParseEnum<TriState>(value);
    }
}

public static T ParseEnum<T>(byte value)
{
    return (T)Enum.Parse(typeof(T), value.ToString(), true);
}

Thanks

Jon Skeet · Accepted Answer · 2015-09-04 10:11:12Z

2

There's no need to go via a string at all. Just use the explicit conversions:

[Column("AuthorisationStatus")]
public byte AuthorisationStatusByte
{
    get { return (byte) AuthorisationStatus; }
    set { AuthorisationStatus = (TriState) value; }
}

(I'm assuming the column attribute is correct - I don't know about that side of things.)

answered Sep 4, 2015 at 10:11

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

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

2 Comments

Mukil Deepthi Over a year ago

Thank you. How about if it is byte? i.e nullable byte

Jon Skeet Over a year ago

@MukilDeepthi: Then you'd presumably want a nullable enum property as well... and you'd just add a ? within each of the casts as well.

Collectives™ on Stack Overflow

How to map tinyint to c# byte using entityframework code first migration

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related