how to create a linq query using join and max

Posted by geoff swartz on Stack Overflow See other posts from Stack Overflow or by geoff swartz
Published on 2010-06-10T17:31:08Z Indexed on 2010/06/10 18:32 UTC
Read the original article Hit count: 288

Filed under:
|
|

I have 2 tables in my linq dbml. One is people with a uniqueid called peopleid and the other is a vertical with a foreign key for peopleid and a uniqueid called id. I need to create a type of linq query that does a left outer join on people and gets the latest record in the vertical table based off the max(id) column. Can anyone suggest what this should look like? Thanks.

© Stack Overflow or respective owner

Related posts about LINQ

Related posts about join