Is it possible to query where string[] intersects string[]?

[VagyokC4]

Hi @slorello89,

I'm trying to query using contains and filter by an array of values.

Finding the needle works as expected

var needle = "John";
collection.Where( x => x.Names.Contains(needle) ).ToListAsync();

How do I find multiple needles?

var needles = new[]{"John","Steve"};
collection.Where( x => x.Names.Any( y => needles.Contains(y)) ).ToListAsync();

Basically I want to find records where the two array values intersect.

But I get the following error: Unable to cast object of type 'System.Linq.Expressions.InstanceMethodCallExpression1' to type 'System.Linq.Expressions.BinaryExpression'.

Thoughts?

[slorello89]

Not a case I thought of when I was implementing the Any behavior in last summer, but seems like something that should be doable.

[VagyokC4]

Hello @slorello89, I trust you've been well. I hope everything is progressing smoothly on your end.

I was wondering if there have been any developments regarding this Any behavior issue? I've been encountering this use case increasingly.

Regarding this issue: #181 (comment), I am hopeful that we can target IEnumerable to encompass all .NET array-like structures.

Thank you once again for your attention to these matters.