CRUD with Dapper in a .NET 6 Web API using SQL Server 🚀

📚 My .NET & Blazor Udemy Courses:

📑 Table of Contents:
00:00 CRUD with Dapper in a .NET 6 Web API using SQL Server 🚀
02:04 Create a Web API Project
03:22 Install NuGet Packages (Dapper & SqlClient)
05:45 Add the SuperHero Class
06:36 Creat the SuperHeroController
08:02 Add the Connection String
09:14 GET all Super Heroes
13:12 GET a single Super Heroes
16:26 Create a Super Hero with POST
20:42 Update a Super Hero with PUT
23:45 DELETE a Super Hero

#DotNet #Dapper #PatrickGod

[Artmageddon]

I have to say I've been a fan of Dapper and was waiting for something like this for a long time! Keep up the great work!

[neevar]

Thank you Patrick, I was eagerly waiting for this.

[haihai]

This is soo quick and its working.... Thank You.

[justinosagie]

Thank you for the helpful video! You made everything easy to follow understand

[AbrahamWilson]

Thank you so much, for creating this.

[aussieraver]

One good thing I realised about Dapper over EF core is that when you use it in your portfolio projects for interviews, it proves that you understand at least the basics of SQL as opposed to just using LINQ and treating the SQL Server as a black box.

[name_nayan]

Hi Patrick, thanks for this wonderful and informative video. Really appreciate man. ❤

[SaroopJack]

ive been trying to find a basic crud api with dapper for almost 3 days and finally, you saved me bro.

[yasminarab]

Dapper !!! that what i am waiting for. Thanks you are reading my mind 😊😊

[edwintorres]

It looks nice with that simple exercise but how about handle CRUD with multiple tables and using Commit and Rollback and Stored Procedures. Thnx a lot Patrick!!!!

[adriandegenaar]

Hi Patrick,
Great tutorials, they have help me quite a bit. I wanted to know if there will be a wasm server/client side logging tutorial?

[fanzfanzilla]

Thank you for the video. Do you have a follow up video that shows calling the Dapper API in razor pages simple CRUD application? That will be very helpful to see the whole thing in action.

[nelsonrivers]

Thank you. Just an FYI, one issue that came up in the last company I worked at for 5 years was when they decided to go with "Dapper", there were "concurrency issues" that arose.
We had to go back and address that. We had to do "special coding" to handle concurrency issues". Can you create an additional video that shows how to handle "concurrency issues" that can arise when using Dapper to do update operations ?

[luis.e.moreno]

Hey Patrick! Thank you, this video is pretty good! Could you please make one about DTOs? Thanks again!

[bengi]

Hi Patrick great video,
I was wondering could've you use string interpolation in GetById endpoint so the query would go like:
var hero = await * from testing where id = {heroId}");

[jamesscott]

Hi Patrick, I believe I can replace the coded sql with a stored procedure call for it to as well work

[daniel_klement_photography]

This is great, I already use this method with MS SQL and Entity Framework Core but what I miss, can you please make some tutorial what is thd best way with authorization user from Blazor (Server) and API like this? I have some method done but I am not sure if it is 100% correct

[hhadid]

When you reached the update saying that's it, I said where where where 😆😆, but then you noticed it was missing 😆😆

[guillermomazzari]

Thanks for sharing, but I think it would add a lot if you used interfaces and services, put the connection string on it's own class and injected in the program.cs and create the store procedures in sql, writing sql statements on visual studio is a huge open door for sql injection, you are a good teacher, but it would be much better if you would show complete examples of the tools, just a comment

[faizanhusain]

Can any one suggest? Dapper or EFCore? & Why?