in

System.Data.SQLite

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

Browse by Tags

  • Re: Some kind of disk I/O error occurred

    For those looking for a solution to this error, one solution that worked for me was raised in the forum thread here . Basically it involves using the PRAGMA statement to change the journal mode. I posted a coded example in c# at http://www.stevemcarthur.co.uk/blog/post/Some-kind-of-disk-IO-error-occurrede28093SQLite...
    Posted to Bugs (Forum) by SteveMc on 12-15-2010

  • Re: Some Kind of Disk I/O Error Occurred - NOT using Device Emulator!

    Setting the journal_mode through the PRAGMA statement worked for me as well. Have a look at the post here: http://www.stevemcarthur.co.uk/blog/post/Some-kind-of-disk-IO-error-occurrede28093SQLite.asp . Has some code using the SQLiteCommand object and a PRAGMA statement.
    Posted to Bugs (Forum) by SteveMc on 12-14-2010

  • Connection string properties

    Hello, Let's say I set page size and synchornous pragmas during creating a database from visual studio. Do I need to include them in my connection string every time I open it or is it per database setting? Thanks.
    Posted to General (Forum) by mcnamara on 05-12-2010

  • 1.0.66.0 - interop.c GC special-case code and FK PRAGMA

    Hi Robert, Thanks for the 1.0.66.0 drop -- you've got a pretty big fanbase! :) A couple questions about the latest release though: 1) Did you revisit the GC special-case logic in interop.c (see http://sqlite.phxsoftware.com/forums/t/1918.aspx )? I haven't tested your latest drop yet, but I know...
    Posted to General (Forum) by mbouck on 04-19-2010

  • Parameter for foreign key support in the connection string?

    Hi, I'm interested in turning on the foreign key support when connecting to the database. I know that it is "pragma foreign_keys = ON" but it doesn't work in the connection string... Moreover it doesn't work if I try to turn on later: cmd.CommandText = "PRAGMA foreign_keys...
    Posted to General (Forum) by tsomogyi on 01-15-2010

  • Database Connection Tuning

    I need help tuning the database connection parameters. I have 2 modes. Bulk Writing - 1 connection to the database (enforced by lockout and isolation). A new database is created and tons of data is bulk loaded into the file. Maximum performance is most important. Database corruption is not a big deal...
    Posted to General (Forum) by jeremyje on 02-23-2009

  • Parameterized query for PRAGMA command

    Is possible to use PRAGMA command in parameterized query? Something like: using (SQLiteCommand sqlcmd = new SQLiteCommand("PRAGMA user_version=@Version", sqliteConn)) { sqlcmd.Parameters.Add("@Version", System.Data.DbType.Int32); sqlcmd.Parameters["@Version"].Value = 100;...
    Posted to General (Forum) by BlackRose on 05-30-2008
Page 1 of 1 (7 items)
Powered by Community Server (Commercial Edition), by Telligent Systems