private static void ExecuteNonQuery(string sql, string connectionString, DataBaseConnectionType connectionType)
{
connectionString = ConnectionString.FindConnectionString(connectionString);
if (connectionType == DataBaseConnectionType.Auto ||
connectionType == DataBaseConnectionType.Unknown)
{
connectionType = ConnectionType.FindConnectionType(connectionString);
}
if (connectionType == DataBaseConnectionType.Unknown)
{
throw new ApplicationException(
"Unable to automatically determine type of database from connection string. (ExecuteNonQuery)");
}
switch (connectionType)
{
case DataBaseConnectionType.SqlConnection:
SqlConnectionQuery.ExecuteNonQuery(sql, connectionString);
break;
case DataBaseConnectionType.OleDB:
OleDBQuery.ExecuteNonQuery(sql, connectionString);
break;
default:
throw new ApplicationException("Unknown connection type.");
}
}
private static object ExecuteScalar(string sql, string connectionString, DataBaseConnectionType connectionType)
{
connectionString = ConnectionString.FindConnectionString(connectionString);
if (connectionType == DataBaseConnectionType.Auto || connectionType == DataBaseConnectionType.Unknown)
{
connectionType = ConnectionType.FindConnectionType(connectionString);
}
if (connectionType == DataBaseConnectionType.Unknown)
{
throw new GridException(
"Unable to automatically determine type of database from connection string (ExecuteScalar)" + connectionString);
}
switch (connectionType)
{
case DataBaseConnectionType.SqlConnection:
return(SqlConnectionQuery.ExecuteScalar(sql, connectionString));
case DataBaseConnectionType.OleDB:
return(OleDBQuery.ExecuteScalar(sql, connectionString));
default:
throw new GridException("Unknown connection type.");
}
}
/// <summary>
/// Executes a Transact-SQL statement and returns a WebGrid.Util.Query object.
/// </summary>
/// <param name="sql">The SQL statement</param>
/// <param name="connectionString">The connection string.</param>
/// <param name="connectionType">Type of the connection.</param>
/// <returns>
/// WebGrid.Util.Query object containing the results from the executed SQL statement
/// </returns>
internal static Query ExecuteReader(string sql, string connectionString, DataBaseConnectionType connectionType)
{
connectionString = ConnectionString.FindConnectionString(connectionString);
if (connectionType == DataBaseConnectionType.Auto ||
connectionType == DataBaseConnectionType.Unknown)
{
connectionType = ConnectionType.FindConnectionType(connectionString);
}
if (connectionType == DataBaseConnectionType.Unknown)
{
throw new ApplicationException(
string.Format("Unable to automatically determine type of database from connection string. (ExecuteReader) ConnectionString: {0}", connectionString));
}
switch (connectionType)
{
case DataBaseConnectionType.SqlConnection:
return(SqlConnectionQuery.ExecuteReader(sql, connectionString));
case DataBaseConnectionType.OleDB:
return(OleDBQuery.ExecuteReader(sql, connectionString));
// case DataBaseConnectionTypes.MySql:
// return MySqlQuery.ExecuteReader(sql, connectionString);
default:
throw new ApplicationException("Unknown connection type.");
}
}