❔ IQueryable implementation

.OrderBy(x => (x as ILocatable).DistanceTo(request.Longitude, request.Latitude))

.OrderBy(x => (x as ILocatable).DistanceTo(request.Longitude, request.Latitude))

System.InvalidOperationException: The LINQ expression 'DbSet<City>()
    .OrderBy(c => ((c as ILocatable)).DistanceTo(
        longitude: __request_Longitude_0, 
        latitude: __request_Latitude_1))' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

System.InvalidOperationException: The LINQ expression 'DbSet<City>()
    .OrderBy(c => ((c as ILocatable)).DistanceTo(
        longitude: __request_Longitude_0, 
        latitude: __request_Latitude_1))' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

 public double DistanceTo(double longitude, double latitude)
    {
        const double R = 6371; // Earth radius in kilometers

        var dLat = (latitude - Latitude) * Math.PI / 180;
        var dLon = (longitude - Longitude) * Math.PI / 180;
        var lat1 = Latitude * Math.PI / 180;
        var lat2 = latitude * Math.PI / 180;

        var a = Math.Sin(dLat / 2) * Math.Sin(dLat / 2) +
                Math.Sin(dLon / 2) * Math.Sin(dLon / 2) * Math.Cos(lat1) * Math.Cos(lat2);
        var c = 2 * Math.Atan2(Math.Sqrt(a), Math.Sqrt(1 - a));

        return R * c;
    }

 public double DistanceTo(double longitude, double latitude)
    {
        const double R = 6371; // Earth radius in kilometers

        var dLat = (latitude - Latitude) * Math.PI / 180;
        var dLon = (longitude - Longitude) * Math.PI / 180;
        var lat1 = Latitude * Math.PI / 180;
        var lat2 = latitude * Math.PI / 180;

        var a = Math.Sin(dLat / 2) * Math.Sin(dLat / 2) +
                Math.Sin(dLon / 2) * Math.Sin(dLon / 2) * Math.Cos(lat1) * Math.Cos(lat2);
        var c = 2 * Math.Atan2(Math.Sqrt(a), Math.Sqrt(1 - a));

        return R * c;
    }