using System;

using SqlKata;

using SqlKata.Compilers;

public class Program

{

    public static void Main()

    {

        var compiler = new SqlServerCompiler();

        var qCountMultipleCol = new Query("Table").Select("PostId")

                .SelectRaw("count(1) as count")

                .GroupBy("PostId");

        var rCountMultipleCol = compiler.Compile(qCountMultipleCol);

        Console.WriteLine("Std AsCount multi-column:\r\n{0}", rCountMultipleCol);

    }

}