Advertisement
Guest User

Untitled

a guest
Aug 19th, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1.  
  2. // Write a SQL query to find the names and salaries of the employees that take the minimal salary in the company.
  3. var context = new TelerikAcademyContext();
  4. var minSalary = context.Employees.OrderBy(e => e.Salary).First();
  5. var result = context.Employees
  6. .Where(f => f.Salary == minSalary.Salary)
  7. .Select(
  8. g => new
  9. {
  10. g.FirstName,
  11. g.LastName,
  12. }).ToList();
  13.  
  14.  
  15. foreach (var r in result)
  16. {
  17. Console.WriteLine($"{r.FirstName} {r.LastName}");
  18. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement