sql 地理到 dbgeography?
也许我遗漏了什么.我有一个地理"数据类型的 sql server 列.
Maybe I'm missing something. I have a sql server column of the "Geography" datatype.
我想在我的 c# 代码中使用 DbGeography 类型.有什么方法可以将 sql 的 geography 转换或转换为 dbgeography?
I want to use the DbGeography type in my c# code. Any way to cast or convert from sql's geography to dbgeography?
推荐答案
抱歉回复晚了 - 但在搜索其他内容时看到了这个.
Sorry for the late response - but saw this whilst searching for something else.
只需执行以下操作:
SqlGeography theGeography;
int srid = 4326; // or alternative
DbGeography newGeography = DbGeography.FromText(theGeography.ToString(), srid);
反转:
DbGeography theGeography;
SqlGeography newGeography = SqlGeography.Parse(theGeography.AsText()).MakeValid();
希望有帮助！
相关文章