LINQ Single vs First

by

If you’re expecting a Single record, it’s always good to be explicit in your code.

I know others have written why you use one or the other, but I thought I’d illustrate why you should NOT use one, when you mean the other.

Note: In my code, I will typically use FirstOrDefault() and SingleOrDefault() but that’s a different question.

Take, for example, a table that stores Customers in different languages using a Composite Key ( ID, Lang ):

DBContext db = new DBContext();
Customer customer = db.Customers.Where( c=> c.ID == 5 ).First();

This code above introduces a possible logic error ( difficult to trace ). It will return more than one record ( assuming you have the customer record in multiple languages ) but it will always return only the first one… which may work sometimes… but not others. It’s unpredictable.

Since your intent is to return a Single Customer use Single();

The following would throw an exception ( which is what you want in this case ):

DBContext db = new DBContext();
Customer customer = db.Customers.Where( c=> c.ID == 5 ).Single();

Then, you simply hit yourself on the forehead and say to yourself… OOPS! I forgot the language field! Following is the correct version:

DBContext db = new DBContext();
Customer customer = db.Customers.Where( c=> c.ID == 5 && c.Lang == "en" ).Single();

First() is useful in the following scenario:

DBContext db = new DBContext();
NewsItem newsitem = db.NewsItems.OrderByDescending( n => n.AddedDate ).First();

It will return ONE object, and since you’re using sorting, it will be the most recent record that is returned.

Using Single() when you feel it should explicitly always return 1 record will help you avoid logic errors.

More Related Contents:

  1. LINQ to Entities does not recognize the method
  2. Which method performs better: .Any() vs .Count() > 0?
  3. What is the difference between IQueryable and IEnumerable?
  4. How to do SQL Like % in Linq?
  5. Is it better to call ToList() or ToArray() in LINQ queries?
  6. LINQ to SQL Left Outer Join
  7. Why is LINQ JOIN so much faster than linking with WHERE?
  8. Linq to Entities – SQL “IN” clause
  9. Case insensitive string compare in LINQ-to-SQL
  10. LINQ on the .NET 2.0 Runtime
  11. Wrap a delegate in an IEqualityComparer
  12. “Or” equivalent in Linq Where() lambda expression
  13. How do I get the MAX row with a GROUP BY in LINQ query?
  14. Why does a Linq Cast operation fail when I have an implicit cast defined?
  15. EF LINQ include multiple and nested entities
  16. .NET LINQ query syntax vs method chain
  17. Ignore namespaces in LINQ to XML
  18. LINQ to Entities does not recognize the method Int32 get_Item(Int32)
  19. Why use LINQ Join on a simple one-many relationship?
  20. Does LINQ work with IEnumerable?
  21. LINQ, can’t join to string
  22. How to use “contains” or “like” in a dynamic linq query?
  23. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  24. What can I do to resolve a “Row not found or changed” Exception in LINQ to SQL on a SQL Server Compact Edition Database?
  25. How to perform merge sort using LINQ?
  26. Linq: What is the difference between Select and Where
  27. Linq to Objects: does GroupBy preserve order of elements?
  28. The model backing the ‘ApplicationDbContext’ context has changed since the database was created
  29. How to Convert Row to Column in Linq and SQL
  30. How to return a page of results from SQL?

Leave a Comment