In using Dapper's Query() function, I am trying to fill in a class that has a property which is an enumerated value. In my database, this column is stored as a byte. However, in the class, they are an enum. In the old ADO.NET approach, I'd convert during the reader loop:
myClass.myEnum = (MyEnumType) reader.GetByte(2);
When using Dapper, I can't figure out how to do this conversion. For example when I do something like
myClass = conn.Query<MyClassType>("SELECT ... ")
I get an error of the type
Error parsing column 2 (myEnum=1 - Byte)
Is there a way to use Dapper's Query() to fill in a class that contains properties which are enum types?