I am receving an error retreving a value from a field that has been customized to map to an enum.  In the BOM I set the ACTIONTYPECODE field to use the InspectionType Field Data Type. No problems there.   I build partial and get the following code in my .Designer file:

[Browsable(false),BusinessFieldDisplayInEditor(),Description("ACTIONTYPECODE"),DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
public InspectionType ACTIONTYPECODE
{
   get
   {
      return (InspectionType)this.CurrentRow["ACTIONTYPECODE"];
   }
   set
   {
      this.CurrentRow["ACTIONTYPECODE"] = value;
   }
}

and here is the enum:

public enum InspectionType
{
   Foo= 0,
   Bar= 1,
   Zip= 2
}

Nothing too complex.  Stepping through the cose I can assign a value to ACTIONTYPECODE without issue.  But when I hit the 'Get' I end up with this error:

Cannot unbox 'this.CurrentRow["ACTIONTYPECODE"]' as a 'InspectionType'

Now this would make sense to me since the field seems to be stored as a string and last time I tried I had to do something like this: (InspectionType)Enum.Parse(typeof(InspectionType), "Foo"); to cast a string as an enum.  What am I screwing up?

I just had this issue so I figured I'd post the answer on this old entry. It is because there is a type mismatch between your db field and the enum's type. By default Enums are Int types but stingy DBA's like me only use TinyInt's for field that are will be enum values. That translates into a byte type in .Net.



The solution is to change your enum to:



public enum InspectionType : byte

{

Foo= 0,

Bar= 1,

Zip= 2

}



Then it will work correctly.