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

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

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

Modified Files:
	ISelectQuery.cs SelectQuery.cs 
Log Message:
Added support for mutli-threaded tests (still buggy) and transactional tests
Added new ISelectQuery.AddJoin method allowing for the joining of four tables
Fixed bug w/ DatabaseSchema persistence

Index: SelectQuery.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/SelectQuery.cs,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** SelectQuery.cs	21 Oct 2005 04:59:20 -0000	1.4
--- SelectQuery.cs	11 Nov 2005 04:52:46 -0000	1.5
***************
*** 147,150 ****
--- 147,169 ----
  		}
  
+ 		public virtual void AddJoin(string secondTable, string firstTableColumn, string secondTableColumn, string thirdTable, string thirdTableColumn, string fourthTable, string fourthTableColumn, JoinType type)
+ 		{
+ 			this._join = String.Format(" {0} {1} ON {2}.{3} = {4}.{5} {6} {7} ON {8}.{9} = {10}.{11} ",	
+ 																			this.GetJoinType(type), 
+ 																			QueryHelper.GetPreDelimeter(this.type) + secondTable + QueryHelper.GetPostDelimeter(this.type), 
+ 																			this._table, 
+ 																			QueryHelper.GetPreDelimeter(this.type) + firstTableColumn + QueryHelper.GetPostDelimeter(this.type),
+ 																			QueryHelper.GetPreDelimeter(this.type) + secondTable + QueryHelper.GetPostDelimeter(this.type),
+ 																			QueryHelper.GetPreDelimeter(this.type) + secondTableColumn + QueryHelper.GetPostDelimeter(this.type),
+ 																			this.GetJoinType(type),
+ 																			QueryHelper.GetPreDelimeter(this.type) + fourthTable + QueryHelper.GetPostDelimeter(this.type),
+ 																			QueryHelper.GetPreDelimeter(this.type) + thirdTable + QueryHelper.GetPostDelimeter(this.type),
+ 																			QueryHelper.GetPreDelimeter(this.type) + thirdTableColumn + QueryHelper.GetPostDelimeter(this.type),
+ 																			QueryHelper.GetPreDelimeter(this.type) + fourthTable + QueryHelper.GetPostDelimeter(this.type),
+ 																			QueryHelper.GetPreDelimeter(this.type) + fourthTableColumn + QueryHelper.GetPostDelimeter(this.type));
+ 
+ 		}
+ 
+ 
  		public void SetTable(string tableName)
  		{

Index: ISelectQuery.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/ISelectQuery.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** ISelectQuery.cs	21 Oct 2005 04:59:20 -0000	1.3
--- ISelectQuery.cs	11 Nov 2005 04:52:46 -0000	1.4
***************
*** 78,81 ****
--- 78,83 ----
  		/// <param name="type">The join type</param>
  		void AddJoin(string secondTable, string firstTableColumn, string secondTableColumn, JoinType type);
+ 
+ 		void AddJoin(string secondTable, string firstTableColumn, string secondTableColumn, string thirdTable, string thirdTableColumn, string fourthTable, string fourtTableColumn, JoinType joinType);
  		/// <summary>
  		/// Set's the maximum number of records to retrieve