[sqlite] Including PRAGMA statements on connection string

[Joe Mistachkin]

Mike McWhinney wrote:
>
> public static string OMconnectionString = "datasource=database.db;
> Default Timeout=20; PRAGMA busy_timeout = 600; PRAGMA synchronous=Off";
>

The connection string should contain name/value pairs, delimited by "="
and ";" (i.e. connection string properties), not SQL statements.

There is not currently a connection string property that directly sets
the busy timeout; however, one may be added in the future.  Meanwhile,
the synchronous property can be set by using the following fragment in
the connection string:

        "Synchronous=Off;"

--
Joe Mistachkin