[Nhibernate-commit] SF.net SVN: nhibernate:[4390] trunk/nhibernate/src/NHibernate.Test/Criteria /CriteriaQueryTest.cs

[<fab...@us...>]

Revision: 4390
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=4390&view=rev
Author:   fabiomaulo
Date:     2009-05-29 16:35:45 +0000 (Fri, 29 May 2009)

Log Message:
-----------
Simple pagination Test using Criteria

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs

Modified: trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs	2009-05-27 23:06:09 UTC (rev 4389)
+++ trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs	2009-05-29 16:35:45 UTC (rev 4390)
@@ -286,6 +286,44 @@
 		}
 
 		[Test]
+		public void SimplePagination()
+		{
+			using (ISession session = OpenSession())
+			using (ITransaction t = session.BeginTransaction())
+			{
+				session.Save(new Student {Name = "Mengano", StudentNumber = 232});
+				session.Save(new Student {Name = "Ayende", StudentNumber = 999});
+				session.Save(new Student {Name = "Fabio", StudentNumber = 123});
+				session.Save(new Student {Name = "Merlo", StudentNumber = 456});
+				session.Save(new Student {Name = "Fulano", StudentNumber = 0});
+
+				t.Commit();
+			}
+
+			using (ISession session = OpenSession())
+			using (ITransaction t = session.BeginTransaction())
+			{
+				var result = session.CreateCriteria<Student>()
+					.Add(Restrictions.Gt("StudentNumber", 0L))
+					.AddOrder(Order.Asc("StudentNumber"))
+					.SetFirstResult(1).SetMaxResults(2)
+					.List<Student>();
+				Assert.That(result.Count, Is.EqualTo(2));
+				Assert.That(result[0].StudentNumber, Is.EqualTo(232));
+				Assert.That(result[1].StudentNumber, Is.EqualTo(456));
+
+				t.Commit();
+			}
+
+			using (ISession session = OpenSession())
+			using (ITransaction t = session.BeginTransaction())
+			{
+				session.CreateQuery("delete from Student").ExecuteUpdate();
+				t.Commit();
+			}
+		}
+
+		[Test]
 		public void CloningDetachedCriteriaTest()
 		{
 			DetachedCriteria dc = DetachedCriteria.For(typeof(Student))


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.