multiple queries in Entity Framework ?

Combine Expressions instead of using multiple queries in Entity Framework ?

i have following generic queryable (which may already have selections applied):

IQueryable queryable = DBSet.AsQueryable();

Then there is the Provider class that looks like this:

public class Provider
{
public Expression> Condition { get; set; }

[...]
}

The Condition could be defined per instance in the following fashion:

Condition = entity => entity.Id == 3;

Now I want to select all Provider instances which have a Condition that is met at least by one entity of the DBSet:

List providers = [...];
var matchingProviders = providers.Where(provider => queryable.Any(provider.Condition))

The problem with this: I'm starting a query for each Provider instance in the list. I'd rather use a single query to achieve the same result.
This topic is especially important because of questionable performance. How can I achieve the same results with a single
query and improve performance using Linq statements or Expression Trees?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava10y ago
Hi,
There are many option to use multiple query at a time in entity framework.you can use any
1:-use stored procedure
2:-Inline query in c#
3:-Use multiple table.
try any one
0
Vinay Singh10y ago
The best way to use multiple table in Entity framework is to create an SQL view and include it into entity file. and use it as single table in linq
0