> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, July 16, 2007 9:14 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Does Transaction object roll back > automatically on exceptions? > > "Ahmed Sulaiman" <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > I have tried this question in the forum with no answer, so > I decide to > > give it a try here :) > > > > I am using the "Using" statements in C# to handle the > closing of SQLite > > connection, transaction and command objects. I have this setup in > > different places in my code (Generic methods returning > SQLite objects) > > > > using (IDbConnection conn = CreateConnection()) > > { > > conn.Open(); > > using (IDbTransaction transaction = conn.BeginTransaction()) > > { > > Dosomething(); > > transaction.Commit(); > > } > > } > > > > My question, what happens if there was an exception inside the > > transaction using block? I know that the transaction object would be > > closed and disposed, but does the traction roll back > automatically by > > the SQLite engine, or do I need to have special logic for > that? What is > > the suggested best practices in this case? > > > > In the equivalent code in TCL, the transaction would > rollback automatically. But I do not know anything > about the C# bindings that you are using, so I do not > know what will happen in your case. Have you tried it > to see? What does the documentation that comes with > your SQLite C# bindings say? It is the C# bindings, > not the SQLite core, that will determine this behavior.
Answered on the SQLite.NET forums. The ADO.NET wrapper automatically roll back as well. Robert ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
