DapperSample.CDataDriverSansan.cs

DapperSample.CDataDriverSansan.cs

using Dapper;
using System;
using System.Data.CData.Sansan;
using System.Linq;

namespace DapperSample.CDataDriverSansan
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("Hello World!");

            string sqlBizCards = "SELECT * FROM BizCards";

            using (var connection = new SansanConnection("APIKey=XXXXXXXXXX;range=me;"))
            {
                var bizcards = connection.Query<BizCard>(sqlBizCards).ToList();

                Console.WriteLine(bizcards.Count);

                foreach (var item in bizcards)
                    Console.WriteLine($"BizcardId: {item.BizcardId}; FirstName: {item.FirstName}; LastName: {item.LastName} ");
            }
        }
    }

    public class BizCard
    {
        public string BizcardId { get; set; }

        public string FirstName { get; set; }

        public string LastName { get; set; }
    }
}