DotNet Core MVC CRUD With Dapper

[@goodmantshabalala-ei9vm]

This is quality content nice one jita

[@sm1166]

this video was helpful

[@鄭海寅-s8d]

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

[@hutchm92]

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

[@ravindradevrani]

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

[@SuvedhiniReddiyar]

Thanks a lottt!

[@codingislife6387]

thanks Sir

[@gauravsrivastava8504]

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

[@ravindradevrani]

kzbin.info/www/bejne/oKDJiGBoaq6YrdUsi=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. ( kzbin.info/www/bejne/Y3iZhmZqrM6ZhJYsi=kJbZ24BdSAp0mtjg)

[@Sankets90]

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

[@DennyMapleSyrup]

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]

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]

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

[@cissemy]

Do you recommend Dapper for large application vs EF ?

[@ravindradevrani]

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.

[@sryaan3]

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]

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

[@sryaan3]

How to get my sql server in vs studio

[@ravindradevrani]

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]

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

[@sryaan3]

I'm doing in vs 2022

[@vedadrishilpa8738]

Hello sir, I am actually getting an error when I click on person. Win32Exception: the system cannot find the file specified. SqlException: A network related error occured while establishing a connection to SQL server. The server was not found or not accessible. I am also unable to connect the db

[@ravindradevrani]

It is clearly the DB related error. If it is happening only in this project then your connection string is wrong. But, if you are not even able to open the sql server mgt studio, it might be possible that your sql server service is not running. Please try to find it in google (specially the stack over flow) One solution i find there stackoverflow.com/questions/61757548/how-to-fix-the-system-cannot-find-the-file-specified-error-in-asp-net-mvc-and-sq

[@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.

[@shreyass4394]

I am not able to rename the folder

[@lesedipitoyi2228]

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]

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

[@lesedipitoyi2228]

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

[@ravindradevrani]

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]

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

[@ravindradevrani]

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

[@md.yeasin5214]

❤❤❤❤❤

[@1BY21CS04_CHARANKS]

hellosir my delete button is not working...i tried copying the code from your githuub as well it didnt work can u help me with this

[@ravindradevrani]

I have forgot to add try catch block, add try catch block as i have described below. put the breakpoint in catch block and try to check the value of ex.Message or ex.InnerMessage, you will surely find the error. public async Task Delete(int id) { try{ var deleteResult = await _personRepo.DeleteAsync(id); } catch(Exception ex) { // put breakpoint here and try to check the value of ex.Message or ex.InnerMessage, you will surely find error. } return RedirectToAction(nameof(DisplayAll)); }

[@1BY21CS04_CHARANKS]

@@ravindradevrani actuall i was able to solve it… in personRepository .. we have it as sp_delete_person in github but in sql its sp_delete_people .. so just changing the names made kt work

[@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]

👍

[@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

[@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 kzbin.info/www/bejne/m57dfX2EdtV9hZY 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]

Is it DB First Approch?

[@ravindradevrani]

Yes

[@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]

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]

Sorry, but It's hard to tell

[@nazlimervekilic2377]

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]

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

[@nazlimervekilic2377]

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]

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]

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

[@nazlimervekilic2377]

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