retrieve 5 last records from table by C#

I want to retrieve 5 last record of one of my tables in Data base by C# code.I don't want using query in Sql server. in my code I want to retrieve 5 last records in tt.what do I do? now it retrieves all of the Records

            var temp = db.Positions.Where(P => P.DeviceID == device.ID);
            List<Position> tempPositions = FilterPosition(temp.ToList<Position>());
            var tt = FilterStops(tempPositions, new TimeSpan(0, 30, 0), 100);
            List<JsonDevicePositionModel> returnPositions = (

                                          from p in tt

                                             select new 
           开发者_StackOverflow中文版                                      JsonDevicePositionModel

                                             {
                                                 DeviceID = p.Position.DeviceID,
                                                 Latitude = p.Position.Latitude,
                                                 Longitude = p.Position.Longitude,
                                                 SerialNumber = p.Position.Device.SerialNumber,

                                                 Speed = p.Position.Speed,


                                             }).ToList(); 

            //    }
            return Json(returnPositions, JsonRequestBehavior.AllowGet);

        }

If performance don't worry you, than just use extension method Take of Enumerable class:

var tt = FilterStops(tempPositions, new TimeSpan(0, 30, 0), 100).Take(5);

You can try ...

from p in tt.GetRange(tt.Count - 6, 5)

an other possibility: from p in tt.Skyp(tt.Count - 5).Take(5)

var full = FilterStops(tempPositions, new TimeSpan(0, 30, 0), 100);
var tt= full.Skip(full.Count - 5);