[Help] KML to SQL Server

Oct 10, 2014 at 4:20 AM
Is there a way to store the kml file directly into sql server?
Kml files only contain polygon data.
My idea is to extract and store the coordinates into SQL Server Geography data type instances. Is there any library to do it quickly?
Here is library for creating KML file from Geography: https://sqlservertokml.codeplex.com/
Oct 10, 2014 at 5:16 AM
I wrote a similar solution which you can find on GitHub (geokml). It has no references to any library except the SQL Server-libraries.
The library provides attributes so you can turn any entity framework-entity into kml. The unittest-project gives also information how to do that.

I would happy to help you with this.

see: https://github.com/MannusEtten/GeoKml

when you like to use it I can even publish it on NuGet.