Mapping Enums to Database with NHibernate/Castle ActiveRecord
- by Mike
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
