Hi
Your SQL query will look like below in Linq:
var query = from u in Users
join i in system_log on
u.user_id equals i.user_id
group u by u.user_name into usernew
select new
{
username = usernew.Key
last_action_date = g.Max( p => p.usernew.last_action_date)
}
Hope This will help you.
Thank you.