Dapper ORM C# Application

Dapper is a lightweight ORM. Here we will go through an example of connecting Dapper to SQL Server in a C# application.

First, we will create a new Windows Console App:

Go to Tools, NuGet Package Manager:

Search for Dapper and select Install:

You will see the following output:

Next, create a class for the database object you will be connecting to. In our case, we will connect to the Sales.Customers table in the WideWorldImporters database. Select Add->New Item and select Class:

Next, create a connection string to the database:

We can now write code.

Add the following using statements:

using Dapper;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

And add a reference to the SystemConfiguration.dll.

Now, add some code to read from the Sales.Customers table. We can return a list and loop through it to display the results.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Dapper;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
 
namespace Carl.Dapper.Sample1
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLDatabase"].ConnectionString);
            string sql = "select * from Sales.Customers";
 
            using (conn)
            {
                conn.Open();
                var custList = (List<Customers>)conn.Query<Customers>(sql);
                foreach (Customers c in custList)
                {
                    Console.WriteLine(c.CustomerName);
                }
                Console.ReadLine();
            }
 
 
 
        }
    }
}

ABOUT CARL DE SOUZA

Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.com | LinkedIn | Twitter | YouTube