[Adapdev-commits] Adapdev/src/Adapdev.Data/Sql CriteriaFactory.cs,1.1.1.1,1.2 DialectConstants.cs,1.1.1.1,1.2 QueryFactory.cs,1.1.1.1,1.2 QueryHelper.cs,1.1.1.1,1.2

[Trevor L. <tre...@us...>]

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

Modified Files:
	CriteriaFactory.cs DialectConstants.cs QueryFactory.cs 
	QueryHelper.cs 
Log Message:
1. Modifications to support the ProviderConfig file for Database/Provider dynamic customisation
2. Added support classes for Oracle 
3. Enhanced UI to support dynamic ProviderConfig

Index: QueryFactory.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/QueryFactory.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** QueryFactory.cs	28 Feb 2005 01:31:48 -0000	1.1.1.1
--- QueryFactory.cs	10 Apr 2005 09:59:21 -0000	1.2
***************
*** 32,35 ****
--- 32,37 ----
  				case DbType.SQLSERVER:
  					return new SqlUpdateQuery();
+ 				case DbType.ORACLE:
+ 					return new OracleUpdateQuery();
  				default:
  					throw new System.NotImplementedException("DbType " + db + " not supported currently.");
***************
*** 57,60 ****
--- 59,64 ----
  				case DbType.SQLSERVER:
  					return new SqlSelectQuery();
+ 				case DbType.ORACLE:
+ 					return new OracleSelectQuery();
  				default:
  					throw new System.NotImplementedException("DbType " + db + " not supported currently.");			
***************
*** 89,92 ****
--- 93,98 ----
  				case DbType.SQLSERVER:
  					return new SqlDeleteQuery();
+ 				case DbType.ORACLE:
+ 					return new OracleDeleteQuery();
  				default:
  					throw new System.NotImplementedException("DbType " + db + " not supported currently.");
***************
*** 121,124 ****
--- 127,132 ----
  				case DbType.SQLSERVER:
  					return new SqlInsertQuery();
+ 				case DbType.ORACLE:
+ 					return new OracleInsertQuery();
  				default:
  					throw new System.NotImplementedException("DbType " + db + " not supported currently.");

Index: QueryHelper.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/QueryHelper.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** QueryHelper.cs	28 Feb 2005 01:31:48 -0000	1.1.1.1
--- QueryHelper.cs	10 Apr 2005 09:59:21 -0000	1.2
***************
*** 55,58 ****
--- 55,60 ----
  				case Adapdev.Data.DbType.SQLSERVER:
  					return DialectConstants.SQLSERVER_DATE;
+ 				case Adapdev.Data.DbType.ORACLE:
+ 					return DialectConstants.ORACLE_DATE;
  				default:
  					throw new Exception("DbType " + type + " not supported currently.");
***************
*** 73,76 ****
--- 75,80 ----
  				case Adapdev.Data.DbType.SQLSERVER:
  					return DialectConstants.SQLSERVER_PREDELIM;
+ 				case Adapdev.Data.DbType.ORACLE:
+ 					return DialectConstants.ORACLE_PREDELIM;
  				default:
  					throw new Exception("DbType " + type + " not supported currently.");
***************
*** 91,94 ****
--- 95,100 ----
  				case Adapdev.Data.DbType.SQLSERVER:
  					return DialectConstants.SQLSERVER_POSTDELIM;
+ 				case Adapdev.Data.DbType.ORACLE:
+ 					return DialectConstants.ORACLE_POSTDELIM;
  				default:
  					throw new Exception("DbType " + type + " not supported currently.");
***************
*** 109,112 ****
--- 115,120 ----
  				case Adapdev.Data.DbType.SQLSERVER:
  					return DialectConstants.SQLSERVER_STRING;
+ 				case Adapdev.Data.DbType.ORACLE:
+ 					return DialectConstants.ORACLE_STRING;
  				default:
  					throw new Exception("DbType " + type + " not supported currently.");
***************
*** 127,130 ****
--- 135,141 ----
  					columnName = StringUtil.RemoveSpaces(columnName);
  					return "@" + columnName;
+ 				case DbProviderType.ORACLE:
+ 					columnName = StringUtil.RemoveSpaces(columnName);
+ 					return columnName;
  				case DbProviderType.OLEDB:
  					return "?";

Index: DialectConstants.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/DialectConstants.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** DialectConstants.cs	28 Feb 2005 01:31:48 -0000	1.1.1.1
--- DialectConstants.cs	10 Apr 2005 09:59:21 -0000	1.2
***************
*** 15,18 ****
--- 15,23 ----
  		public const char SQLSERVER_DATE = '\'';
  		public const char SQLSERVER_STRING = '\'';
+ 
+ 		public const char ORACLE_PREDELIM = ' ';
+ 		public const char ORACLE_POSTDELIM = ' ';
+ 		public const char ORACLE_DATE = '\'';
+ 		public const char ORACLE_STRING = '\'';
  	}
  }
\ No newline at end of file

Index: CriteriaFactory.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/CriteriaFactory.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** CriteriaFactory.cs	28 Feb 2005 01:31:48 -0000	1.1.1.1
--- CriteriaFactory.cs	10 Apr 2005 09:59:21 -0000	1.2
***************
*** 16,19 ****
--- 16,21 ----
  				case DbType.SQLSERVER:
  					return new SqlServerCriteria();
+ 				case DbType.ORACLE:
+ 					return new OracleCriteria();
  				default:
  					throw new Exception("DbType " + type + " not supported currently.");