public static DataTable ExecuteQuery(this BaseDatabase database, string query, params IDbDataParameter[] parameters) { DataTable dataTable = new DataTable(); using (IDbConnection connection = database.CreateConnection()) { using (IDbCommand command = database.CreateCommand(query)) { command.Connection = connection; connection.Open(); foreach (IDbDataParameter param in parameters) { command.Parameters.Add(param); } using (IDataReader dataReader = command.ExecuteReader()) { dataTable.Load(dataReader); } } } return(dataTable); }
public static int ExecuteNonQuery(this BaseDatabase database, string query) { int rowsAffected = -1; using (IDbConnection connection = database.CreateConnection()) { using (IDbCommand command = database.CreateCommand(query)) { command.Connection = connection; connection.Open(); rowsAffected = command.ExecuteNonQuery(); } } return(rowsAffected); }
public static object ExecuteScalar(this BaseDatabase database, string query, params IDbDataParameter[] parameters) { object result = null; using (IDbConnection connection = database.CreateConnection()) { using (IDbCommand command = database.CreateCommand(query)) { command.Connection = connection; connection.Open(); foreach (IDbDataParameter param in parameters) { command.Parameters.Add(param); } result = command.ExecuteScalar(); } } return(result); }
public static int ExecuteNonQuery(this BaseDatabase database, string query, params IDbDataParameter[] parameters) { int rowsAffected = -1; using (IDbConnection connection = database.CreateConnection()) { using (IDbCommand command = database.CreateCommand(query)) { command.Connection = connection; connection.Open(); foreach (IDbDataParameter param in parameters) { command.Parameters.Add(param); } rowsAffected = command.ExecuteNonQuery(); } } return(rowsAffected); }