/// <summary>
/// Performs a query on this database connection with mysql parameterisation.
/// </summary>
/// <returns>A DBResults instances that contains the results of this query, or null if the query failed.</returns>
public DBResults QueryParameterized(string query, object[] parameters, params object[] formatParam)
{
query = String.Format(query, formatParam);
try
{
MySqlCommand currentCommand = new MySqlCommand(query, m_connection);
int index = 1;
foreach (object param in parameters)
{
currentCommand.Parameters.Add("@parameter_" + index, param);
index++;
}
MySqlDataReader currentCommandDataReader = currentCommand.ExecuteReader() as MySqlDataReader;
DBResults results = new DBResults(currentCommand, currentCommandDataReader);
currentCommandDataReader.Close();
return results;
}
catch (System.Data.Common.DbException ex)
{
Logger.Error("Database query failed with error: {0}", LoggerVerboseLevel.Normal, ex.Message);
return null;
}
}
/// <summary>
/// Performs a query on this database connection.
/// </summary>
/// <returns>A DBResults instances that contains the results of this query, or null if the query failed.</returns>
public DBResults Query(string query, params object[] formatParam)
{
query = String.Format(query, formatParam);
try
{
MySqlCommand currentCommand = new MySqlCommand(query, m_connection);
MySqlDataReader currentCommandDataReader = currentCommand.ExecuteReader() as MySqlDataReader;
DBResults results = new DBResults(currentCommand, currentCommandDataReader);
currentCommandDataReader.Close();
return results;
}
catch (System.Data.Common.DbException ex)
{
Logger.Error("Database query failed with error: {0}", LoggerVerboseLevel.Normal, ex.Message);
return null;
}
}