SQLite deployment for .net application

Question

I have used SQLite for my .net framework 4.0 WPF application, It works perfectly fine with development environment. I just copied system.data.sqlite.dll to my application installed location but it is not working as expected.

Can anybody tell me how to deploy the SQLite for the fresh machine.?

IS it not enough to distribute only the dll's? I am using installshiled 2011 to build the setup installer. Please share if anybody has merge module for SQLite.

Early help will be greatly appreciated.

Thanks in advance

Vinay MS

Solution 1

You should be able to operate with just the interop and the data DLLs. Our project uses these:
.

The LINQ one isn't necessary unless you use LINQ.

I've renamed every copy of SQLite3.dll or SQLite3.exe on my computer (there were dozens) and the application continues to run. I was checking to make sure my answer is correct, and this is something we're going to have to do, in order to make sure our installs work, too.

Solution 2

What Tangurena says is right (which in fact helped me to get it working) but you also need to include the config setting mentioned in the readme of SQLite:

<system.data>
    <DbProviderFactories>
        <remove invariant="System.Data.SQLite" />
        <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite"
             type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.80.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
    </DbProviderFactories>
</system.data>

Comments

[D'Arcy Rittich]

What does not working mean?

[Daniel A. White]

how is it not working as expected?