I have written a specialized class to wrap up
the enterprise library database functionality for easier usage.
The reasoning for using
the Enterprise Library is because my applications commonly connect to both oracle and sql server database systems. My wrapper handles both creating connection strings on
the fly, connecting, and executing queries allowing my main code to only have to write a few lines of code to do database stuff and deal with error handling. As an example my ExecuteNonQuery method has
the following declaration:
/// <summary>
/// Executes a query that
returns no results (e.g. insert or update statements)
/// </summary>
/// <param name="sqlQuery"></param>
/// <param name="parameters">Hashtable containing all
the parameters for
the query</param>
/// <returns>The total number of records modified, -1 if an error occurred </returns>
public int ExecuteNonQuery(string sqlQuery, Hashtable parameters)
{
// Make sure we are connected to
the database
if (!IsConnected)
{
ErrorHandler("Attempted to run a query without being connected to a database.", ErrorSeverity.Critical);
return -1;
}
// Form
the command
DbCommand dbCommand = _database.GetSqlStringCommand(sqlQuery);
// Add all
the paramters
foreach (string key in parameters.Keys)
{
if (parameters[key] == null)
_database.AddInParameter(dbCommand, key, DbType.Object, null);
else
_database.AddInParameter(dbCommand, key, DbType.Object, parameters[key].ToString());
}
return _database.ExecuteNonQuery(dbCommand);
}
_database is defined as private Database _database;.
Hashtable parameters are created via code similar to p.Add("@param", value);.
the issue I am having is that it seems that with enterprise library database framework you must declare
the dbType of each parameter. This isn't an issue when you are calling
the database code directly when forming
the paramters but doesn't work for creating a generic abstraction class such as I have. In order to try and get around that I thought I could just use DbType.Object and figure
the DB will figure it out based on
the columns
the sql is working with. Unfortunately, this is not
the case as I get
the following error:
Implicit conversion from data type sql_variant to varchar is not allowed. Use
the CONVERT function to run this query
Is there any way to use generic parameters in a wrapper class or am I just going to have to move all my DB code into my main classes?
