Using NHibernate to map a nChar column to an enumerated type
- by Morrislgn
Hello Folks,
I am trying to map a table frp, a SQL Server 2005 DB to a class which contains an enum:
public class MyClass{
private YesNoOptional addressSetting;
public YesNoOptional AddressSetting{
{get; set;}
}
}
public enum YesNoOptional {
Yes,
No,
Optional
}
This will dictate that one of three values is inserted into the corresponding column - 'Y', 'N', 'O'. This column is of type nchar(1).
My mapping file is like so (addressSetting is the property which is causing the problem):
<class name="IncidentDefinition" table="IR_INCIDENT_DEF" lazy="false" >
<id name="Guid" column="INT_GUID" >
<generator class="guid"></generator>
</id>
<property name="Reference" column="INT_REF" ></property>
<property name="Description" column="INT_DESCRIPTION" ></property>
<property name="AddressSetting" column="INT_ADDRESS_REQ" ></property>
<property name="Active" column="INT_ACTIVE" type="YesNo"></property>
<property name="PinDocId" column="INT_PIN_DOC_ID"></property>
</class>
Using the config above I get the following error:
NHibernate.ADOException: could not initialize a collection: System.FormatException: Input string was not in a correct format..
If I try to map the enum using a custom type like so:
<property name="AddressSetting" column="INT_ADDRESS_REQ" type="ML.Types.YesNoOptional, ML.Types" ></property>
Error: System.FormatException: Input string was not in a correct format.
Next, if I try using a specific type like so:
<property name="AddressSetting" column="INT_ADDRESS_REQ" type="String" ></property>
This error is generated: NHibernate.PropertyAccessException: The type System.String can not be assigned to a property of type System.ArgumentException: Object of type 'System.String' cannot be converted to type 'ML.Types.YesNoOptional'..
As a last resort I tried to specify the type as a char like so:
<property name="AddressSetting" column="INT_ADDRESS_REQ" type="Char" ></property>
This works a bit better, as it in it doesnt throw an error, however instead of returning the character from the table and mapping it to the enumerated type the ASCII value of the character is returned instead - so Y is represented by 89!
I am hoping someone can explain what I am doing wrong and\or how why this is happening please?
Thanks
Morris
