how to get top 5 records in linq with lambda expression

Question

c# entity-framework-6 linq model-view-controller

I need to get top 5 values of one column "Tempreture" at this time stamp like "select top 5 temperature of the tbl_sensors order by desc "

I tried like this, but I don't know how to get top 5

var sensorsVal = DB.tbl_sensors.OrderByDescending(x => x.CurrentTime).FirstOrDefault();

View more on Stack Overflow

Gilad Green · Accepted Answer · 8/18/2019 7:15:40 AM

var sensorsVal = DB.tbl_sensors.OrderByDescending(x => x.CurrentTime)
                   .Select(x => x.temperature)
                   .Take(5);

Gilad Green