How to map Enum in NHibernate using Mapping by Code

Question

I am getting following exception while accessing data form database using fluent NHibernate

An exception of type 'NHibernate.HibernateException' occurred in NHibernate.dll but was not handled in user code

Additional information: Can't Parse 1 as State

I have Enum type in my employee entity.

Employee

public class Employee
{
    public virtual Guid Id { get; set; }
    public virtual string Name { get; set; }
    public virtual DateTime DateOfBirth { get; set; }
    public virtual string ContactNumber  { get; set; }
    //[JsonConverter(typeof(StringEnumConverter))]
    public virtual State Status { set; get; }
    public virtual DateTime LastModify  { get; set; }
}

EmployeeMapping

public class EmployeeMap : ClassMapping<Employee>
{
    public EmployeeMap()

    {
        Table("Employee");

        Id(i => i.Id, m => m.Generator(Generators.GuidComb));

        Property(p => p.Name, m =>
        {
            m.NotNullable(false);
            m.Length(120);
        });

        Property(p => p.DateOfBirth, m => m.NotNullable(true));

        Property(p => p.ContactNumber, m =>
        {
            m.NotNullable(false);
            m.Length(12);
        });

        Property(p => p.Status, m => m.Column(y =>
        {
            y.NotNullable(true);
            y.Default(0);
        }));

        Version(v => v.LastModify, m =>
        {
            m.Column(y =>
            {
                y.NotNullable(true);
                y.Default("CURRENT_TIMESTAMP");
            });
            m.Type(NHibernateUtil.Timestamp);
            m.Generated(VersionGeneration.Never);
        });
    }       
}

State Enum

public enum State
{
    Probationer ,
    Permanent,
    Contractor
}

Please suggest me how to remove the exception.

This was discussed many times before, this is just one example http://stackoverflow.com/questions/12724128/fluent-nhibernate-enum-mapping — Alexey Zimarev, Mar 26 '16 at 09:24
@AlexeyZimarev I this link they Implement ClassMap<> but in my question I am implementing ClassMapping<> . In ClassMapping I don't have such option to map enum. — MANISH KUMAR CHOUDHARY, Mar 26 '16 at 10:21
Try using enum with values, so it actually make sense to use `Default(0)`. I mean `Probationer = 0` and so on. — Alexey Zimarev, Mar 26 '16 at 12:03
I tried enum with values also but getting same parsing error. — MANISH KUMAR CHOUDHARY, Mar 26 '16 at 12:17

score 2 · Answer 1 · answered Mar 28 '16 at 08:45

2

Try this:

Property(x => x.Status, x => x.Type(typeof(State), null));

answered Mar 28 '16 at 08:45

Alexey Zimarev

17,944
2
55
83

score 2 · Answer 2 · answered Feb 17 '20 at 16:05

When I tried using NHibernate Mapping by Code using the approach from Alexey or this:

Property(x => x.Command, o =>
{
  o.Type<CommandType>();
});

I got a mapping error along the lines of 'must implement IUserType. The correct way to map an enum is:

Property(x => x.Command, o =>
{
  o.Type<EnumType<CommandType>>();
});

How to map Enum in NHibernate using Mapping by Code

2 Answers2