public void find()
{
var criteria = _invoiceLineRepo.Session.CreateCriteria <InvoiceLine>();
criteria.Add(Restrictions.Eq("InvoiceId", 3));
var totalItems = 0;
var list = _invoiceLineRepo.Find(criteria, out totalItems);
Assert.IsNotEmpty(list);
Assert.AreEqual(6, totalItems);
}
private static void QueryWithPagination()
{
NHibernateRepository <UserAccount> accts = new NHibernateRepository <UserAccount>();
long total;
var data = accts.Find(x => x.Id > 300, "Username", OrderByDirection.Descending, 2, 10, out total).ToList();
//var data = accts.All().OrderByDescending(x => x.Email).Skip(0).Take(10).ToList();
data.ForEach(x => Console.WriteLine(x.ToString()));
}
