Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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; }
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.