SQLite Connection Pooling

Periop IT's Avatar

Periop IT

15 Sep, 2010 05:15 PM via web

How do you set connection pooling to true using SQLiteConfiguration?

  1. Support Staff 2 Posted by James Gregory on 15 Sep, 2010 05:56 PM

    James Gregory's Avatar

    How would you do it normally?

    On Wed, Sep 15, 2010 at 6:17 PM, Periop IT <
    tender+d5aebe5561f41e2a1d602fece5ceb553ba08138e3@tenderapp.com<tender%2Bd5aebe5561f41e2a1d602fece5ceb553ba08138e3@tenderapp.com>
    > wrote:

  2. 3 Posted by Periop IT on 15 Sep, 2010 06:18 PM

    Periop IT's Avatar

    If I was doing it with a connection string in ado.net it would be something like:

    "data source=C:\temp\mydb.sqlite;Pooling=True"

  3. Support Staff 4 Posted by James Gregory on 15 Sep, 2010 07:29 PM

    James Gregory's Avatar

    So what's stopping you from doing that now? How are you supplying the
    connection string right now?

    On Wed, Sep 15, 2010 at 7:20 PM, Periop IT <
    tender+d5aebe5561f41e2a1d602fece5ceb553ba08138e3@tenderapp.com<tender%2Bd5aebe5561f41e2a1d602fece5ceb553ba08138e3@tenderapp.com>
    > wrote:

  4. 5 Posted by Periop IT on 17 Sep, 2010 10:34 AM

    Periop IT's Avatar

    I tried your suggestion and it just seems a bit odd because you have to specify the file name in the connection string and with WithFile method. Since I am using SQLite I did not originally have to supply a connection string using the WithFile method was sufficient. However, ths does solve the problem and I know in the future to use this techinque for other conection properties. Thanks...

Reply to this discussion

Preview Comments are parsed with Markdown. Help with syntax

Attached Files

    You can attach files up to 10MB

    What comes next? 'Monday Tuesday Wednesday ?????'