Re: [sqlite] Managed only / Mono and Linux support

2011-12-01 Thread Yves Goergen 
On 29.11.2011 04:49 CE(S)T, Joe Mistachkin wrote:
>> 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.

Okay, that works fine. On Linux. I still need the "normal" DLL for
Windows I think.

Is there a way to use the "managed-only" System.Data.SQLite.dll assembly
for both Linux and Windows? That would simplify my deployment process
across platforms a bit.

-- 
Yves Goergen "LonelyPixel" 
Visit my web laboratory at http://beta.unclassified.de
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Managed only / Mono and Linux support

2011-11-29 Thread Joe Mistachkin 

Yves Goergen wrote:
>
> So, where could I have found that information if not here?
>

Good point, I'll add that command line to the "Build Procedures" page on the
web site.

--
Joe Mistachkin

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

Re: [sqlite] Managed only / Mono and Linux support

2011-11-29 Thread Yves Goergen 
On 29.11.2011 04:49 CE(S)T, Joe Mistachkin wrote:
> Adding yet another
> pre-compiled set of binary packages for Mono would just serve to make things
> even more confusing.

Maybe some kind of grid-layout or wizard-style overview would be useful
to find the right download. I regularly get confused about the
descriptions, especially for the separated and mixed-mode assemblies,
and sometimes get an archive where the more important half is missing. I
do know what files I'm looking for, and what file sizes to expect, but
all that isn't advertised on the page.

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

Thank you, that worked surprisingly fast.

So, where could I have found that information if not here?

-- 
Yves Goergen "LonelyPixel" 
Visit my web laboratory at http://beta.unclassified.de
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Managed only / Mono and Linux support

2011-11-28 Thread Joe Mistachkin 

> 
> 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