wont save to database with guid as id- fluent-nhib

2019-08-06 05:03发布

i got problems with saving when i use Guid as identifier. can anybody se what i am missing here? i create my own guid so i dont want it to be generated by database.

NOTE: i have tried the guid.combo in mapping to without any success.

public class Order
{
    public virtual Guid Id { get; set; }
    public virtual ICollection<OrderItem> OrderItems { get; set; }
    public virtual User User { get; set; }
    public virtual DateTime? CreateDate { get; set; }
    public virtual DateTime? ShippedDate { get; set; }
    public virtual string OrderStatus { get; set; }

    public Order()
    {
        OrderItems = new Collection<OrderItem>();
    }

    public virtual void AddOrderItems(OrderItem orderItem)
    {
        orderItem.Order = this;
        OrderItems.Add(orderItem);
    }
}

OrderMap:

public OrderMap()
    {
        Id(x => x.Id).ColumnName("Id").GeneratedBy.Guid();

        Map(x => x.CreateDate);
        Map(x => x.ShippedDate);
        Map(x => x.OrderStatus);

        References(x => x.User);
        HasMany(x => x.OrderItems).Cascade.All().Inverse().LazyLoad();
    } 

3条回答
Evening l夕情丶
2楼-- · 2019-08-06 05:50

you dont have to add GeneratedBy.Guid() it will work just fine also try using GeneratedBy.GuidComb(); it is recomended when using guids

查看更多
神经病院院长
3楼-- · 2019-08-06 05:51

You can generate the guid before inserting the entity in the database. The benefit of that is that entities are the same before and after persitence in the database. It makes it easier to ignore the database in the code.

public class Order
{
   public Order()
   {
      Id = GuidGenerator.GenerateGuid();
   }

   public Guid Id { get; private set; }
}

public class Mapping
{
    Id(x => x.Id).GeneratedBy.Assigned().Access.AsCamelCaseField();
}

GuidGenerator.GenerateGuid() returns a guid generated by the guid comb algorithm or something like Guid.NewGuid()

查看更多
啃猪蹄的小仙女
4楼-- · 2019-08-06 05:56

Id(x => x.Id).ColumnName("Id").GeneratedBy.Assigned()

Also .WithUnsavedValue(Guid.Empty) might be needed but I'm not sure. You'll probably need to tell NHibernate to use Save or Update (not SaveOrUpdate) each time, anyway. Not a big expert here... but you need to use .Assigned() for sure.

查看更多
登录 后发表回答