How to optimize LINQ query to fetch data from multiple table

 

 Your Code:-

_personal = _personal.Where(rec => rec.recruiter == userId).OrderByDescending(c => c.Start_Date).ToList().Union(_personal.Where(rec => rec.recruiter != userId).OrderBy(row => row.recruiterName).ThenByDescending(c => c.Start_Date).ToList());

 

_personal = _personal.Where(rec => rec.recruiter == userId).OrderByDescending(c => c.Start_Date).Union(_personal.Where(rec => rec.recruiter != userId).OrderByDescending(c => c.Start_Date)).ToList(); 

 

 

Why you are using 2 orderby. Whereas only last orderby will work.