有没有像在.NET 4.5 dbgeometry makevalid [英] is there something like dbgeometry makevalid in .net 4.5

问题描述

我试图来计算这样的折线的区域

I'm trying to calculate area of polyline like that

    string poly = "POLYGON ((637604.918432772 2230520.64934531,
637622.257266129 2230419.44632915, 637279.107128549 2230192.04910755, 636765.470527745 2230179.6468564, 636778.005055813 2229861.77192838, 636529.81646905 2229464.29327025, 635813.486592791 2229523.30345774, 636017.385069448 2229974.32341381, 636267.323659164 2230070.32127916, 637035.026966561 2230404.70764784, 637275.265066307 2230401.13408429, 637604.918432772 2230520.64934531, 637604.918432772 2230520.64934531))";
     DbGeometry gm = DbGeometry.FromText(poly, 32637);
double area= gm.Area.Value; // here I got the error Exception has been thrown by the target of an invocation.

后来我才发现，错误的振振有辞的dbgeometry无效
我尝试代码在MS SQL 2012也给我的错误，但是当我试图像

I noticed later that the reson of error that the dbgeometry is invalid I try the code in ms sql 2012 also give me the error but when I tried like that

SELECT @gm.MakeValid().STArea()

这就是曾在SQL
我的问题是有去使几何有效。网
谢谢

thats worked in sql my question is there is away to make the geometry valid in .net thank you

推荐答案

我跟博扬同意，除非您使用的是实体框架？

I'd agree with Bojan, unless you are using the Entity Framework?

SqlGeometry对象有一个MakeValid（）函数，因此，使用你的榜样，允许DbGeography和SqlGeography之间的转换：

The SqlGeometry object has a MakeValid() function, so using your example, allowing for a convert between DbGeography and SqlGeography:

DbGeography geog;
SqlGeometry geom = SqlGeometry.STGeomFromWKB(new SqlBytes(geog.AsBinary()), 32637);

然而，除非您使用的是EF，我建议你只需使用SqlGeometry为

However, unless you are using EF, I'd recommend simply using SqlGeometry as

1. 没有投/转换


2. SqlGeometry比DbGeometry提供远远更多的功能。

希望有所帮助。

这篇关于有没有像在.NET 4.5 dbgeometry makevalid的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！