ASP.NET LINQ TO SQL get the 2nd highest salary

Question

I am making a small demo project where i wish to retrieve 2nd highest salary on label,using linq to sql

Here is my code :

public void Get2ndHighestSalalry()
{
using (DemoDbEntitiesss db = new DemoDbEntitiesss())
{
var query =db.Employees
                     .OrderByDescending(e => e.Salary)
                     .Skip(1)
                     .First();
lbl2ndhighestSalalry.Text = query.ToString();
}
}

But it returning me below code on my label :

My Output is :

second Highest Salary is : asp.netPracticeAgainWithLINQ.DB.Employee //here i want 2nd highest salary

Where i am making mistake ?

Any help would be much appreciated.

Thanks

Ehsan Sajjad · Answer

You have a small mistake you are converting the returned employee object to string instead of the Salary property of the Employee object. Change it to be this: lbl2ndhighestSalalry.Text=query.Salary.ToString();

Ashwanikumar singh · Answer

Its working...Thanks

ASP.NET LINQ TO SQL, get the 2nd highest salary