Sequence contains no matching element

[EJD]

This worked with v9.4.348 but now no longer works with v9.5.381

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);
}

Throws error:

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

[Shalex]

Please upload a small complete test project with the corresponding DDL/DML script to ftp://ftp.devart.com (credentials: anonymous / yourEmail). Also specify the version of your Oracle Server.

[EJD]

Ended up being toSQL causing the issue.

https://github.com/aspnet/EntityFramewo ... ssues/9414

We corrected the code and the issue is resolved.

[Shalex]

Thank you for letting us know.