Konst_Oneну и вот это посмотрите, там всё подробненько с нюансами:
https://weblog.west-wind.com/posts/2012/Jun/21/Basic-Spatial-Data-with-SQL-Server-and-Entity-Framework-50
Вроде всё тоже самое.
Вот описание сущностей с примера:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
public class GeoLocationContext : DbContext
{
public DbSet<GeoLocation> Locations { get; set; }
}
public class GeoLocation
{
public int Id { get; set; }
public DbGeography Location { get; set; }
public string Address { get; set; }
}
Вот моё:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
public partial class Database_fast_waterEntities : DbContext
{
public Database_fast_waterEntities()
: base("name=Database_fast_waterEntities")
{
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
throw new UnintentionalCodeFirstException();
}
public virtual DbSet<Basin> Basin { get; set; }
public virtual DbSet<Flood> Flood { get; set; }
public virtual DbSet<GeographicalKoordinates> GeographicalKoordinates { get; set; }
public virtual DbSet<Ground> Ground { get; set; }
public virtual DbSet<Locality> Locality { get; set; }
public virtual DbSet<LocalityAndBasin> LocalityAndBasin { get; set; }
public virtual DbSet<Post> Post { get; set; }
public virtual DbSet<PostAndLocality> PostAndLocality { get; set; }
public virtual DbSet<SolarActivity> SolarActivity { get; set; }
public virtual DbSet<sysdiagrams> sysdiagrams { get; set; }
public virtual DbSet<AvgSpeedLevelSnow> AvgSpeedLevelSnow { get; set; }
public virtual DbSet<AvgSpeedLevelWater> AvgSpeedLevelWater { get; set; }
public virtual int InputGeographyKoordinates(string koordinate, Nullable<int> sRID, string typeKoordinates, Nullable<int> radiusAction, Nullable<int> heighSeaLevel, string description)
{
var koordinateParameter = koordinate != null ?
new ObjectParameter("Koordinate", koordinate) :
new ObjectParameter("Koordinate", typeof(string));
var sRIDParameter = sRID.HasValue ?
new ObjectParameter("SRID", sRID) :
new ObjectParameter("SRID", typeof(int));
var typeKoordinatesParameter = typeKoordinates != null ?
new ObjectParameter("TypeKoordinates", typeKoordinates) :
new ObjectParameter("TypeKoordinates", typeof(string));
var radiusActionParameter = radiusAction.HasValue ?
new ObjectParameter("RadiusAction", radiusAction) :
new ObjectParameter("RadiusAction", typeof(int));
var heighSeaLevelParameter = heighSeaLevel.HasValue ?
new ObjectParameter("HeighSeaLevel", heighSeaLevel) :
new ObjectParameter("HeighSeaLevel", typeof(int));
var descriptionParameter = description != null ?
new ObjectParameter("description", description) :
new ObjectParameter("description", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("InputGeographyKoordinates", koordinateParameter, sRIDParameter, typeKoordinatesParameter, radiusActionParameter, heighSeaLevelParameter, descriptionParameter);
}
public virtual int sp_alterdiagram(string diagramname, Nullable<int> owner_id, Nullable<int> version, byte[] definition)
{
var diagramnameParameter = diagramname != null ?
new ObjectParameter("diagramname", diagramname) :
new ObjectParameter("diagramname", typeof(string));
var owner_idParameter = owner_id.HasValue ?
new ObjectParameter("owner_id", owner_id) :
new ObjectParameter("owner_id", typeof(int));
var versionParameter = version.HasValue ?
new ObjectParameter("version", version) :
new ObjectParameter("version", typeof(int));
var definitionParameter = definition != null ?
new ObjectParameter("definition", definition) :
new ObjectParameter("definition", typeof(byte[]));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_alterdiagram", diagramnameParameter, owner_idParameter, versionParameter, definitionParameter);
}
public virtual int sp_creatediagram(string diagramname, Nullable<int> owner_id, Nullable<int> version, byte[] definition)
{
var diagramnameParameter = diagramname != null ?
new ObjectParameter("diagramname", diagramname) :
new ObjectParameter("diagramname", typeof(string));
var owner_idParameter = owner_id.HasValue ?
new ObjectParameter("owner_id", owner_id) :
new ObjectParameter("owner_id", typeof(int));
var versionParameter = version.HasValue ?
new ObjectParameter("version", version) :
new ObjectParameter("version", typeof(int));
var definitionParameter = definition != null ?
new ObjectParameter("definition", definition) :
new ObjectParameter("definition", typeof(byte[]));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_creatediagram", diagramnameParameter, owner_idParameter, versionParameter, definitionParameter);
}
public virtual int sp_dropdiagram(string diagramname, Nullable<int> owner_id)
{
var diagramnameParameter = diagramname != null ?
new ObjectParameter("diagramname", diagramname) :
new ObjectParameter("diagramname", typeof(string));
var owner_idParameter = owner_id.HasValue ?
new ObjectParameter("owner_id", owner_id) :
new ObjectParameter("owner_id", typeof(int));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_dropdiagram", diagramnameParameter, owner_idParameter);
}
public virtual ObjectResult<sp_helpdiagramdefinition_Result> sp_helpdiagramdefinition(string diagramname, Nullable<int> owner_id)
{
var diagramnameParameter = diagramname != null ?
new ObjectParameter("diagramname", diagramname) :
new ObjectParameter("diagramname", typeof(string));
var owner_idParameter = owner_id.HasValue ?
new ObjectParameter("owner_id", owner_id) :
new ObjectParameter("owner_id", typeof(int));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_helpdiagramdefinition_Result>("sp_helpdiagramdefinition", diagramnameParameter, owner_idParameter);
}
public virtual ObjectResult<sp_helpdiagrams_Result> sp_helpdiagrams(string diagramname, Nullable<int> owner_id)
{
var diagramnameParameter = diagramname != null ?
new ObjectParameter("diagramname", diagramname) :
new ObjectParameter("diagramname", typeof(string));
var owner_idParameter = owner_id.HasValue ?
new ObjectParameter("owner_id", owner_id) :
new ObjectParameter("owner_id", typeof(int));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_helpdiagrams_Result>("sp_helpdiagrams", diagramnameParameter, owner_idParameter);
}
public virtual int sp_renamediagram(string diagramname, Nullable<int> owner_id, string new_diagramname)
{
var diagramnameParameter = diagramname != null ?
new ObjectParameter("diagramname", diagramname) :
new ObjectParameter("diagramname", typeof(string));
var owner_idParameter = owner_id.HasValue ?
new ObjectParameter("owner_id", owner_id) :
new ObjectParameter("owner_id", typeof(int));
var new_diagramnameParameter = new_diagramname != null ?
new ObjectParameter("new_diagramname", new_diagramname) :
new ObjectParameter("new_diagramname", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_renamediagram", diagramnameParameter, owner_idParameter, new_diagramnameParameter);
}
public virtual int sp_upgraddiagrams()
{
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_upgraddiagrams");
}
public virtual int UpdateGeographyKoordinates(string koordinate, Nullable<int> sRID, string typeKoordinates, Nullable<int> radiusAction, Nullable<int> heighSeaLevel, string description, Nullable<int> id_GeographicalKoordinates)
{
var koordinateParameter = koordinate != null ?
new ObjectParameter("Koordinate", koordinate) :
new ObjectParameter("Koordinate", typeof(string));
var sRIDParameter = sRID.HasValue ?
new ObjectParameter("SRID", sRID) :
new ObjectParameter("SRID", typeof(int));
var typeKoordinatesParameter = typeKoordinates != null ?
new ObjectParameter("TypeKoordinates", typeKoordinates) :
new ObjectParameter("TypeKoordinates", typeof(string));
var radiusActionParameter = radiusAction.HasValue ?
new ObjectParameter("RadiusAction", radiusAction) :
new ObjectParameter("RadiusAction", typeof(int));
var heighSeaLevelParameter = heighSeaLevel.HasValue ?
new ObjectParameter("HeighSeaLevel", heighSeaLevel) :
new ObjectParameter("HeighSeaLevel", typeof(int));
var descriptionParameter = description != null ?
new ObjectParameter("description", description) :
new ObjectParameter("description", typeof(string));
var id_GeographicalKoordinatesParameter = id_GeographicalKoordinates.HasValue ?
new ObjectParameter("Id_GeographicalKoordinates", id_GeographicalKoordinates) :
new ObjectParameter("Id_GeographicalKoordinates", typeof(int));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("UpdateGeographyKoordinates", koordinateParameter, sRIDParameter, typeKoordinatesParameter, radiusActionParameter, heighSeaLevelParameter, descriptionParameter, id_GeographicalKoordinatesParameter);
}
}
}
public partial class GeographicalKoordinates
{
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
public GeographicalKoordinates()
{
this.Basin = new HashSet<Basin>();
this.Locality = new HashSet<Locality>();
this.Post = new HashSet<Post>();
SqlServerTypes.Utilities.LoadNativeAssemblies(AppDomain.CurrentDomain.BaseDirectory);
}
public int Id_GeographicalKoordinates { get; set; }
public System.Data.Entity.Spatial.DbGeography Koordinate { get; set; }
public Nullable<int> SRID { get; set; }
public Nullable<int> RadiusAction { get; set; }
public System.Data.Entity.Spatial.DbGeography AllKoordinatesArea { get; set; }
public string KoordinateText { get; set; }
public string AllKoordinatesAreaTxt { get; set; }
public Nullable<int> HeighSeaLevel { get; set; }
public string description { get; set; }
public string TypeKoordinates { get; set; }
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
public virtual ICollection<Basin> Basin { get; set; }
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
public virtual ICollection<Locality> Locality { get; set; }
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
public virtual ICollection<Post> Post { get; set; }
}
}
Смущает лишь то, что у меня EF все методы обозначил виртуальными, следовательно они где-то могут ещё описываться, а вот где? В проекте нет.
Вот выгрузка данных из примера, вот только в ней не выгружается поле с типом Geography, а берётся только одно поле:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
[TestMethod]
public void QueryLocationsTest()
{
var sourcePoint = CreatePoint(45.712113, -121.527200);
var context = new GeoLocationContext();
// find any locations within 5 kilometers ordered by distance
var matches =
context.Locations
.Where(loc => loc.Location.Distance(sourcePoint) < 5000)
.OrderBy( loc=> loc.Location.Distance(sourcePoint) )
.Select( loc=> new { Address = loc.Address, Distance = loc.Location.Distance(sourcePoint) });
Assert.IsTrue(matches.Count() > 0);
foreach (var location in matches)
{
Console.WriteLine("{0} ({1:n0} meters)", location.Address, location.Distance);
}
}
Вот моя:
1.
2.
3.
4.
5.
6.
7.
private static List<GeographicalKoordinates> GetGeographicalKoordinatesEf()
{
var context = new Database_fast_waterEntities();
IQueryable<GeographicalKoordinates> query = context.GeographicalKoordinates;
List<GeographicalKoordinates> listGeographicalKoordinates = query.ToList();
return listGeographicalKoordinates;
}
Но у меня выдает ошибку, и судя потому, что ошибка возникает на строке
1.
List<GeographicalKoordinates> listGeographicalKoordinates = query.ToList();
,
если я правильно понял ошибка на стадии преобразования уже полученных по запросу данных в List |
