I'm trying to accomplish something that I could write in 10 seconds in sql but can't quite wrap my head around this linq syntax yet. Think of a super simple customer table & order table, I want to return say the top 10 customers based on how many shipped orders they have. here is the sql i would use Code Block select c.* from customer c join orders o on c.customerid = o.orderid where c.active=1 and o.shipped=1 this is the linq i have so far, can't figure out how to filter only the shipped orders
Read More...