I want to get the latest result returned from this request. How should I do it? Last and LastOrDefault are not supported by Linq to Sql.
var docs = (from d in db.Documents
where d.Version > 1
orderby d.DocumentID
select new
{
d.DocumentID,
d.DocTypeID,
d.Name,
d.Version
});
source
to share