Build CRUD API with Dapper in .NET 9 | ASP.NET Core Web API Tutorial with SQL Server

Published: 29 January 2025
on channel: Poorna Soysa

4,868

141

🐢 Is EF Core slowing you down?
Speed up your inserts by up to 14x and reduce saving time by 94% with Entity Framework Extensions. Enhance performance with support for Bulk Insert, Update, Delete, and Merge — all fully integrated into EF Core. Trusted by 5,000+ developers since 2014.
👉 Check it out here: https://entityframework-extensions.net

In this ASP.NET Core tutorial, you'll learn how to build a CRUD API with Dapper in .NET 9. We’ll walk you through creating a fully functional API using Dapper as the micro ORM, leveraging SQL Server for the database. This video covers key topics like creating endpoints, fetching data, inserting new records, updating products, and deleting records. We’ll also touch on best practices, such as using parameterized SQL queries for security and performance. Don't miss this chance to improve your API development with Dapper and take your ASP.NET Core projects to the next level.

📚 Learn More:
➤ .NET 9 - Implementing Repository Pattern with Minimal API & SQLite | Entity Framework Core Tutorial:    • .NET 9 - Implementing Repository Pattern w...

➤ New LINQ Methods in .NET 9: CountBy, AggregateBy, Index | Beginner-Friendly .NET Tutorial:    • New LINQ Methods in .NET 9: CountBy, Aggre...

Connect with me 👋:

► GITHUB: https://www.github.com/poorna-soysa
► LINKEDIN:   / poorna-soysa
► TWITTER:   / techpoorna

👉 Support my work:
https://www.buymeacoffee.com/poorna.s...

Don't Forget to:
👍 Like this video if you found it helpful
🔔 Subscribe for more coding tutorials
💬 Comment if you have any questions or suggestions

Chapters:
0:00 Intro
0:12 What is Dapper?
0:45 Setting up Projects
0:54 Install NuGet packages
1:20 Implement CRUD Endpoints
1:50 Implement the GetAllProuducts Endpoint
4:50 Implement the CreatProduct Endpoint
6:50 Implement the ProductDbContext
8:54 Implement the GetProductById Endpoint
10:44 Implement the UpdateProductById Endpoint
12:50 Implement the DeleteProductById Endpoint

#aspnetcore #dotnetcore #dapper #dotnet #csharptutorial #aspdotnetcore #csharp

On this page of the site you can watch the video online Build CRUD API with Dapper in .NET 9 | ASP.NET Core Web API Tutorial with SQL Server with a duration of hours minute second in good quality, which was uploaded by the user Poorna Soysa 29 January 2025, share the link with friends and acquaintances, this video has already been watched 4,868 times on youtube and it was liked by 141 viewers. Enjoy your viewing!

3,849

260