Linq provides the extension methods First() and FirstOrDefault(), which return the first object in a typed IEnumerable<T> collection, or default<T> if the collection is empty.
Sometimes you don’t only want to use the first element, but require the collection to have at most 1 element.
The methods ExpectOne and ExpectOneOrNull implement the requirement to have exactly 1 (or at most 1) element in an IEnumerable collection:
public static class LinqExtensions
{
/*
* ExpectOne: returns exactly one record. if 0 or >1 found then exception
* ExpectOneOrNull: returns exactly one record or null. if >1 found then exception
*/
public static TSource ExpectOne(this IEnumerable source)
{
TSource result = default(TSource);
bool b = true;
foreach (TSource o in source)
{
if (b)
result = o;
else
throw new ExpectOneException("too many elements in result set. one element expected.");
b = false;
}
if (b)
throw new ExpectOneException("no element in result set. one element expected.");
return result;
}
public static TSource ExpectOneOrNull(this IEnumerable source)
{
bool b = true;
TSource result = default(TSource);
foreach (TSource o in source)
{
if (b)
result = o;
else
throw new ExpectOneException("too many elements in result set. one or no element expected.");
b = false;
}
return result;
}
}
A separate exception class makes it easier for the application code (and developers!) to handle cases where more than 1 record is returned, indicating an error in the query.
If you want to replace for calls to First(<condition>) by ExpectOne(), replace First(<condition>) by Where(<condition>).ExpectOne().
As ExpectOne() contains compiled code, you cannot use these methods in Compiled Queries.
This may seem as a disadvantage. In reality it makes program code simpler because compiled queries are now required to always return an IEnumerable<T>, and the calling code needs to specify the expected result set size of the query.
It may seem desirable to replace all occurrences of First() and FirstOrDefault() by ExpectOne() and ExpectOneOrNull(). There are cases where original Linq methods are still necessary and valid:
Any() to check whether a collection is not empty, i.e. elements exist that match criteria
First() and FirstOrDefault() to find the first element in a sorted collection (e.g. the greatest element less than the original value)
Posted by devio 
Posted by devio 
)
Posted by devio 
