Enter enum as string in the database


I am experimenting with dapper. I have a class which has an enum and the values are stored as strings in the database.

This works with FluentNHibernate using GenericEnumMapper

Is it possible to do the same with Dapper?

This is not built in at the moment, there is a proposed solution for this here: http://code.google.com/p/dapper-dot-net/issues/detail?id=24 which we are yet to decide on. I like the idea of extensible type converters

As it stands the cleanest way to do this would be to define shadow property eg:

class MyType
   public MyEnum MyEnum {get; private set;}
   private string DBEnum { set { MyEnum = Convert(value);} }

   private MyEnum Convert(string val)
     // TODO: Write me

// cnn.Query<MyType>("select 'hello' as DBEnum")  <-- will set MyEnum