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

[<pa...@us...>]

Revision: 5469
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5469&view=rev
Author:   patearl
Date:     2011-03-13 23:17:23 +0000 (Sun, 13 Mar 2011)

Log Message:
-----------
Fixed NH1792.

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

Modified: trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1792/Fixture.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1792/Fixture.cs	2011-03-13 23:00:55 UTC (rev 5468)
+++ trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1792/Fixture.cs	2011-03-13 23:17:23 UTC (rev 5469)
@@ -79,9 +79,13 @@
 		{
 			using (ISession session = OpenSession())
 			{
+				string top = "";
+				if (Dialect.GetType().Name.StartsWith("Mssql"))
+					top = "top 5";
+
 				IList<Product> results =
 					session.CreateCriteria<Product>().Add(
-						Expression.Sql("{alias}.Id in (Select p.Id from Product p order by Name)")).Add(Restrictions.Gt("Id", 0)).
+						Expression.Sql("{alias}.Id in (Select " + top + " p.Id from Product p order by Name)")).Add(Restrictions.Gt("Id", 0)).
 						SetMaxResults(3).List<Product>();
 
 				Assert.AreEqual(3, results.Count);


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