public void WorkBut()
{
using (ISession s = OpenSession())
using (ITransaction tx = s.BeginTransaction())
{
s.Save(new CustomerNoSmart("Somebody"));
CustomerNoSmart c = new CustomerNoSmart("Somebody else");
c.Category = new CustomerCategory("User");
s.Save(c.Category);
s.Save(c);
tx.Commit();
}
using (ISession s = OpenSession())
{
IList result = s.CreateQuery("select c.Name, cat.Name from CustomerNoSmart c left outer join c.Category cat").List();
Assert.That(result.Count, Is.EqualTo(2));
}
using (ISession s = OpenSession())
using (ITransaction tx = s.BeginTransaction())
{
s.Delete("from CustomerNoSmart");
s.Delete("from Category");
tx.Commit();
}
}
public async Task WorkButAsync()
{
using (ISession s = OpenSession())
using (ITransaction tx = s.BeginTransaction())
{
await(s.SaveAsync(new CustomerNoSmart("Somebody")));
CustomerNoSmart c = new CustomerNoSmart("Somebody else");
c.Category = new CustomerCategory("User");
await(s.SaveAsync(c.Category));
await(s.SaveAsync(c));
await(tx.CommitAsync());
}
using (ISession s = OpenSession())
{
IList result = await(s.CreateQuery("select c.Name, cat.Name from CustomerNoSmart c left outer join c.Category cat").ListAsync());
Assert.That(result.Count, Is.EqualTo(2));
}
using (ISession s = OpenSession())
using (ITransaction tx = s.BeginTransaction())
{
await(s.DeleteAsync("from CustomerNoSmart"));
await(s.DeleteAsync("from Category"));
await(tx.CommitAsync());
}
}
public void WorkBut()
{
using (ISession s = OpenSession())
using (ITransaction tx = s.BeginTransaction())
{
s.Save(new CustomerNoSmart("Somebody"));
CustomerNoSmart c = new CustomerNoSmart("Somebody else");
c.Category = new CustomerCategory("User");
s.Save(c.Category);
s.Save(c);
tx.Commit();
}
using (ISession s = OpenSession())
{
IList result = s.CreateQuery("select c.Name, cat.Name from CustomerNoSmart c left outer join c.Category cat").List();
Assert.That(result.Count, Is.EqualTo(2));
}
using (ISession s = OpenSession())
using (ITransaction tx = s.BeginTransaction())
{
s.Delete("from CustomerNoSmart");
s.Delete("from Category");
tx.Commit();
}
}