How to perfrom batch deletes with ADO.Net
Hi,
I'm using code in the same way the following code sample to perform batch insert:
DataTable t = new DataTable();
t.Columns.Add("a", typeof(int));
t.Rows.Add(1);
t.Rows.Add(2);
// don't hardcode connection strings in your apps, this is just a quick sample :)
// pre-create the table with "CREATE TABLE t (a INT)"
using(OracleConnection conn = new OracleConnection("server=tcp:localhost; integrated security=true; database=test")) {
conn.Open();
OracleDataAdapter da = new OracleDataAdapter (null, conn);
da.InsertCommand = new OracleCommand("INSERT INTO t VALUES (@a)", conn);
da.InsertCommand.Parameters.Add("@a", SqlDbType.Int, 0, "a");
da.InsertCommand.UpdatedRowSource = UpdateRowSource.None;
da.UpdateBatchSize = 10;
da.Update(t);
}
t.Columns.Add("a", typeof(int));
t.Rows.Add(1);
t.Rows.Add(2);
// don't hardcode connection strings in your apps, this is just a quick sample :)
// pre-create the table with "CREATE TABLE t (a INT)"
using(OracleConnection conn = new OracleConnection("server=tcp:localhost; integrated security=true; database=test")) {
conn.Open();
OracleDataAdapter da = new OracleDataAdapter (null, conn);
da.InsertCommand = new OracleCommand("INSERT INTO t VALUES (@a)", conn);
da.InsertCommand.Parameters.Add("@a", SqlDbType.Int, 0, "a");
da.InsertCommand.UpdatedRowSource = UpdateRowSource.None;
da.UpdateBatchSize = 10;
da.Update(t);
}
How does I use batch ability of ADO.Net to perform batch deletes the same way I've performed batch inserts?
Thanks,
Michael.
[1817 byte] By [MichaelBachar] at [2007-12-23] 