Add a derivate project (e.g. System.Data.SpatiaLite) that includes SpatiaLite extension for SQLite so there is no need to call load_extension('libspatialite-2.dll') every time a connection is opened.
<hr /><i>mistachkin added on 2011-10-20 14:11:43 UTC:</i><br />
It might be better to provide a generic mechanism to pre-load extensions during the connection creation processing.
Also, I am not sure if the license for SpatialLite is compatible with that of System.Data.SQLite.
<hr /><i>mistachkin added on 2012-09-19 23:19:28 UTC:</i><br />
I think the solution to this is to have a static callback registered with the SQLiteConnection class that allows the caller to be notified when a connection is opened and/or closed.
<hr /><i>mistachkin added on 2012-09-20 11:56:15 UTC:</i><br />
Extension loading functionality added in check-in [5759e099be].
|