Related Post: Linq Join With Where Clause Example Linq Left Join Example With Where Clause Linq Or In Where Clause