sql地理到dbgeography？ [英] sql geography to dbgeography?

问题描述

也许我错过了一些东西。我有一个sql服务器列的地理数据类型。

Maybe I'm missing something. I have a sql server column of the "Geography" datatype.

我想在我的c＃代码中使用DbGeography类型。以任何方式投射或转换从sql的地理到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屋！