Linq query. Orderby [closed]

1

Good day, I am starting to use linq and when I execute my query. This takes up to 1 hour. Does anyone know how I can optimize it?

if (db.GpsInfo.Any(i => i.device_id == id))
            {
                var gpsinf = db.GpsInfo
                    .Where(i => i.device_id == id)
                    .OrderByDescending(i => i.date)
                    .Select(d => new Types.GpsInfoRequest
                    {
                        device_id = d.device_id,
                        date = d.date,
                        longitude = d.longitude,
                        latitude = d.latitude,
                        speed = d.speed
                    })
                    .Take(last)
                    .ToList();
                    return gpsinf;                
            }return new List<GpsInfoRequest>();
    
asked by M. Bernal 14.06.2018 в 18:08
source

0 answers