using System;

using SqlKata;

using SqlKata.Compilers;

using System.Collections.Generic;

using System.Linq;

​

namespace ConsoleApp

{

    public class Program

    {

        public static void Main()

        {

            List<Group> groups = new List<Group>

            {

                new Group

                {

                    Conditions = new List<Condition>

                    {

                        new Condition { Field = "Group1Field1", Operator = "=", Value = "Group1Value1" },

                        new Condition { Field = "Group1Field2", Operator = ">", Value = "Group1Value2" },

                        new Condition { Field = "Group1Field3", Operator = "<", Value = "Group1Value3" },

                        new Condition { Field = "Group1Field4", Operator = "=", Value = "Group1Value4" }

                    }

                },

                new Group

                {

                    Conditions = new List<Condition>

                    {

                        new Condition { Field = "Group2Field1", Operator = "=", Value = "Group2Value1" },

                        new Condition { Field = "Group2Field2", Operator = ">=", Value = "Group2Value2" },

                        new Condition { Field = "Group2Field3", Operator = "<=", Value = "Group2Value3" }

                    }

                }

            };

​

            var query = new Query("Countries");

​

            foreach (var group in groups)

            {

                if (!group.Conditions.Any())

                    continue;

​

                if (group.Conditions.Count == 1)

                {

                    var single = group.Conditions.Single();

                    query.OrWhereRaw(string.Format("([{0}] {1} ?)", single.Field, single.Operator), single.Value);

                    continue;

                }

​

                var first = group.Conditions.First();

                var last = group.Conditions.Last();

                var others = group.Conditions.Skip(1).Take(group.Conditions.Count - 2);

​

                query.OrWhereRaw(string.Format("([{0}] {1} ?", first.Field, first.Operator), first.Value);

                foreach (var c in others)

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

                query.OrWhereRaw(string.Format("[{0}] {1} ?)", last.Field, last.Operator), last.Value);

            }

​

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

​

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

        }

    }

​

    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; }

    }

}

​