How write this SQL in LINQ, please?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ronald S. Cook - 31 Mar 2008 03:13 GMT

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

Reply to this Message

Daniel Ruehle - 31 Mar 2008 05:12 GMT

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

> Any idea how to write this in LINQ?
>
[quoted text clipped - 8 lines]
> Thanks for any help,
> Ron

Reply to this Message

Ronald S. Cook - 31 Mar 2008 11:41 GMT

THANKS!

> Here you go:
>
[quoted text clipped - 25 lines]
>> Thanks for any help,
>> Ron

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...