Connection strings Examples for SQLite

SQLite.NET

This is a .NET class library from SQLite.

Download SQLite from SQLite website

Standard:

    
Using UTF16:


With password:

   
Using the pre 3.3x database format:


With connection pooling:

   
    Note: The default setting does not have connection pooling so you must set it with the parameter Max Pool Size.

Read only connection:


Using DateTime.Ticks as datetime format:


    Note: ISO8601 is the default value for datetime format.

Store GUID as text:


    Note: By default GUID is store in binary format, if using text as a format then it will consume more space.

Specify cache size:


Specify page size:


    Note: The page size is measure in bytes.

Disable enlistment in distributed transactions:


    Automatically redirect connection to the mirrored database if the current one failed.

Disable enlistment in distributed transactions:


Disable create database behaviour:


Limit the size of database:


Disable the Journal File:


Persist the Journal File:


Controling file flushing:





Finisar.SQLite ADO.NET Data Provider

This is a .NET wrapper class library from Finisar.SQLite.

Standard:


    Note: The version keyword indicate which version to use. the value 2 is for SQLite 2.x and value 3 is for SQLite 3.x.

Create a new database:


Using compression:


Specifying Cache Size:


    Note: The higher the cache size value the more data pages is kept in memory, this will allow speed improvement with data processing.




SQLite3 ODBC Driver

This is a  OLE DB Provider from Microsoft. Its usage is Provider=SQLNCLI10.

Standard Security:

 



.NET Framework Data Provider for ODBC

This is a .NET class library from Microsoft. The usage for this class library is System.Data.Odbc.OdbcConnection.

Standard :