I have for loop of datatable Employees with count 12k and inside that loop i want to filter a collection based on Employeeid. The collection has 22k records . I have used linq query to filter this collection. Due to this filtering loop has performance issue. How can i optimize filtering of large collection.I have for loop of datatable Employees with cou