System.Data.SQLite

Hello,

I've developed my application using Mono under a Linux system. I use System.Data.SQLite and because I wanted it to work in both Linux under Mono and Windows under .NET, I used the managed-only version.

When I run the program with Mono/Linux, everything works fine.

For Windows, I've also added the sqlite3.dll file to the same directory with the binaries (but not added it as a reference to the solution). Every time I attempt to run the program, I get a BadImageFormatException on the command that opens the SQL connection to the database.

All systems I've tested the program on are x86, so the numerous threads I found about problems when running under x64 don't apply to me... Is it something that can be resolved easily?

Any thoughts on this?

I also looked for threads about using the managed-only version to make it work in different platforms, but I only found threads about it working fine in Windows and not working in Linux, while my problem is the opposite...

I still can't find out how to make this work.

If I use the non-managed-only version it seems to work fine, so maybe the problem is with sqlite3.dll. However I've tried re-downloading it and it still won't work with the managed-only version.