I didn't quite follow your question; but it's not
necessary for an ADO.NET method to fail in order to use Rollback, any
method/code can fail to use Rollback (it doesn't even need to be an
exception...).
Your syntax just needs to be changed to use the SqlTransaction class:
SqlTransaction trans = db.BeginTransaction();
try
{
comm.execute();
StartC#Proc();
trans.Commit();
}
catch Exception
{
trans.Rollback();
}
===================================
This list is hosted by DevelopMentor® http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
