Mapping Enums to Database with NHibernate/Castle ActiveRecord

Posted by Mike on Stack Overflow See other posts from Stack Overflow or by Mike
Published on 2010-06-05T03:31:08Z Indexed on 2010/06/06 17:32 UTC
Read the original article Hit count: 653

There's a few other posts on mapping Enums to the DB with ActiveRecord, but none of them answer my question. I have an enum called OrderState:

public enum OrderState {InQueue, Ordered, Error, Cancelled}

And I have the following property on the table:

[Property(NotNull = true, SqlType = "orderstate", ColumnType = "DB.EnumMapper, WebSite")]
public OrderState State
{
   get { return state; }
   set { state = value; }
}

And I have the following type class:

public class EnumMapper : NHibernate.Type.EnumStringType<OrderState>
{
   public EnumMapper()
   {
   }

   public override NHibernate.SqlTypes.SqlType SqlType
   {
      get
      {
         return new NHibernate.SqlTypes.SqlType(DbType.Object);
      }
   }
}

Now this actually works the way I want, but the problem is I have tons of enums and I don't want to create a EnumMapper class for each one of them. Isn't there some way to just tell ActiveRecord to use DbType.Object for any enum? It seems to either want to be an integer or a string, but nothing else. This one's been driving me crazy for the last 2 hours..

Mike

© Stack Overflow or respective owner

Related posts about c#

Related posts about nhibernate