SingleOrDefault: "At most" there is one item matching the query or default
FirstOrDefault: "At least" one item matching the query or default
Why Select clause comes after from clause in LINQ?
What is the benefit of using LINQ on Dataset?