Regardless of the scale of the project, efficient data access is critical in software development. Maintaining performance and scalability requires proper handling of database interactions. Dapper.NET is a lightweight Object-Relational Mapping (ORM) framework for.NET applications that streamlines data access. We’ll present practical examples in this article to help you understand Dapper.NET and how it can help you optimize your data access code.

Introducing Dapper.NET

Dapper.NET, created by the Stack Overflow team, aims to offer speedy and efficient data access for .NET applications. Unlike certain ORM frameworks, Dapper.NET values straightforwardness and optimal performance. Before we delve into examples, let’s take a closer look at some of its essential features.

Key Features of Dapper.NET

• Speed: Dapper.NET’s emphasis on performance sets it apart from numerous other ORM frameworks, making it significantly faster.
• Lightweight: The design of the framework is minimalist, which helps to reduce complexity and overhead.
• Raw SQL Support: With Dapper.NET, you can create and run unprocessed SQL queries.
• Object Mapping: The tool maps query results to .NET objects automatically, minimizing the need for manual data manipulation.
• Dynamic Parameters: Dapper.NET enables the use of parameterized queries to enhance security and efficiency.
• Multiple Result Sets: The system can effortlessly manage requests that produce multiple sets of results.
• Stored Procedure Support: Stored procedures are compatible with Dapper.NET.

Getting Started with Dapper.NET: Examples 

To better understand how Dapper.NET can make data access easier, let’s explore some practical examples.

Example 1. Basic Query

Suppose we have a simple database table named Products with columns ProductId, ProductName, and Price. We want to retrieve all products from the database.

1. Install Dapper: Install the Dapper package via NuGet.
2. Create Connection: Establish a connection to your database. For this example, we’ll use SQL Server.
3. Write Query and Retrieve Data:
   <span class="token keyword keyword-using">using</span> <span class="token namespace">System</span><span class="token punctuation">;</span> <span class="token keyword keyword-using">using</span> <span class="token namespace">System<span class="token punctuation">.</span>Data<span class="token punctuation">.</span>SqlClient</span><span class="token punctuation">;</span> <span class="token keyword keyword-using">using</span> <span class="token namespace">Dapper</span><span class="token punctuation">;</span> <span class="token keyword keyword-class">class</span> <span class="token class-name">Program</span> <span class="token punctuation">{</span> <span class="token keyword keyword-static">static</span> <span class="token return-type class-name"><span class="token keyword keyword-void">void</span></span> <span class="token function">Main</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token class-name"><span class="token keyword keyword-string">string</span></span> connectionString <span class="token operator">=</span> <span class="token string">"your_connection_string"</span><span class="token punctuation">;</span> <span class="token keyword keyword-using">using</span> <span class="token punctuation">(</span><span class="token class-name"><span class="token keyword keyword-var">var</span></span> connection <span class="token operator">=</span> <span class="token keyword keyword-new">new</span> <span class="token constructor-invocation class-name">SqlConnection</span><span class="token punctuation">(</span>connectionString<span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> connection<span class="token punctuation">.</span><span class="token function">Open</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token class-name"><span class="token keyword keyword-var">var</span></span> products <span class="token operator">=</span> connection<span class="token punctuation">.</span><span class="token generic-method"><span class="token function">Query</span><span class="token generic class-name"><span class="token punctuation">&lt;</span>Product<span class="token punctuation">&gt;</span></span></span><span class="token punctuation">(</span><span class="token string">"SELECT * FROM Products"</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token keyword keyword-foreach">foreach</span> <span class="token punctuation">(</span><span class="token class-name"><span class="token keyword keyword-var">var</span></span> product <span class="token keyword keyword-in">in</span> products<span class="token punctuation">)</span> <span class="token punctuation">{</span> Console<span class="token punctuation">.</span><span class="token function">WriteLine</span><span class="token punctuation">(</span><span class="token interpolation-string"><span class="token string">$"</span><span class="token interpolation"><span class="token punctuation">{</span><span class="token expression language-csharp">product<span class="token punctuation">.</span>ProductId</span><span class="token punctuation">}</span></span><span class="token string">: </span><span class="token interpolation"><span class="token punctuation">{</span><span class="token expression language-csharp">product<span class="token punctuation">.</span>ProductName</span><span class="token punctuation">}</span></span><span class="token string"> - $</span><span class="token interpolation"><span class="token punctuation">{</span><span class="token expression language-csharp">product<span class="token punctuation">.</span>Price</span><span class="token punctuation">}</span></span><span class="token string">"</span></span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token punctuation">}</span> <span class="token punctuation">}</span> <span class="token punctuation">}</span> <span class="token keyword keyword-class">class</span> <span class="token class-name">Product</span> <span class="token punctuation">{</span> <span class="token keyword keyword-public">public</span> <span class="token return-type class-name"><span class="token keyword keyword-int">int</span></span> ProductId <span class="token punctuation">{</span> <span class="token keyword keyword-get">get</span><span class="token punctuation">;</span> <span class="token keyword keyword-set">set</span><span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token keyword keyword-public">public</span> <span class="token return-type class-name"><span class="token keyword keyword-string">string</span></span> ProductName <span class="token punctuation">{</span> <span class="token keyword keyword-get">get</span><span class="token punctuation">;</span> <span class="token keyword keyword-set">set</span><span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token keyword keyword-public">public</span> <span class="token return-type class-name"><span class="token keyword keyword-decimal">decimal</span></span> Price <span class="token punctuation">{</span> <span class="token keyword keyword-get">get</span><span class="token punctuation">;</span> <span class="token keyword keyword-set">set</span><span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token punctuation">}</span>

   1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

   <span class="token keyword keyword-using">using</span> <span class="token namespace">System</span><span class="token punctuation">;</span> <span class="token keyword keyword-using">using</span> <span class="token namespace">System<span class="token punctuation">.</span>Data<span class="token punctuation">.</span>SqlClient</span><span class="token punctuation">;</span> <span class="token keyword keyword-using">using</span> <span class="token namespace">Dapper</span><span class="token punctuation">;</span>   <span class="token keyword keyword-class">class</span> <span class="token class-name">Program</span> <span class="token punctuation">{</span>     <span class="token keyword keyword-static">static</span> <span class="token return-type class-name"><span class="token keyword keyword-void">void</span></span> <span class="token function">Main</span><span class="token punctuation">(</span><span class="token punctuation">)</span>     <span class="token punctuation">{</span>         <span class="token class-name"><span class="token keyword keyword-string">string</span></span> connectionString <span class="token operator">=</span> <span class="token string">"your_connection_string"</span><span class="token punctuation">;</span>           <span class="token keyword keyword-using">using</span> <span class="token punctuation">(</span><span class="token class-name"><span class="token keyword keyword-var">var</span></span> connection <span class="token operator">=</span> <span class="token keyword keyword-new">new</span> <span class="token constructor-invocation class-name">SqlConnection</span><span class="token punctuation">(</span>connectionString<span class="token punctuation">)</span><span class="token punctuation">)</span>         <span class="token punctuation">{</span>             connection<span class="token punctuation">.</span><span class="token function">Open</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>             <span class="token class-name"><span class="token keyword keyword-var">var</span></span> products <span class="token operator">=</span> connection<span class="token punctuation">.</span><span class="token generic-method"><span class="token function">Query</span><span class="token generic class-name"><span class="token punctuation">&lt;</span>Product<span class="token punctuation">&gt;</span></span></span><span class="token punctuation">(</span><span class="token string">"SELECT * FROM Products"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>               <span class="token keyword keyword-foreach">foreach</span> <span class="token punctuation">(</span><span class="token class-name"><span class="token keyword keyword-var">var</span></span> product <span class="token keyword keyword-in">in</span> products<span class="token punctuation">)</span>             <span class="token punctuation">{</span>                 Console<span class="token punctuation">.</span><span class="token function">WriteLine</span><span class="token punctuation">(</span><span class="token interpolation-string"><span class="token string">$"</span><span class="token interpolation"><span class="token punctuation">{</span><span class="token expression language-csharp">product<span class="token punctuation">.</span>ProductId</span><span class="token punctuation">}</span></span><span class="token string">: </span><span class="token interpolation"><span class="token punctuation">{</span><span class="token expression language-csharp">product<span class="token punctuation">.</span>ProductName</span><span class="token punctuation">}</span></span><span class="token string"> - $</span><span class="token interpolation"><span class="token punctuation">{</span><span class="token expression language-csharp">product<span class="token punctuation">.</span>Price</span><span class="token punctuation">}</span></span><span class="token string">"</span></span><span class="token punctuation">)</span><span class="token punctuation">;</span>             <span class="token punctuation">}</span>         <span class="token punctuation">}</span>     <span class="token punctuation">}</span> <span class="token punctuation">}</span>   <span class="token keyword keyword-class">class</span> <span class="token class-name">Product</span> <span class="token punctuation">{</span>     <span class="token keyword keyword-public">public</span> <span class="token return-type class-name"><span class="token keyword keyword-int">int</span></span> ProductId <span class="token punctuation">{</span> <span class="token keyword keyword-get">get</span><span class="token punctuation">;</span> <span class="token keyword keyword-set">set</span><span class="token punctuation">;</span> <span class="token punctuation">}</span>     <span class="token keyword keyword-public">public</span> <span class="token return-type class-name"><span class="token keyword keyword-string">string</span></span> ProductName <span class="token punctuation">{</span> <span class="token keyword keyword-get">get</span><span class="token punctuation">;</span> <span class="token keyword keyword-set">set</span><span class="token punctuation">;</span> <span class="token punctuation">}</span>     <span class="token keyword keyword-public">public</span> <span class="token return-type class-name"><span class="token keyword keyword-decimal">decimal</span></span> Price <span class="token punctuation">{</span> <span class="token keyword keyword-get">get</span><span class="token punctuation">;</span> <span class="token keyword keyword-set">set</span><span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token punctuation">}</span>

Example 2. Parameterized Query

Let’s retrieve products within a certain price range using a parameterized query.

Example 3. Working with Stored Procedures

Dapper.NET shines when it comes to interacting with stored procedures. Suppose we have a stored procedure named GetProductsByCategory that retrieves products based on a given category.

Conclusion

As a developer, you can benefit from Dapper.NET, which is a lightweight and efficient solution for data access. It provides a performance-oriented approach and supports raw SQL queries and stored procedures, making it an excellent tool in your .NET development toolbox.

In this article, we will explore practical examples of using Dapper.NET, including basic queries, parameterized queries, and working with stored procedures. By embracing Dapper.NET’s simplicity and performance, you can optimize your data access code, resulting in more efficient and maintainable applications.

Regardless of the size of your project, Dapper.NET’s ability to streamline data access will have a positive impact on your development workflow. Try it out and see for yourself how Dapper.NET simplifies the journey from database to application.

Select the Top ASP.NET Website Hosting

HostForLIFE.eu  is recognized as one of the Best, Cheap WordPress Web Hosting Providers in UK. You can always start from their start from €3.49/month and this plan has supported WordPress, Joomla, Drupal, Umbraco, etc, with a one-click installer within less than 5 minutes. They provide cheap, best and instant activation on your WordPress hosting account with UNLIMITED Bandwidth, disk space and Domain.