When using EFCore value conversions for enum properties and performing a comparison in a where clause, Devart ignores the value expression and generates a query using the numeric value of the enum.
When defining an enum value directly in the Where clause, it works. E.g.:
Code: Select all
dbContext
.Set<Rider>()
.Where(_ => _.Mount == EquineBeast.Mule)
.ToList();
Code: Select all
var enumValue = EquineBeast.Mule;
dbContext
.Set<Rider>()
.Where(_ => _.Mount == enumValue)
.ToList();
Database Provider: Devart.Data.Oracle.EFCore version 9.6.646