• SQLite

    • Basic

      Data Source=c:\mydb.db;Version=3;

      Version 2 is not supported by this class library.

      SQLite
    • In-Memory Database

      An SQLite database is normally stored on disk but the database can also be stored in memory. Read more about SQLite in-memory databases here.

      Data Source=:memory:;Version=3;New=True;
      SQLite
    • Using UTF16

      Data Source=c:\mydb.db;Version=3;UseUTF16Encoding=True;
      SQLite
    • With password

      Data Source=c:\mydb.db;Version=3;Password=myPassword;
      SQLite
    • Using the pre 3.3x database format

      Data Source=c:\mydb.db;Version=3;Legacy Format=True;
      SQLite
    • With connection pooling

      Connection pooling is not enabled by default. Use the following parameters to control the connection pooling mechanism.

      Data Source=c:\mydb.db;Version=3;Pooling=True;Max Pool Size=100;
      SQLite
    • Read only connection

      Data Source=c:\mydb.db;Version=3;Read Only=True;
      SQLite
    • Using DateTime.Ticks as datetime format

      Data Source=c:\mydb.db;Version=3;DateTimeFormat=Ticks;

      The default value is ISO8601 which activates the use of the ISO8601 datetime format

      SQLite
    • Store GUID as text

      Normally, GUIDs are stored in a binary format. Use this connection string to store GUIDs as text.

      Data Source=c:\mydb.db;Version=3;BinaryGUID=False;

      Note that storing GUIDs as text uses more space in the database.

      SQLite
    • Specify cache size

      Data Source=c:\mydb.db;Version=3;Cache Size=2000;

      The Cache Size value measured in bytes

      SQLite
    • Specify page size

      Data Source=c:\mydb.db;Version=3;Page Size=1024;

      The Page Size value measured in bytes

      SQLite
    • Disable enlistment in distributed transactions

      Data Source=c:\mydb.db;Version=3;Enlist=N;
      SQLite
    • Disable create database behaviour

      If the database file doesn't exist, the default behaviour is to create a new file. Use the following parameter to raise an error instead of creating a new database file.

      Data Source=c:\mydb.db;Version=3;FailIfMissing=True;
      SQLite
    • Limit the size of database

      Data Source=c:\mydb.db;Version=3;Max Page Count=5000;

      The Max Page Count is measured in pages. This parameter limits the maximum number of pages of the database.

      SQLite
    • Disable the Journal File

      This one disables the rollback journal entirely.

      Data Source=c:\mydb.db;Version=3;Journal Mode=Off;
      SQLite
    • Persist the Journal File

      This one blanks and leaves the journal file on disk after a commit. Default behaviour is to delete the Journal File after each commit.

      Data Source=c:\mydb.db;Version=3;Journal Mode=Persist;
      SQLite
    • Controling file flushing

      Data Source=c:\mydb.db;Version=3;Synchronous=Full;

      Full specifies a full flush to take action after each write. Normal is the default value. Off means that the underlying OS flushes I/O's.

      SQLite

Articlesread all

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.