I need a spatial-enabled SQLite solution for a x64 Windows application I am developing.
I have examined and downloaded and attempted to compile the SQLite amalgamation package; I've looked at the cSharpSqlite package; I've downloaded the System.Data.SQLite source.
The cSharpSqlite package I can at least compile, but none of the others. I am using VS2012 Professional.
There is so much outdated, confusing, incomplete and just plain incorrect information on how to build a x64 SQLite library that can load extensions. Half of the comments on SE about this are unanswered, or with a few comments that are now no longer up to date.
Can you list some simple steps to show me?
(Or link to a binary that I obviously couldn't find?)
Best Answer
You can download the spatialite binary from http://www.gaia-gis.it/gaia-sins/windows-bin-amd64/
You can download the .net assemblies from http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki, or just use NuGet after reading which bits you need.
Open the connection, enable extension loading, and then load the SpatiaLite extension using
SELECT load_extension()
.