[Mono-dev] Which SQLite?

[Timotheus Pokorra]

Hello Edward,

> Mono.Data.Sqlite is reliably available on mac/linux.  And I had the brilliant idea that I would install mono on windows, and then grab the Mono.Data.Sqlite.dll from the mono installation, and distribute it.  However, there's this:
> https://bugzilla.xamarin.com/show_bug.cgi?id=2148
>
> The latest windows release is mono 3.2.3, which unfortunately includes a bug that kills Mono.Data.Sqlite, that was fixed in 3.2.6 or 3.2.7.
>
> So if a new windows build is released anytime soon with a functional Mono.Data.Sqlite, it will be the obvious easiest best solution:  Just use Mono.Data.Sqlite natively on systems that have mono (max/linux) and distribute Mono.Data.Sqlite.dll for windows.

For OpenPetra, we are using Mono.Data.Sqlite in our code, no matter if
it runs on Linux or on Windows.

On Windows, we copy the Mono.Data.Sqlite.dll and the sqlite3.dll to
our application directory.
We use the Mono.Data.Sqlite.dll that came with Mono for windows
version 2.10.6 (C:\Program Files (x86)\Mono-2.10.6\lib\mono\2.0).
The sqlite3.dll comes from
http://www.sqlite.org/sqlite-dll-win32-x86-3071300.zip
We run the software with Microsoft .Net, not with Mono on Windows.

On Linux, sqlite3 is installed via yum or apt-get, and
Mono.Data.Sqlite is part of Mono anyways in the GAC.

That works fine for us.

Hope this helps,
  Timotheus