In .NET 6 we can set default return values for FirstOrDefault(), LastOrDefault() and SingleOrDefault() 

.NET 6 has a few LINQ improvements. One of them is support for custom default return values for FirstOrDefault(), LastOrDefault() and SingleOrDefault(). 

Normally when using these methods the built in default value for a type will be returned when the collection has no items, for example this would be null for reference types and 0 for int types. 

In .NET 6 we’ll be able to choose which default value gets returned when the collection is empty. Two examples are below…


You might also be interested in...

Use SQL Server Sparse columns to optimize storage for columns with mostly NULL values
If your SQL Server database has nullable columns which contain mostly null values consider setting these columns to sparse. SQL … Continue reading Use SQL Server Sparse columns to optimize...

CheckBoxFor values not binding when output using foreach loop
If your outputting a list of checkboxes using CheckBoxFor from within a loop and are having problems getting the checkboxes … Continue reading CheckBoxFor values not binding when output using...

Trimming strings globally with automapper
Recently working on an application based on a legacy database with a lot of char data types I was using … Continue reading Trimming strings globally with automapper...

Using C# indices and range syntax to access elements in a sequence
Microsofts Indices and Ranges page provides examples of the indices and range syntax available in C# (introduced in C#8). This syntax … Continue reading Using C# indices and range syntax to...

How to check if a default constraint exists in SQL Server
Perhaps your scripting rollout and rollback DDL SQL changes and you want to check for instance if a default constraint … Continue reading How to check if a default constraint...

Leave a Reply

Your email address will not be published. Required fields are marked *