Andrew Rondeau wrote:
>
> Hmmm, part of the point of Mono is that a pure CLR .dll or .exe can work
on
> any platform without recompilation.
>
The standard build of System.Data.SQLite looks for a native assembly (DLL)
named
"SQLite.Interop.dll" and this has always been the case. It is possible to
build
a System.Data.SQLite managed-only assembly that looks for a native assembly
(DLL)
named "sqlite3" by compiling the System.Data.SQLite sources, setting the
UseInteropDll build property to false and the UseSqliteStandard build
property
to true, just as described on the build procedures wiki page. Mono on Unix
is
documented to automatically transform the reference from "sqlite3" to
something
like "libsqlite3".
Unfortunately, there is no pre-compiled binary package currently available
for
this build configuration. This is primarily because:
1. There are already a huge number of build configurations available and
adding
another one would likely just increase confusion with little benefit to the
community.
2. It is relatively easy to build System.Data.SQLite for Mono on any Windows
machine, with minimal effort, using only freely available tools (MSBuild and
the
.NET Framework). Visual Studio is not required to build the
System.Data.SQLite
assembly for use with Mono.
>
> How can I have a System.Data.SQLite that will work on Windows x86, x64,
and
> the various Unixes without recompiling System.Data.SQLite? PHX's older
> version of System.Data.SQLite does this, except for Windows x64.
>
Fairly easily, as long as you have a Windows XP or later machine with the
.NET
Framework 3.5. Also, x64 should not have anything to do with it since you
are
asking about the managed-only assembly which runs unmodified on all
processor
architectures.
The exact steps to follow for obtaining and building the System.Data.SQLite
source code are listed on the following two wiki pages:
Obtaining the source code:
http://system.data.sqlite.org/index.html/doc/trunk/www/source.wiki
Building the source code (see the "Mono" section):
http://system.data.sqlite.org/index.html/doc/trunk/www/build.wiki
Please let me know if you have any specific questions not addressed on one
of
these pages.
--
Joe Mistachkin
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
