EF Core Case Sensitibity не работает ⇐ C#

[Anonymous]

У меня есть кусок кода, который работает в EF Core 2.2, используемый для сравнения строкового корпуса, как показано ниже.public async Task DoesItemNumberExists(Guid revisionId, string itemNumber)
{
var doesExist = await _repository.AnyAsync(a => string.Equals(a.ItemNo, itemNumber, StringComparison.Ordinal) && a.SoqHeading_NP.SoqRevisionId == revisionId);

return doesExist;
}
< /code>
Я запускаю один и тот же код в EF Core 5, и приложение сбоя. Есть помощь?The LINQ expression 'DbSet()
.Where(s => s.IsDeleted == False)
.Join(
inner: DbSet()
.Where(s0 => s0.SoqRevisionId == __ef_filter__RevisionId_0 && s0.IsDeleted == False),
outerKeySelector: s => EF.Property(s, "SoqHeadingId"),
innerKeySelector: s0 => EF.Property(s0, "Id"),
resultSelector: (o, i) => new TransparentIdentifier(
Outer = o,
Inner = i
))
.Any(s => string.Equals(
a: s.Outer.ItemNo,
b: __itemNumber_0,
comparisonType: Ordinal) && s.Inner.SoqRevisionId == __revisionId_1)' could not be translated. Additional information: Translation of the 'string.Equals' overload with a 'StringComparison' parameter is not supported. See https://go.microsoft.com/fwlink/?linkid=2129535 for more information. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.


Подробнее здесь: https://stackoverflow.com/questions/695 ... ot-working