© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
C#C
C#•3y ago•
41 replies
SWEETPONY

✅ can't translate linq query

I have following query:
var devices = dbContext.Set<Model.Entities.Device>()
    .Where(device => categories
        .Any(device.Categories.Contains))
    .WhereCanRead(currentOperator.Scope)
    .ToList();
var devices = dbContext.Set<Model.Entities.Device>()
    .Where(device => categories
        .Any(device.Categories.Contains))
    .WhereCanRead(currentOperator.Scope)
    .ToList();


And got error:
System.InvalidOperationException: The LINQ expression 'category => EntityShaperExpression:
    Parsec.Segment.Model.Entities.Device
    ValueBufferExpression:
        ProjectionBindingExpression: EmptyProjectionMember
    IsNullable: False
.Categories
    .Contains(category)' could not be translated. 
System.InvalidOperationException: The LINQ expression 'category => EntityShaperExpression:
    Parsec.Segment.Model.Entities.Device
    ValueBufferExpression:
        ProjectionBindingExpression: EmptyProjectionMember
    IsNullable: False
.Categories
    .Contains(category)' could not be translated. 


I tried to add
AsEnumerable
AsEnumerable
after
categories
categories
and
device.Categories
device.Categories
but it doesn't work
C# banner
C#Join
We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.
61,871Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

✅ ef core can't translate a query
C#CC# / help
3y ago
✅ LINQ, simple query
C#CC# / help
2y ago
❔ Linq Query HELP
C#CC# / help
3y ago
❔ Help with linq query
C#CC# / help
4y ago