I've been having quite a few problems trying to use Microsoft.SqlServer.Types.SqlGeography. I know full well that support for this in Ling to Sql is not great. I've tried numerous ways, beginning with what would the expected way (Database type of geography, CLR type of SqlGeography). This produces the NotSupportedException, which is wide...
How do you remove the 'holes'/linestrings/.etc from a GeographyCollection? Secondary, how do you join MPolygons that don't intersect into one polygon? We have a roll up of zipcodes to a geographic map, but we have holes in the shape. Researched this and that, but I have not found a good way to remove the inner holes. ConvexHull creat...
I'm looking for a replacement for Microsoft.SqlServer.Types.SqlGeography that will work in Silverlight. I'm primarily interested in arbitrary collection of data (point, path, or polygon) and the STBuffer, STUnion and STIntersect functionality. I need to retrieve some geography data from my database via WCF on the middle tier and return ...
Anyone have a function or DLL that will convert KML to SqlGeography (SQLServer DataType)? I'll write it out myself if i have to, but i'm surprised i can't find one out there. ...