[Nhibernate-commit] SF.net SVN: nhibernate:[3947] trunk/nhibernate/src/NHibernate.Test

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

Revision: 3947
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=3947&view=rev
Author:   tehlike
Date:     2008-12-12 15:00:59 +0000 (Fri, 12 Dec 2008)

Log Message:
-----------
Added tests to support NH-1552 is no longer an issue after applying NH-1603(MSSQL 2005 Paging patch)

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.Test/NHibernate.Test.csproj

Added Paths:
-----------
    trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/
    trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/Fixture.cs
    trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/Mappings.hbm.xml
    trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/MyClass.cs

Added: trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/Fixture.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/Fixture.cs	                        (rev 0)
+++ trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/Fixture.cs	2008-12-12 15:00:59 UTC (rev 3947)
@@ -0,0 +1,56 @@
+using System;
+using System.Collections;
+using System.Collections.Generic;
+using System.Text;
+using NUnit.Framework;
+using NUnit.Framework.SyntaxHelpers;
+
+namespace NHibernate.Test.NHSpecificTest.NH1552
+{
+	[TestFixture]
+	public class Fixture : BugTestCase
+	{
+		protected override void OnSetUp()
+		{
+			using (var session = this.OpenSession())
+			{
+				using (var tran = session.BeginTransaction())
+				{
+					MyClass newServ = new MyClass();
+					newServ.Name = "tuna";
+					session.Save(newServ);
+					tran.Commit();
+				}
+			}
+		}
+		protected override void OnTearDown()
+		{
+			using (var session = this.OpenSession())
+			{
+				using (var tran = session.BeginTransaction())
+				{
+					session.Delete("from MyClass");
+					tran.Commit();
+				}
+			}
+		}
+
+		[Test]
+		public void Paging_with_sql_works_as_expected()
+		{
+			using (var session = this.OpenSession())
+			{
+				using (var tran = session.BeginTransaction())
+				{
+					string sql = "select * from MyClass";
+					IList list = session.CreateSQLQuery(sql)
+						.AddEntity(typeof(MyClass))
+						.SetFirstResult(0)
+						.SetMaxResults(50)
+						.List();
+					Assert.That(list.Count, Is.EqualTo(1));
+				}
+			}
+		}
+	}
+}
\ No newline at end of file

Added: trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/Mappings.hbm.xml
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/Mappings.hbm.xml	                        (rev 0)
+++ trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/Mappings.hbm.xml	2008-12-12 15:00:59 UTC (rev 3947)
@@ -0,0 +1,12 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
+                   assembly="NHibernate.Test"
+                   namespace="NHibernate.Test.NHSpecificTest.NH1552">
+
+	<class name="MyClass">
+		<id name="Id">
+			<generator class="native"/>
+		</id>
+		<property name="Name"/>
+	</class>
+</hibernate-mapping>
\ No newline at end of file

Added: trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/MyClass.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/MyClass.cs	                        (rev 0)
+++ trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1552/MyClass.cs	2008-12-12 15:00:59 UTC (rev 3947)
@@ -0,0 +1,12 @@
+using System;
+using System.Collections.Generic;
+using System.Text;
+
+namespace NHibernate.Test.NHSpecificTest.NH1552
+{
+	public class MyClass
+	{
+		public virtual int Id { get; set; }
+		public virtual string Name { get; set; }
+	}
+}

Modified: trunk/nhibernate/src/NHibernate.Test/NHibernate.Test.csproj
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/NHibernate.Test.csproj	2008-12-12 14:57:17 UTC (rev 3946)
+++ trunk/nhibernate/src/NHibernate.Test/NHibernate.Test.csproj	2008-12-12 15:00:59 UTC (rev 3947)
@@ -521,6 +521,8 @@
     <Compile Include="NHSpecificTest\NH1508\Fixture.cs" />
     <Compile Include="NHSpecificTest\NH1508\Person.cs" />
     <Compile Include="NHSpecificTest\NH1515\Fixture.cs" />
+    <Compile Include="NHSpecificTest\NH1552\Fixture.cs" />
+    <Compile Include="NHSpecificTest\NH1552\MyClass.cs" />
     <Compile Include="NHSpecificTest\NH1556\Claim.cs" />
     <Compile Include="NHSpecificTest\NH1556\Fixture.cs" />
     <Compile Include="NHSpecificTest\NH1556\Patient.cs" />
@@ -1558,6 +1560,7 @@
     <EmbeddedResource Include="Cascade\JobBatch.hbm.xml" />
     <EmbeddedResource Include="Deletetransient\Person.hbm.xml" />
     <Content Include="DynamicEntity\package.html" />
+    <EmbeddedResource Include="NHSpecificTest\NH1552\Mappings.hbm.xml" />
     <EmbeddedResource Include="NHSpecificTest\NH1349\Mappings.hbm.xml" />
     <EmbeddedResource Include="NHSpecificTest\NH1593\TestIndex.hbm.xml" />
     <EmbeddedResource Include="NHSpecificTest\NH1594\Mappings.hbm.xml" />


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