How to use SpatialiteSharp in ASP NET?

[brandonxiang]

How to use SpatialiteSharp in ASP NET?

The dll can not be found in the server.

Any Idea?

[danzel]

Make sure you have x64 / x32 dlls for the native part and they are in the right place.
We haven't run under asp.net, so I'm not really sure, but that's where you should start.

[brandonxiang]

Thank you, I figured it out!

In the SpatialiteLoader.cs source code

 Environment.SetEnvironmentVariable("PATH", Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), Environment.Is64BitProcess ? "x64" : "x86", "spatialite") + ";" + Environment.GetEnvironmentVariable("PATH"));

or we can write it in another way.

var dllPath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
var spatialitePath = Path.Combine(dllPath, Environment.Is64BitProcess ? "x64" : "x86", "spatialite") + ";";
var paths = Environment.GetEnvironmentVariable("PATH");
Environment.SetEnvironmentVariable("PATH", spatialitePath + paths);

In asp.net, the location of Assembly.GetExecutingAssembly().Location is in the C disk asp.net temp folder . Therefore, the dlls for spatialite cannot be found. The code should be modified as follows, which may be better.

var dllPath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase);
var spatialitePath = Path.Combine(dllPath, Environment.Is64BitProcess ? "x64" : "x86", "spatialite") + ";";
var paths = Environment.GetEnvironmentVariable("PATH");
Environment.SetEnvironmentVariable("PATH", spatialitePath + paths);

Or,

var dllPath = AppDomain.CurrentDomain.BaseDirectory;
var spatialitePath = Path.Combine(dllPath, Environment.Is64BitProcess ? "x64" : "x86", "spatialite") + ";";
var paths = Environment.GetEnvironmentVariable("PATH");
Environment.SetEnvironmentVariable("PATH", spatialitePath + paths);

The location for dlls will be corrected to the Source Code folder.