in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine
All Tags » TransactionScope (RSS)

Browse by Tags

  • TransactionScope does cause database locked exception when invoking SaveChanges more than once

    I use a TransactionScope to ensure a transaction. If I invoke ObjectContext.SaveChanges more than once within the transaction, I get an exception that reports that the database file is locked. Here is a sample: using (AdventureWorksLTEntities objectContext = new AdventureWorksLTEntities(connectionString...
    Posted to Entity Framework (Forum) by jb42 on 02-04-2010

  • Problems with TransactionScope

    I came across this post on making bulk inserts more performant: http://sqlite.phxsoftware.com/forums/t/134.aspx I've tried to follow the parameterized insert example using TransactionScope instead of IDbTransaction. The basic structure I am using is: using (TransactionScope transaction = new TransactionScope...
    Posted to General (Forum) by Mont Rothstein on 11-18-2009

  • 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

  • Re: NullReferenceException with EF and TransactionScope

    Was this problem ever fixed? I am having what appears to be the same issue, and looking at the code the change Andrew suggested doesn't seem to have been applied in the current 1.0.63 version. I tried making the change myself but I can't seem to get it to build properly for some reason (the version...
    Posted to Bugs (Forum) by contextfree on 07-09-2009

  • MbUnit3's TransactionScope creating issues for NHibernate using System.Data.SQLite

    I'll apologize in advance for duplicating a reference off-site here but I posted a question on StackOverflow because I am having difficulty using NHibernate with the System.Data.SQLite provider and MbUnit's [Rollback] test attribute (which really just uses TransactionScope.) http://stackoverflow...
    Posted to Bugs (Forum) by antik on 03-27-2009

  • Re: NullReferenceException with EF and TransactionScope

    Not to bump my own post AGAIN but I was forced to make yet another change, this time to support nested TransactionScopes and would like Robert to comment on the side effects of my changes (i have noticed none). The situation I was in was UnitTesting. I was testting my insert / retrive cycle of my objects...
    Posted to Bugs (Forum) by AndrewBurns on 01-11-2009

  • NullReferenceException with EF and TransactionScope

    My setup: I am using the entity framework as my DAL to SQLite v1.0.60.0. I will create a new EF context at my root operation (Say Invoice insert) use it then pass it to my child operations (line items). I want to protect all this in a transaction for obvious reasons. If I manage transactions manually...
    Posted to Bugs (Forum) by AndrewBurns on 01-07-2009
Page 1 of 1 (7 items)
Powered by Community Server (Commercial Edition), by Telligent Systems