Dapper tutorial with dot net 7 apis | .net core api crud

A brief tutorial about dapper and we are implementing here .net 7 APIs CRUD operations with dapper and sql server.
What is dapper?
🖋 Dapper is a micro ORM (object relation mapper)to connect with database from your .NET application.
🖋 Dapper is lightweight and high performance ORM.
🖋 Dapper is much faster than entity framework.
🖋 If you want to follow code first approach in .dot net core and you feel much comfortable with queries and stored procedures, this framework will be good choice for you.
📎Source code: drive.google.c...
📎Dapper documentation on github:
github.com/Dap...
Hit the 👍 if you like the video.
.................
Please share this video to your circle to support me.
Other links:
▶Blazor Courses: • Blazor server crud tut...
▶Single video courses: • Asp.net core mvc (7.0 ...
▶Angular tutorials and projects: bit.ly/3DitqDp
▶dot net 6 tutorials and projects: bit.ly/3MSrXGX
▶dot net core series: bit.ly/3TolF4i
▶Learn projects from scratch: bit.ly/3zpn9ng
.......................................................
connect with me
🔗Twitter: / ravi_devrani
🔗GitHub: github.com/rd003
🔗RUclips: / @ravindradevrani
..........................................
#dapperdotnet #dapperorm #dotnet7 #dotnetcore #webapi

[@GovindSingh-em1iy]

Thanku very much for the tutorial which I have requested for DB first approach..

[@ravindradevrani]

Welcome... But that was already on my tutorials list..i hope it will be helpful

[@hasanatk5477]

Thank you sir, very nice content

[@iosaroj]

1. How to implement generic update statements if the model has many(like 30+) properties?
2. How to implement patch scenarios for specific properties as mostly patch is used instead of update?

[@girigoudars3282]

Common DataAccess later stored procedure function?

[@nizamuddin1139]

thanks Sir. Please make E-commerce Project using Dapper-Micro ORM and CRQS Pattern and Mediator Pattern this Project

[@ravindradevrani]

Sorry i don't have any expertese in cqrs and mediator. That's why i have never made a video on that.

[@codingislife6387]

Please Please Please Reply sir. Please may u live long.
thanks Sir. Please make E-commerce Project using Dapper-Micro Archetechter .

[@varshashekar2797]

Can anyone tell me how to run this project in web browser

[@ravindradevrani]

It is api project. You need a client to test this project.
You can use postman to test endpoints or you can use swagger ui to test it in browser, i guess swagger should be integrated with this project.

[@nizamuddin1139]

using store procedure Dapper tutorial with dot net 7 apis

[@cissemy]

How t return Id from AddPerson ?
Thanks

[@ravindradevrani]

public async Task AddTodoItem(TodoItem item)
{
using IDbConnection connection = new SqlConnection(_connectionString);
string sql = "insert into TodoItem(Description,IsCompleted) values(@Description,@IsCompleted); select SCOPE_IDENTITY()";
int createdId = await connection.ExecuteScalarAsync(sql, new { item.Description, item.IsCompleted });
item.Id = createdId;
return item;
}

[@cissemy]

Thanks

[@sryaan3]

how to install vs studio 2022 and what we should select after downloading

[@ravindradevrani]

ruclips.net/video/fA-zujqZlS0/видео.htmlsi=xVPVW9OgOMZSa75l

[@sryaan3]

Ty

[@sryaan3]

How to install mysql

[@kakdiyaamit6625]

can u create small webapi project [ Login, Register, Token, order and order Details] using dapper?

[@ravindradevrani]

It won't be small. To authenticate the app using dapper, use auth0 okta or azure ad b2c.

[@KuldeepBisht_KD]

@@ravindradevraniHave you made any videos related to .net core web api using dapper and JWT token? Please guide. I want .net core web api using jwt token authentication and .net core web application as UI.

[@ravindradevrani]

Not using dapper, but busing EF core. Dapper alone does not provide any authentication solution like ef core identity.
ruclips.net/video/g2WHURQObzQ/видео.html

[@cissemy]

Great Job.
How to do pagination using Dapper?

[@ravindradevrani]

Write some query with fetch offset...

[@minirai2936]

What are the software we have to download and start this sir can u pls give with proper number like 2019 or etc

[@ravindradevrani]

Visual studio 2022
And any version of sql sever + sql server management studio will be fine

[@minirai2936]

Sir TQ

[@minirai2936]

And I am facing more problems in installing software so pls can u help me out in easy way to create this project

[@ravindradevrani]

Are you not able to install visual studio?

[@faisalusmani692]

make a video to integrate this api with react js

[@ravindradevrani]

I don't have sufficient knowledge of react js.

[@jopaji]

why are you creating two projects???

[@ravindradevrani]

So that we can separate ui and business logic. It's more maintainable. Any changes in business logic won't effect ui layer.

[@ravindradevrani]

Don't worry, you will learn eventually.
In big application you have to add multiple projects.