DotNet Core MVC CRUD With Dapper

No video

DotNet Core MVC CRUD With Dapper

Рет қаралды 19,230

Жыл бұрын

dapper tutorial with stored procedures
asp.net core mvc crud with db first approach
.net 6 mvc tutorials for beginners
.net 7 mvc tutorial for beginners
.net core mvc tutorial for beginners
(just ingore above tags)
📎Source code: github.com/rd003/Dapper-With-...
dot net core 6/7 playlist: bit.ly/3TolF4i
Hit the 👍 if you like the video.
.................
Please share this video to your circle to support me.
....................
connect with me
👉 KZfaq: / @ravindradevrani
👉 Twitter: / ravi_devrani
👉 GitHub: github.com/rd003
..........................................
Become a supporter ❣️:
You can buy me a coffee 🍵 : www.buymeacoffee.com/ravindra...
................................................
#dotnet7 #dapper #dotnetcore

Пікірлер: 77

@user-es1bd7ig8y Жыл бұрын

I really appreciate your kind example lecture. I expect CRUD processing of jQuery DataTables with jQuery next. Thanks!

@goodmantshabalala-ei9vm 3 ай бұрын

This is quality content nice one jita

@sm1166 Жыл бұрын

this video was helpful

@codingislife6387 8 ай бұрын

thanks Sir

@md.yeasin5214 Жыл бұрын

❤❤❤❤❤

@theAdventurersWorld Жыл бұрын

hello sir , how to pass multiple data in a single datatable from POST API to table valued parameter stored procedure ?

@hutchm92 5 ай бұрын

This is an excellent video. I would only suggest to add chapters to easily navigate back to concepts or steps to review.

@ravindradevrani 5 ай бұрын

I would appreciate, if someone give some timestamps. 🙏🏽🙂

@DennyMapleSyrup 7 ай бұрын

I’m getting an “AmbiguousMatchException” because of the overloaded edit function. Any ideas what might be causing this? Just like your example I have one with an int id as a parameter and one with a Person person parameter. Also why does there need to be 2 separate edit functions? Can you not put all the functionality into one where the input is just the id?

@DennyMapleSyrup 7 ай бұрын

Update: I’m an idiot. I forgot to put [HttpPost] before the second edit function. If you are having the same issue, highly recommend you try this fix.

@ravindradevrani 7 ай бұрын

😃 don't be too harsh on yourself. It happens all the time.

@gauravsrivastava8504 5 ай бұрын

Good video but one suggestion, could you please add search filters in display all records , Search filter (multiple search at a time)

@ravindradevrani 5 ай бұрын

kzfaq.info/get/bejne/oNWWipBjmq_Jp6c.htmlsi=kVtUk1Rbg4FnRhJ8 At this project you can find search filter with dapper, but it is a blazor server project. But you can find some logic there. Project link will be in description of video. 2nd project in mvc with ef core. Here u can find filter, pagination, sorting etc. ( kzfaq.info/get/bejne/Y61miJZl3M_Kfmg.htmlsi=kJbZ24BdSAp0mtjg)

@shreyass4394 26 күн бұрын

I am not able to rename the folder

@cissemy 4 ай бұрын

Do you recommend Dapper for large application vs EF ?

@ravindradevrani 4 ай бұрын

Both are fine. But with dapper alone you can't use identity for authentication. You have to use 3rd party auth system like okta/azure.

@mayur2021 Жыл бұрын

Hello Sir, please make a video on menus using database. Thank you!

@ravindradevrani Жыл бұрын

hahaha... hey, it should not be that much bigger deal, if you are following my project-based tutorial for a while or have the understanding of database design, it won't be a big deal. Just create table, Menu (Id, Title,ParentMenu_Id, PageLink) , display it in a page. You have to use self-join, if you are creating nested menus.

@abhijeetkale5853 Жыл бұрын

What about database stored procedures

@chiragpadhyal9394 Жыл бұрын

Hello sir, I am getting an error Whenever i am trying to add new person it is not getting added in the data

@ravindradevrani Жыл бұрын

Put a break point and try to look into error msg

@lesedipitoyi2228 3 ай бұрын

An unhandled exception occurred while processing the request. InvalidOperationException: Unable to resolve service for type 'DapperDemo.DataLayer.Repository.PersonRepository' while attempting to activate 'DapperDemo.UI.Controllers.PersonController'. I did the project as you did but it keeps on throwing the above error when I click on Person on the NavBar.Can I please get some assistance on how to correct it

@ravindradevrani 3 ай бұрын

You have to register your service in program.cs . Services.AddTransient()

@lesedipitoyi2228 3 ай бұрын

@@ravindradevrani I did add that as one of the builders

@ravindradevrani 3 ай бұрын

It looks like dependency injection related problem to me. Please checkout these links code-maze.com/dotnet-how-to-solve-unable-to-resolve-service-for-a-type/ stackoverflow.com/questions/40900414/dependency-injection-error-unable-to-resolve-service-for-type-while-attempting Notify me, about the situation after this.

@lesedipitoyi2228 3 ай бұрын

@@ravindradevrani still no progress did you post the project anywhere by any chance so that I can troubleshoot mine using yours

@ravindradevrani 3 ай бұрын

Yes... I always provide source code. Link is available in the description.

@faisalusmani692 Жыл бұрын

Sir why didn't you register connection string in program.cs file?

@ravindradevrani Жыл бұрын

If you define connection string in apsettings.json then in future,you can change it without recompiling the code. You can define connection strings specific to different environments such as development, testing, and production. This allows you to easily switch between different databases or servers based on the environment without modifying the code.

@faisalusmani692 Жыл бұрын

@@ravindradevrani thank you sir👍

@ravindradevrani Жыл бұрын

👍

@badriaran1943 Жыл бұрын

Can you make a video for mapping model to view and view to model.

@ravindradevrani Жыл бұрын

what does it mean ' mapping model to view and view to model'

@badriaran1943 Жыл бұрын

@@ravindradevrani implementation of mappers. For example sometimes we may have model which are not directly mapped to database ex. Maybe iform file(images) which are not stored in database but its path will be stored. So making model for view purposes one and for database purpose another. And connecting them to each other.

@badriaran1943 Жыл бұрын

Making viewModel and mappers to map to model.

@ravindradevrani Жыл бұрын

Yeah yeah...i understand.. you are talking about automappers I already have created a video kzfaq.info/get/bejne/m9Oqf61_ptauf2g.html it is a short one, but it is in .net core 3.0 and does not have any sound. You have to do little bit of modification in program.cs file. May be i will create .net 7 version of it.

@badriaran1943 Жыл бұрын

@@ravindradevrani okay thank you in advance. You can make a full video on Mysql queries from beginner to Ultima level including join queries. . It would be so helpful for beginners like me.

@delightful730 8 ай бұрын

Is it DB First Approch?

@ravindradevrani 8 ай бұрын

Yes

@sryaan3 6 ай бұрын

How to extract code from github ... I've downloaded to pc and in next procedure in visual studio 2022 I'm not able to open only ... can you guide me

@ravindradevrani 6 ай бұрын

There would a .sln file..click on it. It will automatically open on visual studio.

@sryaan3 6 ай бұрын

How to get my sql server in vs studio

@ravindradevrani 6 ай бұрын

In connection string, Change the server name according to ur SQL server instance name .. you will find it before logging it to sql sever mgt studio

@sryaan3 6 ай бұрын

Thank you so much for your response I'm very grateful I'm not getting appsetings.json

@sryaan3 6 ай бұрын

I'm doing in vs 2022

@mushaffiq457 Жыл бұрын

Hello sir you video is good cab i get the source code of the project

@ravindradevrani Жыл бұрын

yeah i always provide source code in every video. Find the Link is in the description.

@mushaffiq457 Жыл бұрын

Sir the link is not working

@ravindradevrani Жыл бұрын

Ok..i have to see, why it is not working. I will notify when its updated

@ravindradevrani Жыл бұрын

I have accidentally created a private repository, thanks for noticing. Now everything is working fine.

@glrithika8276 9 ай бұрын

DapperMvcDemo.Data.DataAccess.SqlDataAccess.GetData(string spName, P parameters, string connectionId) in SqlDataAccess.cs + IEnumerable enumerable = await connection.QueryAsync(spName, parameters, commandType: CommandType.StoredProcedure); DapperMvcDemo.Data.Repository.PersonRepository.GetAllAsync() in PersonRepository.cs + return await _db.GetData(query, new { }); DapperMvcDemo.UI.Controllers.PersonController.DisplayAll() in PersonController.cs + IEnumerable people = await _personRepo.GetAllAsync(); sir why do i keep getting this error? ..it shows internal server error in these statements

@ravindradevrani 9 ай бұрын

Sorry, but It's hard to tell

@nazlimervekilic2377 9 ай бұрын

Hi sir, i can't create this=> procedure sp_update_person( @id int, @name nvarchar(100), @email nvarchar(100), @address nvarchar(200) ) as begin update dbo.Person set name=@name, email=@email, [address]=@address where id=@id end Why?

@ravindradevrani 9 ай бұрын

Command should be Create procedure sp_update_person( ...... ) You are missing the term "create"

@nazlimervekilic2377 9 ай бұрын

i write that create procedure sp_update_person( @id int, @name nvarchar(100), @email nvarchar(100), @address nvarchar(200) ) as begin update dbo.Person set name=@name, email=@email, [address]=@address where id=@id end but it does not. mistake is = Msg 207, Level 16, State 1, Procedure sp_update_person, Line 11 [Batch Start Line 0] Invalid column name 'id'. @@ravindradevrani

@ravindradevrani 9 ай бұрын

Can you check the definition of table "person". Error is indicating that it is missing the column id... Just run the query select * from person And check it have a column 'id' or not

@nazlimervekilic2377 9 ай бұрын

table's names are id, name, email, address @@ravindradevrani

@nazlimervekilic2377 9 ай бұрын

okey sir, i found the mistake. thank you@@ravindradevrani