How to get the last element of a Collection Navigation property

Question

public class Personel  
{
  public int Id {set;get;}
  public ICollection<Agreement> Agreements { set; get;}
}

public class Agreement
{
  public int Id {set;get;}
}

I have a domain model as above and have a dbcontext.

How do I get the last Agreement?

var result = _db.Personels.Include(a=>a.Agreements).OrderByDescending(x => x.Id);

I want to get all the personels and last agreement of them...

This gives me all the agreement of a personel, i want only the last one ordered by id descending.

you may select anonymous type where each on represents `personel` and another its `lastAgreement`. — Andrew, Dec 13 '14 at 12:01

Andrew · Answer 1 · 2014-12-13T12:00:39.657

1

var result = 
from p in _db.Personels
select new {
        personel = p,
        lastAgreement = p.Agreements.OrderByDescending(x => x.Id).FirstOrDefault()
       }
.ToList();

Now you can convert this to list of Personels and set lastAgreement for each of those.

edited Dec 13 '14 at 12:00

answered Dec 13 '14 at 11:51

Andrew

3,648
1
15
29

I want to get all the personels and last agreements of them – DarthVader Dec 13 '14 at 11:52
This gives me last personel, not all the personels with their last agreement – DarthVader Dec 13 '14 at 11:53
ok, that can be done with linq, moment – Andrew Dec 13 '14 at 11:54

How to get the last element of a Collection Navigation property

1 Answers1