Join two tables with one to many relationship and pick latest from multiple side
c# entity-framework-core linq
Popular Answer
var answer = (from p in context.Patients
join v in context.PatientVisits on p.ID equals v.PatientID into subs
from sub in subs.DefaultIfEmpty()
group sub by new { p.ID, p.FirstName, p.LastName } into gr
select new
{
gr.Key.FirstName,
gr.Key.LastName,
VisitDate = gr.Max(x => x == null ? null : (DateTime?)x.VisitDate)
}).ToList();
Related Questions
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow