EF保存平面數(shù)據(jù)到SqlServer

 /// 

 /// 從多點(diǎn)數(shù)據(jù)生成多邊形
 /// 
 /// 百度地圖多邊形的點(diǎn)集
 public static DbGeometry PolygonFromPointsJson(string pointsJson)
 {
 var points = JsonSerializer.ToEntity>(pointsJson);
 if (points.First().GetHashCode() != points.Last().GetHashCode())
 {
 points.Add(points.First());
 }

 var closePoints = ((IEnumerable)points).Select(item => string.Format("{0} {1}", item.Lng, item.Lat));
 var wkt = "POLYGON((" + string.Join(",", closePoints) + "))";
 return DbGeometry.PolygonFromText(wkt, SYSTEM_ID);
 }

 /// 

 /// 廣告范圍表
 /// 
 [Serializable]
 public class AdvRange : Entity
 {
 /// 

 /// 廣告范圍名
 /// 
 [Required]
 [Length(20)]
 public string Name { get; set; }

 /// 

 /// 所屬城市標(biāo)識(shí)ID
 /// 
 public Guid CityId { get; set; }

 /// 

 /// 多邊形
 /// 
 
 public DbGeometry Polygon { get; set; }
 }

 /// 

 /// 獲取多邊形的點(diǎn)
 /// 
 /// 
 public static List GetPolygonPoints(this DbGeometry geometry)
 {
 var list = new List();
 var points = geometry.WellKnownValue.WellKnownText.Matches(@"-?[1-9]\d*\.\d*|-?0\.\d*[1-9]\d*").Select(item => decimal.Parse(item)).ToArray();
 for (var i = 0; i < points.Length; i = i + 2)
 {
 list.Add(new LngLat { Lng = points[i], Lat = points[i + 1] });
 }
 if (list.First().GetHashCode() == list.Last().GetHashCode())
 {
 list.RemoveAt(list.Count - 1);
 }
 return list;
 }