public object GetEmployee() // get an information of employees using sp { var employeeList = from x in employeeDBContext.spGetEmployeeDetails() orderby x.ID select new { x.FirstName, x.LastName, x.Salary }; return(employeeList.ToList()); }