EntityFramework Core - entity filtering based on the rules

[LukasKuchta]

Hello, is it possible to integrate rules for entities filtering based on those rules ?

I have current 3 steps solution

var bre = new RulesEngine.RulesEngine(w, reSettings);

// 1) rule engine evaluation
List<RuleResultTree> resultList = await bre.ExecuteAllRulesAsync(w[0].WorkflowName, customer);

// 2) select valid rules
int[] ruleFitIds = resultList
            .Where(r => r.IsSuccess)
            .Select(r => int.Parse(r.Rule.SuccessEvent)).ToArray();

// 3) apply filter based on the fitted ids
var entities = dbContext.Product.where(p=> ruleFitIds.Contains(p.id));

But should be fine to have something like this:

// filter in rdbs endgine not in the memmory
var results = dbContext.Products.where(custom where conditions).Filter(rulesContext).ToList();

Thanks for hints