Is it possible for dynamic filter using predicates

[matigarowel]

Ex for dynamic filter: public async Task < IActionResult > SearchPerson(List searchModel) { using (SqlConnection cn = new SqlConnection(_connectionString)) { cn.Open(); var pg = new PredicateGroup { Operator = GroupOperator.And, Predicates = new List() }; foreach(s in searchModel){ pg.Predicates.Add(Predicates.Field(f => f[s.Field], s.Operator, s.Value)); } IEnumerable list = cn.GetList(pg); cn.Close(); } }

[valfrid-ly]

Didn't understand the question.

You just posted a code sample.

What's happening with it?

[matigarowel]

I would like to create PredicateGroup that will bind base on value of searchModel entity to Predicates.Field< Person >.

For Example:

var searchModel = [ { Field: 'Id', Value: 1, Operator: Operator.Eq }, { Field: 'Active', Value: true, Operator: Operator.Like }, { Field: 'LastName', Value: 'Br%', Operator: Operator.Like } ];

var pg = new PredicateGroup { Operator = GroupOperator.And, Predicates = new List() };

foreach(s in searchModel){ pg.Predicates.Add(Predicates.Field(f => "How do I set the searchModel.Field value here since it is function expressison for Person entity?", s.Operator, s.Value)); }

[valfrid-ly]

This should use your entity as it's the one who has the mapping.

You actually need something like this, without the expression:

public async Task < IActionResult > SearchPerson(List searchModel)
{
  using (SqlConnection cn = new SqlConnection(_connectionString))
  {
    cn.Open();
    var pg = new PredicateGroup { Operator = GroupOperator.And, Predicates = new List() };
    pg.Predicates.Add(Predicates.Field<Person>(f => f[s.Field], s.Operator, s.Value));

    foreach(s in searchModel){
    pg.Predicates.Add(Predicates.Field<Person>(f[s.Field], s.Operator, s.Value));
   }
   IEnumerable list = cn.GetList(pg);
   cn.Close();
   }
  }

The catch with this is that the name of the property has to match EXACTLY the name in the object.