Only parameterless constructors and initializers are supported in LINQ to Entities. GeoCoordinate(latitude, longitude);

Question

I have this situation: I need to find nearby location using lat and long. Using this:

var coord = new GeoCoordinate(latitude, longitude);
                var nearest = context.ParkingSpaces.Select(x => new GeoCoordinate(x.Latitude.Value, x.Longitude.Value))
                                         .OrderBy(x => x.GetDistanceTo(coord)).First();

But I am getting following error:

Only parameterless constructors and initializers are supported in LINQ to Entities

Please help

Answer 1

You can rewrite to something like this:

var coord = new GeoCoordinate(latitude, longitude);
var nearest = context.ParkingSpaces
     .Select(x => new { Latitude = x.Latitude.Value, Longitude = x.Longitude.Value })
     .ToList()
     .Select(x => new GeoCoordinate(Latitude, Longitude))
     .OrderBy(x => x.GetDistanceTo(coord))
     .First();