using System;

using SqlKata;

using SqlKata.Compilers;

using System.Collections.Generic;

​

public class Program

{

    public static void Main()

    {

        List<Group> groups = new List<Group>

        {

            new Group

            {

                Conditions = new List<Condition>

                {

                    new Condition {Field = "Country", Operator = "=", Value="United States", clauseOperator = ""},

                    new Condition {Field = "Country", Operator = "=", Value="Russia", clauseOperator = "OR"}

                }, clauseOperator = ""

            },

            new Group

            {

                Conditions = new List<Condition>

                {

                    new Condition {Field = "Data Source", Operator = "=", Value="Network", clauseOperator = ""},

                    new Condition {Field = "Data Source", Operator = ">=", Value="NSA", clauseOperator = "OR"}

                }, clauseOperator = "AND"

            }

        };

        var query = new Query("Countries");

        foreach (Group group in groups)

        {

            if ( group.clauseOperator == "AND" )

            {

                query.Where(q => {

                foreach (Condition c in group.Conditions)

                {

                    if ( c.clauseOperator == "OR" )

                        q.OrWhere(c.Field, c.Operator, c.Value);

                    else

                        q.Where(c.Field, c.Operator, c.Value);

                }

                return q;

​

                });

            }

            else {

                query.OrWhere(q => {

                foreach (Condition c in group.Conditions)

                {

                    if ( c.clauseOperator == "OR" )

                        q.OrWhere(c.Field, c.Operator, c.Value);

                    else

                        q.Where(c.Field, c.Operator, c.Value);

                }

                return q;

​

                });

            }

        }

        query.Where("Id", "=", 10);

        Console.WriteLine(new SqlServerCompiler().Compile(query).Sql);

    }

}

​

class Group

{

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

    public string clauseOperator { get; set; }

}

​

class Condition

{

    public string Field { get; set; }

    public string Operator { get; set; }

    public object Value { get; set; }

    public string clauseOperator { get; set; }

}

​