in

System.Data.SQLite

An open-source, enhanced version of the SQLite database engine for Windows
System.Data.SQLite » ADO.NET 2.0 Provider » How To » Connection String

Connection String

Last post 10-27-2007 7:17 AM by am65. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 10-26-2007 6:27 PM

    • am65
    • Top 500 Contributor
    • Joined on 10-26-2007
    • Posts 3

    Connection String

    Reply Contact

    How do you build a connection string? I have seen some examples like this:

    Data Source=C:\\folder\\file.db;Version=3;New=False;Compress=True

    But I don't know what this parameters mean or if there are more parameters that could be used.

    Thanks,

     am65
    Filed under:

  • 10-27-2007 2:11 AM In reply to

    • Wiaz
    • Top 10 Contributor
    • Joined on 01-11-2007
    • Poland
    • Posts 47

    Re: Connection String

    Reply Contact

    If you have system.data.sqlite installed then you have propably help file. Just look into it at proeperty connectionstring in conecction class. Here yoa have copy-paste from help:

    Parameter

    		 Values Required Default
    Version 3 N 3

    Data Source

    		 {filename} Y
    Version 3 N 3
    UseUTF16Encoding True
    False    		 N False
    DateTimeFormat Ticks - Use DateTime.Ticks
    ISO8601 - Use ISO8601 DateTime format    		 N ISO8601
    BinaryGUID Yes/On/1 - Store GUID columns in binary form
    No/Off/0 - Store GUID columns as text    		 N On
    Cache Size {size in bytes} N 2000
    Synchronous Normal - Normal file flushing behavior
    Full - Full flushing after all writes
    Off - Underlying OS flushes I/O's    		 N Normal
    Page Size {size in bytes} N 1024
    Password {password} N
    Enlist Y - Automatically enlist in distributed transactions
    N - No automatic enlistment    		 N Y
    Pooling True - Use connection pooling
    False - Do not use connection pooling    		 N False
    FailIfMissing True - Don't create the database if it does not exist, throw an error instead
    False - Automatically create the database if it does not exist    		 N False
    Max Page Count {size in pages} - Limits the maximum number of pages (limits the size) of the database N 0
    Legacy Format True - Use the more compatible legacy 3.x database format
    False - Use the newer 3.3x database format which compresses numbers more effectively    		 N True
    Wiaz

  • 10-27-2007 7:17 AM In reply to

    • am65
    • Top 500 Contributor
    • Joined on 10-26-2007
    • Posts 3

    Re: Connection String

    Reply Contact
    Thanks very much I hadn't seen this file SQLite.NET.chm
Page 1 of 1 (3 items)
Powered by Community Server (Commercial Edition), by Telligent Systems