By Ross L. Rooker, Sr. - 10/6/2011
I have a BaseBO and want to insert logic to dynamically handle Oracle. I have looked at the code generated for Oracle BO's and see the differences. Can anyone give me advice on this in terms of what methods in my base bo I would need to override? IE... FILL a table, Insert, Delete, Update and SAVE. I am on a project that has 350 BOs in SQL and inherit from a Base BO.
Below is some code I started playing around with in my base bo. Any guidance would be helpful.
public enum DatabaseType : int
{
SQLServer = 0,
Oracle = 1
}
private static DatabaseType _DatabaseQueryType = DatabaseType.SQLServer ;
public static DatabaseType DatabaseQueryType
{
get { return _DatabaseQueryType; }
set { _DatabaseQueryType = value; }
}
private OracleCommand ConvertSqlToOracleCommand(SqlCommand cmd)
{
System.Data.OracleClient.
OracleCommand strOr = null;
return strOr;
//-- Convert the SqlCommand into an Oracle Command
}
//-- Override the base FillDataTable and add a test to see if the command should be converted to Oracle
public override void FillDataTable(DbCommand cmd)
{
if (TrustedVALETBaseBO.DatabaseQueryType == DatabaseType.Oracle)
cmd = ConvertSqlToOracleCommand((
SqlCommand)cmd);
Console.WriteLine("Base class Constructor");
base.FillDataTable(cmd);
}
//private DbCommand MassageCommand(System.Data.Common.DbCommand Command)
//{
// //-- Get a reference to the command
// SqlCommand cmd = (SqlCommand)Command;
// //-- If this business object needs to talk to Oracle, then convert the command, else, just execute it
// if (this.ShouldNativeDbTypesBeConverted)
// {
// //-- Replace the char fields before converting the command
// ///// foreach (CharEnumField field in _CharFieldsToUpdate)
// {
// ///// field.ReplaceCharFieldWithEnumField(cmd);
// }
// return this.ConvertCommand(cmd);
// }
// else
// {
// return Command;
// }
//}
///// <summary>
///// Converts the specified SqlCommand object into an equivalent OleDbCommand object.
///// </summary>
//private OleDbCommand ConvertCommand(System.Data.SqlClient.SqlCommand Command)
//{
// //-- Establish locals
// OleDbCommand loReturn = new OleDbCommand();
// Match loMatch = default(Match);
// //-- Set the basic properties on the oledb command
// loReturn.CommandText = Command.CommandText;
// loReturn.CommandType = Command.CommandType;
// //-- Update the parameters for the command
// //-- Find all of the parameters within the text & replace them
// /////loMatch = _ParameterRegex.Match(Command.CommandText);
// /////loReturn.CommandText = _ParameterRegex.Replace(Command.CommandText, "?");
// //-- Replace the matches in the text and build the parameters for the command
// while (loMatch.Success)
// {
// //-- Add the new parameter to the collection
// /////loReturn.Parameters.Add(ConvertParameter(Command.Parameters(loMatch.Value)));
// //-- Go to the next match
// loMatch = loMatch.NextMatch();
// }
// //-- Return the new command
// return loReturn;
//}
|
|