Linq Query using Joins, GroupBy

Vijay

//Classes
Class Employee
{ EmployeeID,Name,Designation,DateOfJoin }

Class SalaryDetails
{ EmployeeID, HRA,DA,Basic,NetSalary }

and then i added Collections of data's using List and List

How to find 3rd highest netsalary using LINQ query ...

I want result is ID,Name,Designation,Basic,NetSalary. So here, I want use join, groupby

How can get it ?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
If the lists are called 'employees' and 'salaries' try:

var query = (from e in employees join s in salaries on e.EmployeeID equals s.EmployeeID orderby s.NetSalary descending select new {e.EmployeeID, e.Name, e.Designation, s.Basic, s.NetSalary}).ElementAt(2);

Incidentally, if there are several employees who have the joint third highest net salary and you want the whole group of them, then you can use:

var query2 = (from e in employees join s in salaries on e.EmployeeID equals s.EmployeeID group new {e.EmployeeID, e.Name, e.Designation, s.Basic, s.NetSalary} by s.NetSalary into g orderby g.Key descending select g).ElementAt(2);
Vulpes13y ago
To get the nth highest net salary, you would of course use ElementAt(n - 1) rather than ElementAt(2).

I don't really know of a better way to do this using LINQ though I suppose instead of ElementAt(n - 1) you could use Skip(n - 1).Take(1) though I doubt whether it's more efficient internally.
Vijay13y ago
thanks Vulpes... i getting result from this.....

Please let me know whether it having alternative way to get nth Highest Salary.... other possible ways