[Mono-list] Which SQLite?

[Luke Pulverenti]

I will respond with what we're doing with Media Browser in case anyone can
offer suggestions. We are using the nuget package for windows. There is
only one single line of code that knows our data provider is Sqlite:

https://github.com/MediaBrowser/MediaBrowser/blob/master/MediaBrowser.Server.Implementations/Persistence/SqliteExtensions.cs#L148

Then for mono we remap the references to a different assembly:

https://github.com/MediaBrowser/MediaBrowser/blob/master/MediaBrowser.Server.Implementations/MediaBrowser.Server.Implementations.csproj#L76-L82

Finally, the mono build has native assemblies for different targets:

https://github.com/MediaBrowser/MediaBrowser/blob/master/MediaBrowser.Server.Mono/MediaBrowser.Server.Mono.csproj#L151-L170


On Tue, Jul 15, 2014 at 2:58 PM, Edward Ned Harvey (mono) <
edward.harvey.mono at clevertrove.com> 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...
>
>
>
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
>


-- 
Luke Pulverenti
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ximian.com/pipermail/mono-list/attachments/20140715/f8a73969/attachment.html>