public void ExecuteCommand(string sql, IEnumerable <object> parameters) { using (OleDbCommand command = new OleDbCommand(sql, _connection, _transaction)) { command.AddParameters(parameters); command.ExecuteNonQuery(); } }
public object ExecuteScalar(string sql, IEnumerable <object> parameters) { using (OleDbCommand command = new OleDbCommand(sql, _connection, _transaction)) { command.AddParameters(parameters); object result = command.ExecuteScalar(); return(result == DBNull.Value ? null : result); } }
public ISource ExecuteQuery(string sql, IEnumerable <object> parameters) { DataSet ds = new DataSet(); using (OleDbCommand command = new OleDbCommand(sql, _connection, _transaction)) { command.AddParameters(parameters); using (OleDbDataAdapter adapter = new OleDbDataAdapter(command)) { adapter.Fill(ds); } } return(new DataSetSource(ds)); }