Getting Started - Database Template - Northwind

CSharp · Console

/Program.cs

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);
		}
	}
}
;