Fluent NHibernate 插入 Null FK

Question

我有一个带有可为空 FK 约束的表映射。在我的流畅映射中，我正在做类似这样的事情：

public enum PlayerPosition
{
        None = 0,
        Forward = 1
//etc
}

Entity

public virtual PlayerPosition? Position { get; set; }

Map(x => x.Position).Column("PlayerPositionId").CustomType< PlayerPosition>();

我希望发生的是当 PlayerPosition 设置为“None”时，Nhibernate 将插入 null。我不知道如何实现这一点。

Answer 1

我会选择 IUserType：

public virtual PlayerPosition Position { get; set; }

Map(x => x.Position).Column("PlayerPositionId").CustomType<PlayerPositionUserType>();

class PlayerPositionUserType : IUserType
{

    public object NullSafeGet(IDBReader reader, string[] names, object owner)
    {
        int? positionvalue = NHibernateUtil.Int32.NullSafeGet(reader, names[0]);
        return (positionvalue.HasValue) ? (PlayerPosition)positionvalue : PlayerPosition.None;
    }

    public void NullSafeSet(IDBCommand cmd, object value, int index)
    {
        var position = (PlayerPosition)value;
        if (position == PlayerPosition.None)
            NHibernateUtil.Int32.NullSafeSet(cmd, null, index);
        else
            NHibernateUtil.Int32.NullSafeSet(cmd, (int)position, index);
    }

    public Type ReturnType
    {
        get { return typeof(PlayerPosition); }
    }

    public SqlType[] SqlTypes
    {
        get { return new [] { SqlTypeFactory.Int32 } }
    }
}