using Dapper;

using System;

using System.Data;

using System.Data.SqlServerCe;

using System.Linq;

public class Program

{

    public static void Main()

    {

        string sqlOrderDetails = "SELECT * FROM OrderDetails;";

        string sqlOrderDetail = "SELECT * FROM OrderDetails WHERE OrderDetailID = @OrderDetailID;";

        string sqlCustomerInsert = "INSERT INTO Customers (CustomerName) Values (@CustomerName);";

​

        using (var connection = new SqlCeConnection("Data Source=SqlCe_W3Schools.sdf"))

        {

            var orderDetails = connection.Query(sqlOrderDetails).ToList();

            var orderDetail = connection.QueryFirstOrDefault(sqlOrderDetail, new {OrderDetailID = 1});

            var affectedRows = connection.Execute(sqlCustomerInsert,  new {CustomerName = "Mark"});

            Console.WriteLine(orderDetails.Count);

            Console.WriteLine(affectedRows);

        }

    }

​

}