使用流利的nhibernate映射枚举

3 回答

• 59

  以下显然不再有效https://stackoverflow.com/a/503327/189412

  这样做怎么样：

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

  自定义类型处理一切:)

  回复于 2024-04-29T00:08:26+08:00
• 1

  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默认将枚举值保存为字符串 . 就像是：

  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 ||
          (x.Property.PropertyType.IsGenericType && 
           x.Property.PropertyType.GetGenericTypeDefinition() == typeof(Nullable<>) &&
           x.Property.PropertyType.GetGenericArguments()[0].IsEnum)
          );
      }
  
      #endregion
  }
  

  几乎忘了您还需要将常规添加到您的流畅配置中 . 您可以在添加映射的同一位置执行此操作：

  .Mappings(m => m.FluentMappings.AddFromAssemblyOf<BillingRecordMap>()
  .Conventions.AddFromAssemblyOf<EnumConvention>()
  

  回复于 2024-04-29T00:08:26+08:00
• 36

  一个很好的方法是实现IUserType接口和创建一个带有写入和读取规则的CustomType，这是布尔的一个例子：

  public class CharToBoolean : IUserType
  {
      public SqlType[] SqlTypes => new[] { NHibernateUtil.String.SqlType };
  
      public Type ReturnedType => typeof(bool);
  
      public bool IsMutable =>true;
  
      public object Assemble(object cached, object owner)
      {
          return (cached);
      }
  
      public object DeepCopy(object value)
      {
          return (value);
      }
  
      public object Disassemble(object value)
      {
          return (value);
      }
  
      public new bool Equals(object x, object y)
      {
          if (ReferenceEquals(x, y)) return true;
  
          var firstObject = x as string;
          var secondObject = y as string;
  
          if (string.IsNullOrEmpty(firstObject) || string.IsNullOrEmpty(secondObject)) return false;
  
          if (firstObject == secondObject) return true;
          return false;
      }
  
      public int GetHashCode(object x)
      {
          return ((x != null) ? x.GetHashCode() : 0);
      }
  
      public object NullSafeGet(IDataReader rs, string[] names, object owner)
      {
          var obj = NHibernateUtil.String.NullSafeGet(rs, names[0]);
  
          if (obj == null) return null;
  
          var value = (string)obj;
  
          return value.ToBoolean();
      }
  
      public void NullSafeSet(IDbCommand cmd, object value, int index)
      {
          if(value != null)
          {
              if ((bool)value)
              {
                  ((IDataParameter)cmd.Parameters[index]).Value = "S";
              }
              else
              {
                  ((IDataParameter)cmd.Parameters[index]).Value = "N";
              }
          }
          else
          {
              ((IDataParameter)cmd.Parameters[index]).Value = DBNull.Value;
          }
      }
      public object Replace(object original, object target, object owner)
      {
          return original;
      }
  }
  

  }

  映射：

  this.Map(x => x.DominioGenerico).Column("fldominiogen").CustomType<CharToBoolean>();
  

  这是一个示例，但您可以使用其他类型执行此操作 .

  回复于 2024-04-29T00:08:26+08:00