Querying entities throws "Invalid Operation Exception" on enum field

Question

I was just trying some features of entity framework 5 and kendo ui. I have a following ProductType enum ``` public enum ProductType { [Description("Hazardous")] Hazardous, [Description("Non Hazardous")] NonHazardous } ``` This enum type is one of the field in the Product Entity. ``` [Table("Products")] public class Product { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } //Other Fields ... [Required(ErrorMessage="Product Type is Required")] public ProductType ProductType {get;set;} } ``` The ProductType column in the underlying SQL Server Database is defined as (tinyint, not null). I access list of Products in the following Controller Action of MVC ``` public ActionResult _ProductList(int pageSize, int skip) { using (WorkUnit workUnit = new WorkUnit()) { IQueryable products = workUnit.ProductRepository.GetAllProducts() .Include(p => p.Category); int total = products.Count(); List productList = products.ToList(); //Thr…

Accepted Answer

There is a mismatch between the enum type which in your case is `int` based and your database where the column is byte (tinyint) based. You can fix this by setting the correct underlying type of your enum type:

```
public enum ProductType : byte
{
...
}
```

Querying entities throws "Invalid Operation Exception" on enum field

Solution

Problem