Devart Forums

Code: Select all

var surveys = await Context.SURVEY_TYPES
.FilterByStartEndDate(submissionContext.DueDate)
.ToListAsync();

public static IQueryable<TEntity> FilterByStartEndDate<TEntity>(this IQueryable<TEntity> query, DateTime dueDate) where TEntity : IStartEndDate
{
     return query.Where(e => e.END_DATE == null || e.START_DATE <= dueDate && e.END_DATE >= dueDate);
}

Code: Select all

System.TypeInitializationException: The type initializer for 'DataAccess.Extensions.IQueryableExtensions' threw an exception. ---> System.InvalidOperationException: Sequence contains no matching element
   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)
   at DataAccess.Extensions.IQueryableExtensions..cctor() in C:\Projects\1805.0\app\DataAccess\Extensions\IQueryableExtensions.cs:line 25
   --- End of inner exception stack trace ---
   at Onsis2.DataAccess.Extensions.IQueryableExtensions.FilterByStartEndDate[TEntity](IQueryable`1 query, DateTime dueDate)
   at Queries.Lookups.GetSurveyTypesQueryHandler.<Handle>d__9.MoveNext() in C:\Projects\1805.0\app\Queries\Lookups\GetSurveyTypesQueryHandler.cs:line 50