表型号：
public class UserOwnerShip
{
public virtual int Id { get; set; }
public virtual User User { get; set; }
public virtual City City { get; set; }
public virtual Company Company { get; set; }
public virtual UserRole UserRole { get; set; }
public virtual DateTime RegistryDate { get; set; }
public virtual bool IsActive { get; set; }
}
制图：
internal class UserOwnerShipMap : ClassMap<UserOwnerShip>
{
public UserOwnerShipMap()
{
Id(x => x.Id);
Map(x => x.IsActive);
Map(x => x.UserRole).CustomType(typeof(int));
Map(x => x.RegistryDate);
References(x => x.User).Not.Nullable();
References(x => x.City).Nullable();
References(x => x.Company).Nullable();
}
}
我的EnumConvention课程：
public class EnumConvention : IUserTypeConvention
{
public void Accept(IAcceptanceCriteria<IPropertyInspector> criteria)
{
criteria.Expect(x => x.Property.PropertyType.IsEnum ||
(x.Property.PropertyType.IsGenericType &&
x.Property.PropertyType.GetGenericTypeDefinition() == typeof(Nullable<>) &&
x.Property.PropertyType.GetGenericArguments()[0].IsEnum)
);
}
public void Apply(IPropertyInstance target)
{
target.CustomType(target.Property.PropertyType);
}
}
和UserRole枚举
public enum UserRole
{
User,Operator,Manager,Admin
}
我的nhibernate配置部分：
....().Conventions.AddFromAssemblyOf<EnumConvention>())
所以当我查询：
IList<UserOwnerShip> userOwnerShip = session.QueryOver<UserOwnerShip>()
.Where(u => u.UserRole == UserRole.Owner)
.Where(u => u.IsActive)
.List<UserOwnerShip>();
我有例外：
Type mismatch in NHibernate.Criterion.SimpleExpression: UserRole expected type System.Int32,actual type XXX.XXX.UserRole (which is enum type class)
解决方法
如果要存储枚举的int值,则映射只是：
Map(x => x.UserRole).CustomType<UserRole>();
没有必要使用EnumConvention.
