using System;

using SqlKata;

using SqlKata.Compilers;

using System.Globalization;

public class Program

{

    public static void Main()

    {

        var startDate = new DateTime(2022, 6, 9);

        var advanceDays = 5;

        var compiler = new SqlServerCompiler();

        var query1 = new Query("MyTable");

        query1.Where("BusinessDate", ">", startDate.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture));

        query1.Where("BusinessDate", "<=", startDate.AddDays(advanceDays).ToString("yyyy-MM-dd", CultureInfo.InvariantCulture));

        Console.WriteLine(compiler.Compile(query1).ToString());

​

        var query2 = new Query("MyTable");

        query2.WhereRaw($"BusinessDate > '{startDate.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture)}'");

        query2.WhereRaw($"BusinessDate <= '{startDate.AddDays(advanceDays).ToString("yyyy-MM-dd", CultureInfo.InvariantCulture)}'");

        Console.WriteLine(compiler.Compile(query2).ToString());

    }

}