我该如何在我的C#类模型中定义postgis 'geography'类型,以便OrmLite可以轻松地将其传递给Postgresql,以便我可以运行空间查询,并保存空间数据到'geography'列?
我该如何在我的C#类模型中定义postgis 'geography'类型,以便OrmLite可以轻松地将其传递给Postgresql,以便我可以运行空间查询,并保存空间数据到'geography'列?
对于这种情况,最好的库是NetTopologySuite;
你可以像这样使用它;
protected GisSharpBlog.NetTopologySuite.Geometries.Geometry _geom;
public GisSharpBlog.NetTopologySuite.Geometries.Geometry Geom
{
get { return _geom; }
set { _geom = value; }
}
protected string _geomwkt;
public virtual string GeomWKT
{
get
{
if (this.Geom != null)
return this.Geom.ToText();
else
return "";
}
set
{
string wktString = value;
if (string.IsNullOrEmpty(wktString))
_geom = null;
else
{
var fact = new GeometryFactory();
var wktreader = new WKTReader(fact);
_geom = (Geometry)wktreader.Read(wktString);
}
}
}