using System;
using System.Data;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Linq;

namespace LinqVsDataSet
{
    class Program
    {
        static void Main(string[] args)
        {
            string connection = "Data Source=.;Initial Catalog=AdventureWorks;Integrated Security=True";

            using (var sql = new SqlConnection(connection))
            using (var linq = new DbDataContext(connection))
            {
                sql.Open();

                // Замеры LINQ
                Execute(() =>
                {
                    var data = linq.Customers.ToList();
                });

                // Замеры DataSet
                Execute(() =>
                {
                    var data = new DataTable();
                    data.Load(new SqlCommand("SELECT * FROM Sales.Customer", sql).ExecuteReader());
                });

                // Чистый фетч ридера без маппинга
                Execute(() =>
                {
                    using (var reader = new SqlCommand("SELECT * FROM Sales.Customer", sql).ExecuteReader())
                    {
                        while (reader.Read())
                        {

                        }
                    }
                });
            }

            Console.Read();
        }

        static void Execute(ActionDelegate Action)
        {
            var sw = Stopwatch.StartNew();
            for (int i = 0; i < 10; i++)
            {
                Action();
            }
            Console.WriteLine(sw.ElapsedMilliseconds);
        }
        delegate void ActionDelegate();
    }
}