• Create a view that has all the joins and fields you need then wire up your linq to that.