CSharp · Console
using Dapper;
using System;
using System.Data;
using System.Data.SqlServerCe;
using System.Linq;
public class Program
{
public static void Main()
{
string sql = "SELECT * FROM Customers";
using (var connection = new SqlCeConnection("Data Source=SqlCe_Northwind.sdf"))
{
connection.Open();
var customers = connection.Query(sql).ToList();
Console.WriteLine(customers.Count);
}
}
}