// @nuget: Dapper -Version 1.60.6

using Dapper;

using System;

using System.Data.SqlClient;

​

​

public class Program

{

    public class OrderDetail

    {

        public int OrderDetailID

        {

            get;

            set;

        }

​

        public int OrderID

        {

            get;

            set;

        }

​

        public int ProductID

        {

            get;

            set;

        }

​

        public int Quantity

        {

            get;

            set;

        }

    }

​

    public static void Main()

    {

        string sql = "SELECT TOP 10 OrderDetailID, OrderID, ProductID, Quantity FROM OrderDetails";

        using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))

        {

            connection.Open();

            var orderDetails = connection.Query<OrderDetail>(sql);

            foreach (var order in orderDetails)

            {

                Console.WriteLine("Order Detail ID: {0}, Order ID: {1}, Product ID: {2}, Quantity: {3}", order.OrderDetailID, order.OrderID, order.ProductID, order.Quantity);

            }

            connection.Close();

        }

    }

}