Re: [sqlite] [System.Data.SQLite] Extension datatypes (i.e. Spatialite geometry)

Hi, thanks for your answer again (again I was unclear in my question, sorry for that - I am using "ST_GeomFromText('LINESTRING(APPROPRIATE_VALUES)', APPROPRIATE_SRID)" ). I think I found the problem: My parametrized command text looks like: "INSERT INTO RoadSegments (Id, Geometry) VALUES

Re: [sqlite] [System.Data.SQLite] Extension datatypes (i.e. Spatialite geometry)

Hi Mark, Currently I am converting my C# polygons to a string of the form "LINESTRING(x1 y1, ..., xN yN)" which would be the WKT (Well-Known Text) format. If I understand your answer correct I could simply convert my C# polygons to the WKB (Well-Known Binary) format and use BLOB as the DbType

Re: [sqlite] [System.Data.SQLite] Extension datatypes (i.e. Spatialite geometry)

Hi Sandro, thanks for your answer - I will post the question (possibly including the solution) on the appropriate mailing list. Actually, my columns are defined the way you suggested - I will make it more clear in my post to the spatialite mailing-list. But your answer sounds interesting -

Re: [sqlite] [System.Data.SQLite] Extension datatypes (i.e. Spatialite geometry)

On Tue, 29 Jan 2013 14:22:07 +0100, Markus Dibo wrote: Hello dear (System.Data.)SQLite users, I am using System.Data.SQLite in combination with Spatialite which works very well. One problem I currently have ... Hi Markus, I suppose that posting such questions into the SpatiaLite own

[sqlite] [System.Data.SQLite] Extension datatypes (i.e. Spatialite geometry)

Hello dear (System.Data.)SQLite users, I am using System.Data.SQLite in combination with Spatialite which works very well. One problem I currently have is that when I'm trying to insert several milions of records (namely road segments with just two columns: Id INTEGER, Geometry LINESTRING) it