SqlKata by CData Sansan ADO.NET Provider

SqlKata.cs

using System;
using SqlKata.Compilers;
using SqlKata.Execution;
using System.Data.CData.Sansan;

namespace CData.SqlKata.SampleProject
{
    class Program
    {
        static void Main(string[] args)
        {
            // 通常 SqlConnection を渡すが、CData ADO.NET ProviderのConnectionを渡すように変更するだけ。
            var connection = new SansanConnection("APIKey=XXXXXX;range=me;");
            var compiler = new SqlServerCompiler();
            var db = new QueryFactory(connection, compiler);

            var response = db.Query("Bizcards").Select("BizcardId", "CompanyName").Get<Bizcards>();

            foreach (var item in response)
            {
                Console.WriteLine($"BizcardId: {item.BizcardId}; CompanyName: {item.CompanyName}");
            }
        }
    }

    internal class Bizcards
    {
        public string BizcardId { get; set; }

        public string CompanyName { get; set; }
    }
}