[Adapdev-commits] Adapdev/src/Adapdev.Data/Sql ISelectQuery.cs,1.2,1.3 QueryHelper.cs,1.5,1.6 SelectQuery.cs,1.3,1.4

[Sean M. <int...@us...>]

Update of /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv27500/src/Adapdev.Data/Sql

Modified Files:
	ISelectQuery.cs QueryHelper.cs SelectQuery.cs 
Log Message:
Several bug fixes for AbstractDAO
Added unit tests for NUnit support

Index: SelectQuery.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/SelectQuery.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** SelectQuery.cs	21 Jul 2005 23:29:21 -0000	1.3
--- SelectQuery.cs	21 Oct 2005 04:59:20 -0000	1.4
***************
*** 103,106 ****
--- 103,119 ----
  		}
  
+ 		public void AddOrderBy(string tableName, string columnName)
+ 		{
+ 			order.Enqueue(QueryHelper.GetPreDelimeter(this.type) + tableName + QueryHelper.GetPostDelimeter(this.type) + "." + QueryHelper.GetPreDelimeter(this.type) + columnName + QueryHelper.GetPostDelimeter(this.type));
+ 		}
+ 
+ 		public void AddOrderBy(string tableName, params string[] columns)
+ 		{
+ 			foreach (string s in columns)
+ 			{
+ 				this.AddOrderBy(tableName, s);
+ 			}
+ 		}
+ 
  		public void AddOrderBy(params string[] columns)
  		{

Index: QueryHelper.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/QueryHelper.cs,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** QueryHelper.cs	25 Jul 2005 02:22:15 -0000	1.5
--- QueryHelper.cs	21 Oct 2005 04:59:20 -0000	1.6
***************
*** 161,164 ****
--- 161,169 ----
  		}
  
+ 		public static string GetSqlServerLastInsertedScopeCommand()
+ 		{
+ 			return "SELECT SCOPE_IDENTITY();";
+ 		}
+ 
  		public static string GetAccessLastInsertedCommand(string table, string column)
  		{

Index: ISelectQuery.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/ISelectQuery.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** ISelectQuery.cs	25 May 2005 05:17:47 -0000	1.2
--- ISelectQuery.cs	21 Oct 2005 04:59:20 -0000	1.3
***************
*** 50,53 ****
--- 50,59 ----
  		void AddOrderBy(string columnName);
  		/// <summary>
+ 		/// Adds a ORDER BY [table].[column] statement in the datastore specific format
+ 		/// </summary>
+ 		/// <param name="tableName"></param>
+ 		/// <param name="columnName"></param>
+ 		void AddOrderBy(string tableName, string columnName);
+ 		/// <summary>
  		/// Adds a ORDER BY [column1], [column2]... statement in the datastore specific format
  		/// </summary>