[Mono-dev] Which SQLite?

[Alex J Lennon]

On 15/07/2014 19:55, Edward Ned Harvey (mono) wrote:
>
> For cross-platform compatibility with mono on mac/linux, and .NET on
> windows...  What is recommended SQLite?
>
>  
>
> When I add System.Data.SQLite.Core via NuGet in windows... it seems to
> be incompatible with mono...  It looks like there is SQLite built-in
> to mono via Mono.Data.SQLite, and I could easily enough do something
> like this:
>
> #if UNIX
>
> using Mono.Data.SQLite;
>
> #else
>
> using System.Data.SQLite;
>
> #endif
>
>  
>
> But then there are some API incompatibilities, such as:
>
>         private void InsertIntoSql(SqliteConnection dbConn)
>
>         versus
>
>         private void InsertIntoSql(SQLiteConnection dbConn)
>
>  
>
> I noticed the existence of "csharp-sqlite" project...  Which would
> probably work, but no updates in over a year...
>
>  
>
> I've found other people on the internet asking this same question, but
> nobody coming up with a good answer...
>
>

fwiw - I am currently using System.Data.SQLite, deploying onto both
.NET/Windows and Mono/Yocto Embedded Linux

However I have had to rebuild System.Data.SQLite from source for Mono use.

ref: http://system.data.sqlite.org/index.html/doc/trunk/www/build.wiki#mono

This works, but as a result I currently have to switch between the two
DLLs, which is something I'm hoping to address at some point.

Cheers,

Alex

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ximian.com/pipermail/mono-devel-list/attachments/20140716/df58c741/attachment.html>