Using Dapper with .NET Core

IHUB Talent – The Best Full Stack .NET Training Institute in Hyderabad with Live Internship Program

If you're planning to build a rewarding career in software development, then IHUB is the perfect place to begin. Recognized as the best Full Stack .NET training institute in Hyderabad, IHUB offers a complete job-oriented course with a live intensive internship program, guided by real-time industry experts.

Whether you're a graduate, postgraduate, someone with an educational gap, or planning a job domain change, IHUB’s Full Stack .NET course is designed to make you job-ready in just a few months. The program is structured for freshers and working professionals alike, offering hands-on experience and placement support.

🔹 Why Choose IHUB for Full Stack .NET Training?

Expert Faculty: Learn from certified trainers with real-world industry experience.

Live Intensive Internship: Work on actual projects under the guidance of professionals.

Placement Assistance: Resume preparation, mock interviews, and job referrals.

Suitable for All Backgrounds: Freshers, students with gaps, or those changing job domains.

Flexible Learning: Online and offline training options available.

Project-Based Training: Gain hands-on experience by developing end-to-end real-time projects.

Using Dapper with .NET Core – A Lightweight ORM Solution

When building modern .NET Core applications, developers often seek a balance between performance and ease of data access. Dapper, a lightweight micro-ORM developed by Stack Overflow, is a powerful tool that helps achieve just that. Unlike Entity Framework, which abstracts away most SQL, Dapper works directly with raw SQL while still simplifying data mapping to .NET objects.

What is Dapper?

Dapper is a simple object mapper for .NET. It extends IDbConnection and provides a set of extension methods to execute queries and map results to strongly-typed models efficiently. It doesn’t generate SQL — you write it yourself — but it handles the tedious mapping of result sets to objects.

Setting Up Dapper in .NET Core

1. Install Dapper: Add the NuGet package to your project:

   bash
   dotnet add package Dapper
   

2. Configure Database Connection: Use IConfiguration to get your connection string from appsettings.json.

3. Using Dapper in a Repository:

   csharp
   using Dapper;
   using System.Data.SqlClient;
   
   public class UserRepository
   {
       private readonly string _connectionString;
   
       public UserRepository(I Configuration config)
       {
           _connectionString = config.GetConnectionString("DefaultConnection");
       }
   
       public async Task<IEnumerable<User>> GetUsersAsync()
       {
           using var connection = new SqlConnection(_connectionString);
           var sql = "SELECT * FROM Users";
           return await connection.QueryAsync<User>(sql);
       }
   }
   

Why Choose Dapper?

• Performance: Dapper is almost as fast as using raw ADO.NET.

• Simplicity: Write raw SQL while avoiding manual data reader handling.

• Control: Ideal for developers who prefer hand-written SQL over auto-generated queries.

Conclusion

Dapper is a great choice when you need high performance and full control over your SQL in .NET Core apps. It strikes the right balance between raw ADO.NET and full-featured ORMs like EF Core, making it perfect for microservices, APIs, or performance-critical systems. 

Read More

Data Annotations and Fluent API in EF Core

Writing Stored Procedures and Using them in .NET

Code First vs Database First in Entity Framework

Database Migrations using Entity Framework Core

How to Connect ASP.NET Core with SQL Server

Visit Our I-HUB Talent Training Institute Hyderabad