views:

712

answers:

2

I am following the http://wiki.fluentnhibernate.org/Getting%5Fstarted tutorial to create my first NHibernate project with Fluent NHibernate

I have 2 tables

1) Account with fields

Id
AccountHolderName
AccountTypeId

2) AccountType with fields

Id
AccountTypeName

Right now the account types can be Savings or Current So the table AccountTypes stores 2 rows 1 - Savings 2 - Current

For AccoutType table I have defined enum

public enum AccountType {
    Savings=1,
    Current=2
}

For Account table I define the entity class

public class Account {
    public virtual int Id {get; private set;}
    public virtual string AccountHolderName {get; set;}
    public virtual string AccountType {get; set;}
}

The fluent nhibernate mappings are:

public AgencyMap() {
    Id(o => o.Id);
    Map(o => o.AccountHolderName);
    Map(o => o.AccountType);
}

When I try to run the solution, it gives an exception - InnerException = {"(XmlDocument)(2,4): XML validation error: The element 'class' in namespace 'urn:nhibernate-mapping-2.2' has incomplete content. List of possible elements expected: 'meta, subselect, cache, synchronize, comment, tuplizer, id, composite-id' in namespace 'ur...

I guess that is because I have not speciofied any mapping for AccountType.

The questions are:

  1. How can I use AccountType enum instead of a AccountType class?
  2. Maybe I am going on wrong track. Is there a better way to do this?

Thanks!

+4  A: 
public class Account {
    public virtual int Id {get; private set;}
    public virtual string AccountHolderName {get; set;}
    public virtual AccountType AccountType {get; set;}
}

public AgencyMap() {
    Id(o => o.Id);
    Map(o => o.AccountHolderName);
    Map(o => o.AccountType);
}

Fluent NHibernate saves enum values as string by default if you want to override that you need to supply a convention for it. Something like:

public class EnumConvention :
    IPropertyConvention, 
    IPropertyConventionAcceptance
{
    #region IPropertyConvention Members

    public void Apply(IPropertyInstance instance)
    {
        instance.CustomType(instance.Property.PropertyType);
    }

    #endregion

    #region IPropertyConventionAcceptance Members

    public void Accept(IAcceptanceCriteria<IPropertyInspector> criteria)
    {
        criteria.Expect(x => x.Property.PropertyType.IsEnum);
    }

    #endregion
}

Almost forgot that you need to add the convention to your fluent config as well. You do that at the same place you add the mappings:

.Mappings(m => m.FluentMappings.AddFromAssemblyOf<BillingRecordMap>()
.Conventions.AddFromAssemblyOf<EnumConvention>()
mhenrixon
Perfect! Thanks very much!
Puneet
+2  A: 

How about just doing this:

public AgencyMap() {
    Id(o => o.Id);
    Map(o => o.AccountHolderName);
    Map(o => o.AccountType).CustomType<int>();
}

The custom type handles everything :)

burnt_hand
Aha! I was using CustomSqlType and it wasn't working! What I needed was CustomType!
Matt Grande