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())); }