SQLite connection strings

標籤：

• • • BasicData 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 UTF16Data Source=c:\mydb.db;Version=3;UseUTF16Encoding=True;

    SQLite

  • With passwordData Source=c:\mydb.db;Version=3;Password=myPassword;

    SQLite

  • Using the pre 3.3x database formatData 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 connectionData Source=c:\mydb.db;Version=3;Read Only=True;

    SQLite

  • Using DateTime.Ticks as datetime formatData 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 sizeData Source=c:\mydb.db;Version=3;Cache Size=2000;

    The Cache Size value measured in bytes

    SQLite

  • Specify page sizeData Source=c:\mydb.db;Version=3;Page Size=1024;

    The Page Size value measured in bytes

    SQLite

  • Disable enlistment in distributed transactionsData 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 databaseData 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 flushingData 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

  ? Problems connecting?   Get answer in the SQLite Q & A forum →

• Finisar.SQLite ADO.NET Data Provider
  • StandardData Source=c:\mydb.db;Version=3;

    The "Version" key can take value "2" for SQLite 2.x (default) or value "3" for SQLite 3.x

    SQLite

  • SQLite Version 2.XData Source=c:\mydb.db;Version=2;

    SQLite

  • Create a new databaseData Source=c:\mydb.db;Version=3;New=True;

    SQLite

  • Using compressionData Source=c:\mydb.db;Version=3;Compress=True;

    SQLite

  • Specifying Cache Size

    The Cache Size value represents the amount of data pages that are held in memory. Try increase this value for speed improvements but don‘t forget to keep track of the applications memory usage.

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

    SQLite

  • UTF 8Data Source=c:\mydb.db;Version=3;UTF8Encoding=True;

    SQLite

  • UTF 16Data Source=c:\mydb.db;Version=3;UTF16Encoding=True;

SQLite connection strings