Method DeferredElementAtOrDefault

DeferredElementAtOrDefault<TSource>(IQueryable<TSource>, Int32)

This method is the deferred implementation of the extension method . In EF some linq operations are performed on the client end instead of the server. Therefore, if we use the regular method it will cache the data from the database before performing the actual "ElementAtOrDefault" operation. To cater to this, we provide with a deferred implementation that delays the caching so that only the result can be cached.

Declaration
public static QueryDeferred<TSource> DeferredElementAtOrDefault<TSource>(this IQueryable<TSource> source, int index)
Parameters
Type Name Description
IQueryable<TSource> source

An System.Linq.IQueryable`1 to return an element from.
System.Int32 index

The zero-based index of the element to retrieve.
Returns
Type Description
QueryDeferred<TSource>

default(TSource) if index is outside the bounds of source; otherwise, the element at the specified position in source.
Type Parameters
Name Description
TSource

The type of the elements of source.