// Dapper

// Doc: https://dapper-tutorial.net/dapper

​

// @nuget: Dapper -Version 1.60.6

​

​

using Dapper;

using System;

using System.Data;

using System.Data.SqlClient;

using System.Collections.Generic;

using Microsoft.Data.SqlClient;

using System.Linq;

​

public class Program

{   

    public static void Main()

    {

        try {

            var cn = String.Concat(FiddleHelper.GetConnectionStringSqlServerW3Schools(), ";TrustServerCertificate=true");

            // using Microsoft.Data.SqlClient.SqlConnection instead of System.Data.SqlClient.SqlConnection

            using (var connection = new Microsoft.Data.SqlClient.SqlConnection(cn))

            {

                var orderDetails = connection.Query<OrderDetail>("SELECT TOP 5 * FROM OrderDetails;").ToList();

                FiddleHelper.WriteTable(orderDetails);

            }

        }

        catch (Microsoft.Data.SqlClient.SqlException  error)

        {

            Console.WriteLine("SqlException: {0}", error);

        }

        catch (ArgumentNullException error)

        {

            Console.WriteLine("ArgumentNullException: {0}", error);

        }

        catch (Exception error)

        {

            Console.WriteLine("Exception: {0}", error.Message);

        }

​

        finally 

        {

            Console.WriteLine("Main code has completed");

        }

    }

    public class OrderDetail

    {

        public int OrderDetailID { get; set; }

        public int OrderID { get; set; }

        public int ProductID { get; set; }

        public int Quantity { get; set; }

    }

​

}

​

​