CODEWITHSUNDEEP
.netnhibernatefluent-nhibernatenhibernate-mapping
Dejan.S
Dejan.S

Reputation: 19118

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

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();
    }

Upvotes: 1

Views: 671

Answers (3)

Paco
Paco

Reputation: 8381

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()

Upvotes: 0

Hannoun Yassir
Hannoun Yassir

Reputation: 21182

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

Upvotes: 0

queen3
queen3

Reputation: 15501

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.

Upvotes: 2

Related Questions