// @nuget: Dapper -Version 1.60.6

// @nuget: Dapper.Contrib

// @nuget: System.Data.SqlClient

​

using Dapper;

using Dapper.Contrib.Extensions;

using System.Data.SqlClient;

using System.Linq;

​

public class Program

{

    public class OrderDetail

    {

        [Key]

        public int OrderDetailID { get; set; }

        public int OrderID { get; set; }

        public int ProductID { get; set; }

        public int Quantity { get; set; }

    }

    public static void Main()

    {

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

        {   

            // GET

            var orderDetail = connection.Get<OrderDetail>(1);

            FiddleHelper.WriteTable(new OrderDetail[] { orderDetail });

            // UPDATE

            orderDetail.Quantity++;

            connection.Update(orderDetail);

            FiddleHelper.WriteTable(new OrderDetail[] { connection.Get<OrderDetail>(1) });

            // DELETE

            connection.Delete(orderDetail);

​

            FiddleHelper.WriteTable( connection.GetAll<OrderDetail>());

        }

    }

}