sql 地理到 dbgeography? [英] sql geography to 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();

希望有帮助！

这篇关于sql 地理到 dbgeography?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！