How write this SQL in LINQ, please?

[Ronald S. Cook]

Any idea how to write this in LINQ?

SELECT am.AnimalId,
MAX(am.AnimalMoveActualDateTime) AS AnimalMoveActualDateTime
FROM AnimalMove am
INNER JOIN Animal a ON am.AnimalId = a.AnimalId
INNER JOIN Lookup l ON a.StatusLookupId = l.LookupId
WHERE l.LookupCode = 'ONY'
GROUP BY am.AnimalId

Thanks for any help,
Ron

 

[Daniel Ruehle]

Here you go:

from am in dc.AnimalMove
where am.Animal.Lookup.LookupCode == "ONY"
group am by am.AnimalId into g
select new
{
g.Key,
AnimalMoveActualDateTime = g.Max(g2 => g2.AnimalMoveActualDateTime)
}

Not having your mapping, I can't syntax check that, but it should be close.

Regards,
Dan Ruehle

 

[Ronald S. Cook]

THANKS!

Here you go:

from am in dc.AnimalMove
where am.Animal.Lookup.LookupCode == "ONY"
group am by am.AnimalId into g
select new
{
g.Key,
AnimalMoveActualDateTime = g.Max(g2 => g2.AnimalMoveActualDateTime)
}

Not having your mapping, I can't syntax check that, but it should be
close.

Regards,
Dan Ruehle