You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
System.InvalidOperationException: The LINQ expression 'DbSet<OrderItem>()
.Where(d => !(d.IsDeleted) && d.SerialNumber != null ^ !(string.IsNullOrEmpty(d.Barcode)))' could not be translated. 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.
Currently, EF Core does not support logical XOR.
For example, let's say I want to find all order items not deleted that are missing
SerialNumber
orBarcode
, but not both. This query fails to compile:Instead I have to write it out like this:
It would be nice if EF Core did this translation automatically.
The text was updated successfully, but these errors were encountered: