Getting exception using ProviderFactory to create a SQLite connection

Question

I am trying to use the ProviderFactory.CreateConnection() to obtain a SQLite connection. I am getting a System.ArgumentException with the following message:

"Keyword not supported: 'datetimeformat'."

The connection string is:

@"data source=d:\db\Test.db3;Pooling=True;Max Pool Size=10;datetimeformat=Ticks"

In the app.config file I have:

<system.data>
  <DbProviderFactories>
    <remove invariant="System.Data.SQLite"/>
    <add name="SQLite Data Provider" invariant="System.Data.SQLite"
       support="3F" description=".Net Framework Data Provider for SQLite"
         type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
  </DbProviderFactories>
</system.data>

The connection string works when I instantiate a SQLiteConnection instance. It fails using the ProviderFactory. Any suggestions on how I can resolve this?

"ProviderFactory" is my own property accessor to DbProviderFactories.GetFactory("...") — Elan, Feb 25 '11 at 00:36

score 2 · Accepted Answer · answered Feb 25 '11 at 00:33

2

It turned out, that I forgot to execute the following line of code:

DbProviderFactory providerFactory =
    DbProviderFactories.GetFactory("System.Data.SqlClient");

And the ensuing code worked then as expected without exception:

IDbConnection conn = providerFactory.CreateConnection();

answered Feb 25 '11 at 00:33

Elan

6,084
12
64
84

8

Do you mean DbProviderFactories.GetFactory("System.Data.SQLite")? – Patrick McDonald Dec 22 '11 at 17:50
It connects to the internal `SQLServer` database and thinks it works with `sqlite` :D – androschuk.a May 25 '18 at 13:18

Getting exception using ProviderFactory to create a SQLite connection

1 Answers1