INQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria

Whenever you use SingleOrDefault, you clearly state that the query should result in at most a single result. On the other hand, when FirstOrDefault is used, the query can return any amount of results but you state that you only want the first one.

I personally find the semantics very different and using the appropriate one, depending on the expected results, improves readability.

Related Posts:

  1. Entity Framework vs LINQ to SQL
  2. What’s the difference between .NET Core, .NET Framework, and Xamarin?
  3. What is a singleton in C#?
  4. ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
  5. My C# application is returning 0xE0434352 to Windows Task Scheduler but it is not crashing
  6. What is WCF? and what can it do?
  7. C# Set collection?
  8. Difference between Delphi and Delphi.NET
  9. Where/how can I download (and install) the Microsoft.Jet.OLEDB.4.0 for Windows 8, 64 bit?
  10. Convert Enum to String
  11. Windows Application has stopped working :: Event Name CLR20r3
  12. Nullable object must have a value?
  13. Why is Dictionary preferred over Hashtable in C#?
  14. What is the difference between ASP.NET MVC 6 and ASP.NET Core 1.0 and the reason behind the core framework?
  15. Extension methods must be defined in a non-generic static class
  16. Embed a System.String in XAML
  17. What’s the difference between struct and class in .NET?
  18. Does anyone still use [goto] in C# and if so why?
  19. How does the “Using” statement translate from C# to VB?
  20. Where Is Machine.Config?
  21. Why does .Net Socket.Disconnect take two minutes?
  22. Extension methods must be defined in a non-generic static class
  23. ClickOnce runtime DFSVC.EXE
  24. “An attempt was made to load a program with an incorrect format” even when the platforms are the same
  25. What is the best way to parse html in C#? [closed]
  26. Best C# API to create PDF
  27. C# cannot convert method to non delegate type
  28. What is the difference between const and readonly in C#?
  29. SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904)
  30. Convert Linq Query Result to Dictionary
  31. Cannot send a content-body with this verb-type
  32. Html.Partial vs Html.RenderPartial & Html.Action vs Html.RenderAction
  33. Pass Method as Parameter using C#
  34. Nuget connection attempt failed “Unable to load the service index for source”
  35. Cannot access a disposed object – How to fix?
  36. HashSet vs. List performance
  37. Cannot access a disposed object – How to fix?
  38. ArrayList vs List<> in C#
  39. How to access Session variables and set them in javascript?
  40. What’s the @ in front of a string in C#?
  41. How to solve ‘…is a ‘type’, which is not valid in the given context’? (C#)
  42. Could not load file or assembly App_Web_ * with a precompiled ASP.NET website project
  43. How should I cast in VB.NET?
  44. Calling the base constructor in C#
  45. Warning: Found conflicts between different versions of the same dependent assembly
  46. Best way to repeat a character in C#
  47. Connection string using Windows Authentication
  48. What is the purpose ApplicationDbContext Class in (under IdentityModels.cs file) ASP.NET MVC 5?
  49. How to solve “Could not establish trust relationship for the SSL/TLS secure channel with authority”
  50. How to empty a list in C#?
  51. What is The difference between ListBox and ListView
  52. SQLite equivalent to ISNULL(), NVL(), IFNULL() or COALESCE()
  53. Could not establish secure channel for SSL/TLS with authority ‘*’
  54. Cannot attach the file *.mdf as database
  55. How to open an Excel file in C#?
  56. What is a method group in C#?
  57. How can I download a file with batch file without using any external tools?
  58. How do I save a stream to a file in C#?
  59. Print Pdf in C#
  60. How do I concatenate two arrays in C#?
  61. Can a Byte[] Array be written to a file in C#?
  62. .NET Framework 4.6 or a later update is already installed on this computer
  63. Retrieving the COM class factory for component with CLSID {XXXX} failed due to the following error: 80040154
  64. How do I find the PublicKeyToken for a particular dll?
  65. Could not find any resources appropriate for the specified culture or the neutral culture
  66. Consider app.config remapping of assembly with no app.config mapping
  67. What is a “first chance exception”?
  68. Sequence contains more than one element
  69. What is the difference between String and string in C#?
  70. LINQ query on a DataTable
  71. Creating a List of Lists in C#
  72. A certificate chain could not be built to a trusted root authority
  73. C# int to byte[]
  74. Linq: GroupBy, Sum and Count
  75. IOException: The process cannot access the file ‘file path’ because it is being used by another process
  76. No connection could be made because the target machine actively refused it?
  77. What does a lock statement do under the hood?
  78. What is the purpose of nameof?
  79. Net 2.0 Framework Service Pack 2 Issue
  80. Access to the path is denied
  81. ToList().ForEach in Linq
  82. Metadata file ‘.dll’ could not be found
  83. How do I declare a DefaultValue attribute whose value is an array of strings?
  84. Invalid URI: The format of the URI could not be determined
  85. Get single value from dictionary by key
  86. Why did I get the compile error “Use of unassigned local variable”?
  87. Reading CSV file and storing values into an array
  88. How to split() a delimited string to a List
  89. Remove element of a regular array
  90. How can I know if a process is running?
  91. windows could not start service on local computer error 5 access is denied
  92. How to convert UTF-8 byte[] to string
  93. Produce a random number in a range using C#
  94. Which passwordchar shows a black dot (•) in a winforms textbox?
  95. How do I fix a .NET windows application crashing at startup with Exception code: 0xE0434352?
  96. How to do Select All(*) in linq to sql
  97. c# .net change label text
  98. How to implement a property in an interface
  99. .NET Core vs Mono
  100. How to enumerate an enum

Leave a Comment