Hi,
I need some Advice..
What is the best practice to execute multiple "nonQuery" SQL operations in
a transaction ?
1) Execute all in one "sqlCommand.ExecuteNonQuery();" :
sqlCommand.CommandText =
"DELETE CUSTOMER WHERE CUST_ID = 'ID1' \n" +
"DELETE ORDER WHERE CUST_ID = 'ID1' ";
sqlCommand.ExecuteNonQuery();
transaction.Commit();
2) Or Execute each operation independently ? :
sqlCommand.CommandText =
"DELETE CUSTOMER WHERE CUST_ID = 'ID1'";
sqlCommand.ExecuteNonQuery();
sqlCommand.CommandText =
"DELETE ORDER WHERE CUST_ID = 'ID1' "
sqlCommand.ExecuteNonQuery();
transaction.Commit();
Thanks for advices and comments !
Steph.