[Nhibernate-commit] SF.net SVN: nhibernate:[3952] trunk/nhibernate/src/NHibernate.Test/ NHSpecificTest/NH1552/Fixture.cs

[<te...@us...>]

Revision: 3952
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=3952&view=rev
Author:   tehlike
Date:     2008-12-14 14:03:45 +0000 (Sun, 14 Dec 2008)

Log Message:
-----------
Adding more test for NH-1552

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/Fixture.cs

Modified: trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/Fixture.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/Fixture.cs	2008-12-14 11:11:54 UTC (rev 3951)
+++ trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/Fixture.cs	2008-12-14 14:03:45 UTC (rev 3952)
@@ -23,7 +23,13 @@
 				{
 					MyClass newServ = new MyClass();
 					newServ.Name = "tuna";
+                    MyClass newServ2 = new MyClass();
+                    newServ2.Name = "sidar";
+                    MyClass newServ3 = new MyClass();
+                    newServ3.Name = "berker";
 					session.Save(newServ);
+                    session.Save(newServ2);
+                    session.Save(newServ3);
 					tran.Commit();
 				}
 			}
@@ -41,21 +47,61 @@
 		}
 
 		[Test]
-		public void Paging_with_sql_works_as_expected()
+		public void Paging_with_sql_works_as_expected_with_FirstResult()
 		{
 			using (var session = this.OpenSession())
 			{
 				using (var tran = session.BeginTransaction())
 				{
-					string sql = "select * from MyClass";
-					IList list = session.CreateSQLQuery(sql)
+					string sql = "select * from MyClass order by Name asc";
+					IList<MyClass> list = session.CreateSQLQuery(sql)
 						.AddEntity(typeof(MyClass))
-						.SetFirstResult(0)
-						.SetMaxResults(50)
-						.List();
-					Assert.That(list.Count, Is.EqualTo(1));
+						.SetFirstResult(1)
+						.List<MyClass>();
+					Assert.That(list.Count, Is.EqualTo(2));
+				    Assert.That(list[0].Name, Is.EqualTo("sidar"));
+                    Assert.That(list[1].Name, Is.EqualTo("tuna"));
 				}
 			}
 		}
+
+        [Test]
+        public void Paging_with_sql_works_as_expected_with_MaxResult()
+        {
+            using (var session = this.OpenSession())
+            {
+                using (var tran = session.BeginTransaction())
+                {
+                    string sql = "select * from MyClass order by Name asc";
+                    IList<MyClass> list = session.CreateSQLQuery(sql)
+                        .AddEntity(typeof(MyClass))
+                        .SetMaxResults(2)
+                        .List<MyClass>();
+                    Assert.That(list.Count, Is.EqualTo(2));
+                    Assert.That(list[0].Name, Is.EqualTo("berker"));
+                    Assert.That(list[1].Name, Is.EqualTo("sidar"));
+                }
+            }
+        }
+
+
+        [Test]
+        public void Paging_with_sql_works_as_expected_with_FirstResultMaxResult()
+        {
+            using (var session = this.OpenSession())
+            {
+                using (var tran = session.BeginTransaction())
+                {
+                    string sql = "select * from MyClass";
+                    IList<MyClass> list = session.CreateSQLQuery(sql)
+                        .AddEntity(typeof(MyClass))
+                        .SetFirstResult(1)
+                        .SetMaxResults(1)
+                        .List<MyClass>();
+                    Assert.That(list.Count, Is.EqualTo(1));
+                    Assert.That(list[0].Name, Is.EqualTo("sidar"));
+                }
+            }
+        }
 	}
 }
\ No newline at end of file


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