public async Task BugAsync()
{
int custId;
using (ISession s = OpenSession())
{
Customer c = new Customer();
c.Name = "TestCustomer";
await(s.SaveAsync(c));
custId = c.Id;
Article art = new Article();
art.Name = "TheArticle1";
art.Price = 10.5M;
await(s.SaveAsync(art));
Order o = c.CreateNewOrder();
OrderLine ol = o.CreateNewOrderLine();
ol.SetArticle(art);
ol.NumberOfItems = 5;
o.AddOrderLine(ol);
await(s.SaveAsync(o));
await(s.FlushAsync());
}
using (ISession s = OpenSession())
{
string hql = "select sum (ol.ArticlePrice * ol.NumberOfItems) " +
"from Order o, OrderLine ol, Customer c " +
"where c.Id = :custId and o.OrderDate >= :orderDate";
IQuery q = s.CreateQuery(hql);
q.SetInt32("custId", custId);
q.SetDateTime("orderDate", DateTime.Now.AddMonths(-3));
Assert.AreEqual(52.5m, await(q.UniqueResultAsync <decimal>()));
}
using (ISession s = OpenSession())
{
Order o = (Order)await(s.CreateQuery("from Order").UniqueResultAsync());
OrderLine ol = (OrderLine)o.OrderLines[0];
await(s.DeleteAsync(ol));
o.OrderLines.RemoveAt(0);
await(s.DeleteAsync(o));
await(s.DeleteAsync(o.OwningCustomer));
await(s.DeleteAsync("from Article"));
await(s.FlushAsync());
}
}
public void Bug()
{
using (ISession s = OpenSession())
{
Customer c = new Customer();
c.Name = "TestCustomer";
s.Save(c);
Article art = new Article();
art.Name = "TheArticle1";
art.Price = 10.5M;
s.Save(art);
Order o = c.CreateNewOrder();
OrderLine ol = o.CreateNewOrderLine();
ol.SetArticle(art);
ol.NumberOfItems = 5;
o.AddOrderLine(ol);
s.Save(o);
s.Flush();
}
using (ISession s = OpenSession())
{
string hql = "select sum (ol.ArticlePrice * ol.NumberOfItems) " +
"from Order o, OrderLine ol, Customer c " +
"where c.Id = :custId and o.OrderDate >= :orderDate";
IQuery q = s.CreateQuery(hql);
q.SetInt32("custId", 1);
q.SetDateTime("orderDate", DateTime.Now.AddMonths(-3));
Assert.AreEqual(52.5m, (decimal)q.UniqueResult());
}
using (ISession s = OpenSession())
{
Order o = (Order)s.CreateQuery("from Order").UniqueResult();
OrderLine ol = (OrderLine)o.OrderLines[0];
s.Delete(ol);
o.OrderLines.RemoveAt(0);
s.Delete(o);
s.Delete(o.OwningCustomer);
s.Delete("from Article");
s.Flush();
}
}