[Nhibernate-commit] nhibernate/src/NHibernate/Dialect Dialect.cs,1.39,1.40 Oracle9Dialect.cs,1.13,1.14 PostgreSQLDialect.cs,1.7,1.8

[Michael D. <mik...@us...>]

Update of /cvsroot/nhibernate/nhibernate/src/NHibernate/Dialect
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16491/Dialect

Modified Files:
	Dialect.cs Oracle9Dialect.cs PostgreSQLDialect.cs 
Log Message:
Removed GetLimitString(string) in favor of GetLimitString(SqlString)

Index: PostgreSQLDialect.cs
===================================================================
RCS file: /cvsroot/nhibernate/nhibernate/src/NHibernate/Dialect/PostgreSQLDialect.cs,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** PostgreSQLDialect.cs	19 Sep 2004 15:32:34 -0000	1.7
--- PostgreSQLDialect.cs	19 Sep 2004 16:54:43 -0000	1.8
***************
*** 83,91 ****
  		}
  
- 		public override string GetLimitString(String querySelect)
- 		{
- 			return querySelect + " limit ? offset ? ";
- 		}
- 		
  		public override SqlString GetLimitString(SqlString querySqlString)
  		{
--- 83,86 ----

Index: Oracle9Dialect.cs
===================================================================
RCS file: /cvsroot/nhibernate/nhibernate/src/NHibernate/Dialect/Oracle9Dialect.cs,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** Oracle9Dialect.cs	1 Sep 2004 00:17:08 -0000	1.13
--- Oracle9Dialect.cs	19 Sep 2004 16:54:43 -0000	1.14
***************
*** 125,137 ****
  		}
  
- 		public override string GetLimitString(String querySelect)
- 		{
- 			StringBuilder pagingSelect = new StringBuilder(100);
- 			pagingSelect.Append("select * from ( select row_.*, rownum rownum_ from ( ");
- 			pagingSelect.Append(querySelect);
- 			pagingSelect.Append(" ) row_ where rownum <= ?) where rownum_ > ?");
- 			return pagingSelect.ToString();
- 		}
- 
  		public override SqlString GetLimitString(SqlString querySqlString)
  		{
--- 125,128 ----

Index: Dialect.cs
===================================================================
RCS file: /cvsroot/nhibernate/nhibernate/src/NHibernate/Dialect/Dialect.cs,v
retrieving revision 1.39
retrieving revision 1.40
diff -C2 -d -r1.39 -r1.40
*** Dialect.cs	13 Sep 2004 07:31:34 -0000	1.39
--- Dialect.cs	19 Sep 2004 16:54:42 -0000	1.40
***************
*** 412,428 ****
  
  		/// <summary>
- 		/// Add a <c>LIMIT</c> clause to the given SQL <c>SELECT</c> 
- 		/// </summary>
- 		/// <param name="querySelect"></param>
- 		/// <returns>The modified SQL</returns>
- 		[Obsolete("Use the GetLimitString(SqlString) overload instead.")]
- 		public virtual string GetLimitString(String querySelect) 
- 		{
- 			//TODO: H2.0.3 - this might need to the a SqlString or an IDbCommand depending
- 			// on when it comes in.  Need to look at Loader to know for sure...
- 			throw new NotSupportedException("Paged Queries not supported");
- 		}
- 
- 		/// <summary>
  		/// Add a <c>LIMIT</c> clause to the given SQL <c>SELECT</c>
  		/// </summary>
--- 412,415 ----