How do I get the most recent entry from a table using LINQ?

I have a table of prices, which has a column for Date Updated. Every time there is a price change, a new entry is made to the table. In order to return the most up to date price, I am trying to order by date, and then use .Last() to get the newest entry: ``` var upgrades = from d in vf.tl_phn_devices where d.available == true select new { DeviceName = d.tl_phn_manufacturer.manufacturer + " " + d.model, Price = (from p in vf.tl_phn_prices where p.deviceID == d.deviceID orderby p.dateUpdated ascending select p.price).Last(), URL = d.url, ImageURL = d.image }; ``` However, when I run the above I get an error saying that .Last() is unsupported. I have also tried .AsEnumberable().Last() but this didn't work either. Elsewhere in the code I got round a similar issue by taking an extra step: ``` var orders = (from o in vf.tl_phn_orders where o.login == CurrentUserName orderby o.date ascending select new { Login = o.login, Name = o.name, Device = o.tl_phn_device.tl_phn_manufacturer.manufacturer + " " + o.tl_phn_device.model, Price = o.tl_phn_price.price, date = o.date }).AsEnumerable(); var order = orders.LastOrDefault(); ``` But I want to do it all in one "hit" so I can return it in the first query.