public void SaveCategory_AndAssociateProducts_ShouldSaveAssociations_And_Entities()
{
// Create the category and the products
var category = new Category { Name = "Category1" };
var product1 = new Product { Name = "Product1", Discontinued = false };
var product2 = new Product { Name = "Product2", Discontinued = false };
var product3 = new Product { Name = "Product3", Discontinued = false };
// Associate the products with the category
product1.Category = category;
product2.Category = category;
product3.Category = category;
// We can also do this, it won't generate extra SQL statements
// because category.Products collection is set with "inverse=true"
category.Products = new List<Product> { product1, product2, product3 };
// Save everything in the session and commit the transaction
using (var session = this.sessionFactory.OpenSession())
using (var transaction = session.BeginTransaction())
{
session.Save(category);
transaction.Commit();
}
}
public void SaveOnlyCategory_WithProducts_ShouldThrowException()
{
// Create the category and the products
var category = new Category { Name = "Category1" };
var product1 = new Product { Name = "Product1", Discontinued = false };
var product2 = new Product { Name = "Product2", Discontinued = false };
var product3 = new Product { Name = "Product3", Discontinued = false };
// Associate the products with the category
category.Products = new List<Product> { product1, product2, product3 };
// Save everything in the session and commit the transaction
using (var session = this.sessionFactory.OpenSession())
using (var transaction = session.BeginTransaction())
{
// NHibernate will throw a PropertyValueException here
// because the Product.CategoryId is set as 'not-null'
session.Save(category);
transaction.Commit();
}
}
