in

System.Data.SQLite

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

Browse by Tags

  • Re: Writing parameterized queries

    [quote user="Robert Simpson"]You, like so many before you (and many to come after!) have forgotten the cardinal rule of SQLite ... TRANSACTIONS![/quote] Yes, when I first wrote my program that inserts data from an MS SQLServer DB to an SQLite DB, I knew about transactions but didn't understand...
    Posted to How To (Forum) by Roan on 09-14-2010

  • c# database file is locked error

    Hi there! i am using sqlite the latest version and i am using the latest version of the ado.net connector. I have created a database with sqlite admin and saved the file in the debug folder of my application. I code in c#. I have a login page that works perfectly, it opens a connection runs a WHERE clause...
    Posted to Bugs (Forum) by casserlyprogramming on 05-21-2010

  • 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
Page 1 of 1 (3 items)
Powered by Community Server (Commercial Edition), by Telligent Systems