> 
> The error it gives
> me is a DllNotFoundException for SQLite.Interop.dll. But from what I've
> read on the web by now, this isn't the path to go. I think I need some
> sort of "managed-only" SQLite version that will use the platform's
> libsqlite (in my Ubuntu, 3.7.7 is installed). Unfortunately I couldn't
> find any such version on the very long download page. Where can I get it?
> 

It is relatively easy to compile the source code to produce a "managed-only"
binary that can be used on Mono; however, as you point out, there are
already
(N+1) pre-compiled binaries packages on the download page.  Adding yet
another
pre-compiled set of binary packages for Mono would just serve to make things
even more confusing.

>
> So what should I do about Mono/Linux support for SQLite in C#?
> 

If you have access to a Windows machine with MSBuild and/or Visual Studio,
compiling the managed-only binary is fairly simple.  Here are the exact
steps:

1. Extract the source archive (preserving paths) to a clean directory (e.g.
"C:\dev\System.Data.SQLite").

2. Open a Visual Studio Command Prompt, using 2008 if you want .NET 3.5 or
2010 if you want .NET 4.0.

3. Change the current directory to the root of the System.Data.SQLite source
code tree.

4. Execute the following command, where [year] is either 2008 or 2010:

        MSBuild.exe System.Data.SQLite\System.Data.SQLite.[year].csproj
/t:Rebuild /p:Configuration=Release /p:UseInteropDll=false
/p:UseSqliteStandard=true

--
Joe Mistachkin

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to