I have a Store and a Product entity:
public class Store
{
public Guid Id { get; set; }
public int Version { get; set; }
public ISet<Product> Products { get; set; }
}
public class Product
{
public Guid Id { get; set; }
public int Version { get; set; }
public Store ParentStore { get; set; }
public string Name { get; set; }
}
In other words, I have a Store that can contain multiple Products in a bidirectional one-to-many relationship.
I'm sending data back and forth between a web browser and a web service. The following steps emulates the communication between the two, using session-per-request.
I first save a new instance of a Store:
using (new SessionScope())
{
// this is data from the browser
var store = new Store { Id = Guid.Empty };
ActiveRecordMediator.SaveAndFlush(store);
}
Then I grab the store out of the DB, add a new product to it, and then save it:
using (new SessionScope())
{
// this is data from the browser
var product = new Product { Id = Guid.Empty, Name = "Apples" });
var store = ActiveRecordLinq.AsQueryable<Store>().First();
store.Products.Add(product);
ActiveRecordMediator.SaveAndFlush(store);
}
Up to this point, everything works well. Now I want to update the Product I just saved:
using (new SessionScope())
{
// data from browser
var product = new Product { Id = Guid.Empty, Version = 1, Name = "Grapes" };
var store = ActiveRecordLinq.AsQueryable<Store>().First();
store.Products.Add(product);
// throws exception on this call
ActiveRecordMediator.SaveAndFlush(store);
}
When I try to update the product, I get the following exception:
a different object with the same identifier value was already associated with the session: 00000000-0000-0000-0000-000000000000, of entity:Product"
As I understand it, the problem is that when I get the Store out of the database, it also gets the Product that's associated with it. Both entities are persistent. Then I tried to save a transient Product (the one that has the updated info from the browser) that has the same ID as the one that's already associated with the session, and an exception is thrown.
However, I don't know how to get around this problem. If I could get access to a NHibernate.ISession, I could call ISession.Merge() on it, but it doesn't look like ActiveRecordMediator has anything similar (SaveCopy threw the same exception). Does anyone know the solution? Any help would be greatly appreciated!
