How do you map enums to and from the database using NHibernate?

Question

Edit: Ryan raised a good point. I specifically want to be able to map to and from while still storing human-readable values in the database. That is, I don't want a bunch of enumeration integers in my database.

Answer 1

I've never used NHibernate, but can't you just set the SQL datatype to int?

Answer 2

You have to implement a custom IUserType. See this post.

Answer 3

According to the documentation you can either leave the type attribute of the property in your mapping file blank or you define it and specify the class name of the enumeration.

Another way would be to convert the enumeration to an int and use the int as the mapped type.

Answer 4

I think you can just set the type to string:

<property name="EnumProperty" Type="string" Length="50" NotNull="true" />