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.
|
