This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 46%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Hello!
Can anyone tell me how to use spatial data such as DbGeography and DbGeometry from System.Data.Entity.Spatial namespace for EF6 and with UseChangeTrackingProxies() mode?
Otherwise we will have an error:
'UseChangeTrackingProxies' requires all entity types to be public, unsealed, have virtual properties, and have a public or protected constructor. 'UseLazyLoadingProxies' requires only the navigation properties be virtual.
@Sergey Korobeynikov, Welcome to Microsoft Q&A, how do you meet the error you get? could you provide some steps or some code so that I could reproduce your problem?
For Microsoft.EntityFrameworkCore we have official Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite package with Point and Geometry types:
using NetTopologySuite.Geometries;
namespace Example
{
public class Location
{
public virtual string Name { get; set; }
public virtual CountryCode Country { get; set; }
public virtual Point Center { get; set; }
public virtual int Zoom { get; set; }
public virtual Geometry Extent { get; set; }
}
}
With use UseChangeTrackingProxies() we have error:
---> System.InvalidOperationException: Property 'Coordinate.X' is not virtual. 'UseChangeTrackingProxies' requires all entity types to be public, unsealed, have virtual properties, and have a public or protected constructor. 'UseLazyLoadingProxies' requires only the navigation properties be virtual.
@Sergey Korobeynikov, Welcome to Microsoft Q&A, based on my test, I could not reproduce your problem. how did you use the UseChangeTrackingProxies() method?
I used it in OnConfiguring method:
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
var connectionString = "connstr";
optionsBuilder.UseSqlServer(connectionString,x=>x.UseNetTopologySuite());
ProxiesExtensions.UseChangeTrackingProxies(optionsBuilder);
}
BTW, Property 'Coordinate.X' is a property of CountryCode class? If so, please provide the related code about CountryCode?
The question is closed. The reason was that the program had several connection settings and one of them did not have the UseNetTopologySuite() option. My apologies :-(