could you provider some tips about combining dynamic conditions in where(func()), especially meaning 'or' about querybuilder HOT 4 CLOSED

Something like:

class Group {
 public List<Condition> Conditions {get; set;}
}

class Condition {
 public string Field {get; set;}
 public string Operator {get; set;} 
 public object Value {get; set;}  
}

var query = new Query("Countries");

foreach(Group group in groups) 
{
   query.Where(q => {
      foreach(Condition c in group.Conditions)
      {
         q.OrWhere(c.Field, c.Operator, c.Value);
      }
      return q;
   });
}

from querybuilder.

I will close this for now, feel free to reopen if something is not clear

from querybuilder.

@ahmad-moussawi I need to create groups like you have above but your code will not compile.
.NetFiddle here

Compilation error (line 37, col 18): Not all code paths return a value in lambda expression of type 'System.Func<SqlKata.Query,SqlKata.Query>'
Compilation error (line 37, col 18): Cannot convert lambda expression to type 'object' because it is not a delegate type

Expected output:

SELECT * FROM [Countries] WHERE ([Group1Field1] = @p0 OR [Group1Field2] > @p1 OR [Group1Field3] < @p2 OR [Group1Field4] = @p3) OR( [Group2Field1] = @p4 OR [Group2Field2] >= @p5 OR [Group2Field3] <= @p6)

from querybuilder.

@rs199483 thanks for the update, yes this is outdated now, I will update the original answer

from querybuilder.