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));
}
