Browse by Tags

multiple commands in a transaction - is this code robust & the simplest way to do this?

Hi, Re handling multiple commands in a transaction - is this code robust & the simplest way to do this? private int ExecuteNonQueryTransactionally(List<string> sqlList) { int totalRowsUpdated = 0; using (var conn = new SQLiteConnection(_connectionString)) { conn.Open(); using (var trans = conn...

Posted to General (Forum) by callagga on 03-17-2010
TransactionScope & BeginTransaction behaviour

While trying to figure out why my SubSonic transactions were behaving strangely, I wrote some "tests" using raw ADO.NET and TransactionScope. I found that in one case the transaction is not rolled back like I would expect it to, and in another one an exception occurs. Here are four simple examples...

Posted to General (Forum) by romkyns on 10-14-2009
Get "cannot rollback - no transaction active" when trying to use a context on which there was a failure

Hi, First off: Thanks for doing this and making it available for free. I appreciate it. I get a failure when I try to execute context.SaveChanges() (using Entity Framework) A little bit of background: I create a database connect to it via entity framework and sqlite ado.net provider. I cause a failure...

Posted to Entity Framework (Forum) by pwab on 06-25-2009
Disk I/O error on transaction commit

Hello, I'm probably missing something very simple here, but this is my problem: I'm trying to get the bulk insert sample programs to run inside of a local ASP.NET page. I ran the given SQL command to create the TestCase table (after running "sqlite3 test.db"). The database file is in...

Posted to Bugs (Forum) by robg37 on 05-01-2009

Page 1 of 1 (4 items)

System.Data.SQLite

Browse by Tags

multiple commands in a transaction - is this code robust & the simplest way to do this?

TransactionScope & BeginTransaction behaviour

Get "cannot rollback - no transaction active" when trying to use a context on which there was a failure

Disk I/O error on transaction commit