using Dapper;

using System;

using System.Data;

using System.Data.SqlServerCe;

using System.Linq;

​

public class Program

{

    /** 

        SQL

        * test query https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

        DAPPER - ORM

        * documentation for dapper https://dapper-tutorial.net/dapper

        * what is dapper https://en.wikipedia.org/wiki/Dapper_ORM

        * what is ORM https://en.wikipedia.org/wiki/Object–relational_mapping

    */

​

    public static void Main()

    {

        string sql = "SELECT * FROM Customers";

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

        {

            connection.Open();

            var customers = connection.Query<Customer>(sql).ToList();

            FiddleHelper.WriteTable(customers);

        }

        sql = "SELECT * FROM Customers";

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

        {

            connection.Open();

            var customers = connection.Query(sql).ToList();

            Console.WriteLine(customers.Count);

        }

        sql = "SELECT TOP 10 * FROM OrderDetails";

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

        {

            var orderDetail = connection.Query(sql);

            var allTogether = orderDetail

                .SelectMany(row => new[]{row.OrderDetailID, row.OrderID, row.ProductID, row.Quantity})

                .Distinct();

            FiddleHelper.WriteTable(allTogether);

        }

    }

    private class Customer

    {

        public int CustomerID

        {

            get;

            set;

        }

​

        public string CustomerName

        {

            get;

            set;

        }

    }

}