I was wondering if someone could clarify this for me. If I have the following code (simplified for brevity) :
using (OracleConnection conn = new OracleConnection() )
using (OracleTransaction trans = conn.BeginTransaction() )
// Some working code...
If an exception occurs and commit is never called are all changes absolutely discarded when the transaction is disposed or is the database left in some wierd state?
Thanks in advance!