vendredi 1 janvier 2016

access GEOMETRY data format (in SQL server 2008 R2) from C# by SQLite

I have a SQL server 2008 R2 database with a table that hold GEOMETRY data as the boundary of some geo polygons. I can access the database from C# visual studio 2013 WPF.

Now, I need to create a SQLite database that can hold the same information as the SQL server. I have checked some websites related to Spatialite.

I still have some questions about it.

(1) If I do not install Spatialite, can I access and query geometry data in SQLite from C# ?

(2) If it is required to install Spatialite, how can my application users access Spatialite database if they do not install Spatialite on their machine ?

(3) Currently, System.Data.SQLite can be installed from Visual studio 2013 PM command line, but, Spatialite cannot be got there. How to make sure that my application user can access Spatialite database when they use my application ? Do I need to let my application install Spatialite automatically when users install my application ?

thanks

Aucun commentaire:

Enregistrer un commentaire