[Nhibernate-commit] SF.net SVN: nhibernate:[5508] trunk/nhibernate/src/NHibernate/Dialect/ MsSqlCe40Dialect.cs

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

Revision: 5508
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5508&view=rev
Author:   fabiomaulo
Date:     2011-03-23 14:27:03 +0000 (Wed, 23 Mar 2011)

Log Message:
-----------
Apply NH-2590

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Dialect/MsSqlCe40Dialect.cs

Modified: trunk/nhibernate/src/NHibernate/Dialect/MsSqlCe40Dialect.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Dialect/MsSqlCe40Dialect.cs	2011-03-22 23:28:30 UTC (rev 5507)
+++ trunk/nhibernate/src/NHibernate/Dialect/MsSqlCe40Dialect.cs	2011-03-23 14:27:03 UTC (rev 5508)
@@ -1,3 +1,4 @@
+using NHibernate.Dialect.Function;
 using NHibernate.SqlCommand;
 
 namespace NHibernate.Dialect
@@ -2,27 +3,28 @@
 {
-    public class MsSqlCe40Dialect : MsSqlCeDialect
-    {
-        public override SqlString GetLimitString(SqlString querySqlString, int offset, int limit)
-        {
-            if (querySqlString.IndexOfCaseInsensitive(" ORDER BY ") < 0)
-                querySqlString = querySqlString.Append(" ORDER BY GETDATE()");
-            return querySqlString.Append(string.Format(" OFFSET {0} ROWS FETCH NEXT {1} ROWS ONLY", offset, limit));
-        }
+	public class MsSqlCe40Dialect : MsSqlCeDialect
+	{
+		public MsSqlCe40Dialect()
+		{
+			RegisterFunction("concat", new VarArgsSQLFunction(NHibernateUtil.String, "(", "+", ")"));
+		}
 
-        public override bool SupportsLimit
-        {
-            get
-            {
-                return true;
-            }
-        }
+		public override bool SupportsLimit
+		{
+			get { return true; }
+		}
 
-        public override bool SupportsLimitOffset
-        {
-            get
-            {
-                return true;
-            }
-        }
-    }
-}
+		public override bool SupportsLimitOffset
+		{
+			get { return true; }
+		}
+
+		public override SqlString GetLimitString(SqlString querySqlString, int offset, int limit)
+		{
+			if (querySqlString.IndexOfCaseInsensitive(" ORDER BY ") < 0)
+			{
+				querySqlString = querySqlString.Append(" ORDER BY GETDATE()");
+			}
+			return querySqlString.Append(string.Format(" OFFSET {0} ROWS FETCH NEXT {1} ROWS ONLY", offset, limit));
+		}
+	}
+}
\ No newline at end of file


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