EF Core - Where clause on multiple field in object list
Hi everybody
I'm using sql through EF Core, here at work, and I have a problem querying multiple results from a table
In SQL, I've got that table of
In my code, I've got a list of
I'd like to do something along the line of
But where foo could match with any element of an enumerable of bar
My colleague suggest something looking like this
Super, that works
But...
It's slow as heck
Our guess is that it try out every row in the table foo?
Like, he can't really know the result of foo.a + foo.b so it does it for every single row before checking it for a match inside of stringifiedBar?
How would one do that query properly?
I'm using sql through EF Core, here at work, and I have a problem querying multiple results from a table
In SQL, I've got that table of
FooabIn my code, I've got a list of
BarabI'd like to do something along the line of
But where foo could match with any element of an enumerable of bar
My colleague suggest something looking like this
Super, that works
But...
It's slow as heck
Our guess is that it try out every row in the table foo?
Like, he can't really know the result of foo.a + foo.b so it does it for every single row before checking it for a match inside of stringifiedBar?
How would one do that query properly?
