DotNet Core MVC CRUD With Dapper
Вставка
- Опубліковано 19 бер 2023
- 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
👉 UA-cam: / @ravindradevrani
👉 Twitter: / ravi_devrani
👉 GitHub: github.com/rd003
..........................................
Become a supporter ❣️:
You can buy me a coffee 🍵 : www.buymeacoffee.com/ravindra...
................................................
#dotnet7 #dapper #dotnetcore
This is quality content nice one jita
I really appreciate your kind example lecture.
I expect CRUD processing of jQuery DataTables with jQuery next. Thanks!
this video was helpful
hello sir , how to pass multiple data in a single datatable from POST API to table valued parameter stored procedure ?
thanks Sir
❤❤❤❤❤
I am not able to rename the folder
What about database stored procedures
This is an excellent video. I would only suggest to add chapters to easily navigate back to concepts or steps to review.
I would appreciate, if someone give some timestamps. 🙏🏽🙂
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?
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.
😃 don't be too harsh on yourself.
It happens all the time.
Good video but one suggestion, could you please add search filters in display all records , Search filter (multiple search at a time)
ua-cam.com/video/jofW-25Iews/v-deo.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.
( ua-cam.com/video/-G6U34wifN4/v-deo.htmlsi=kJbZ24BdSAp0mtjg)
Do you recommend Dapper for large application vs EF ?
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.
Hello sir, I am getting an error
Whenever i am trying to add new person it is not getting added in the data
Put a break point and try to look into error msg
Hello Sir, please make a video on menus using database. Thank you!
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.
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
You have to register your service in program.cs .
Services.AddTransient()
@@ravindradevrani I did add that as one of the builders
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.
@@ravindradevrani still no progress did you post the project anywhere by any chance so that I can troubleshoot mine using yours
Yes...
I always provide source code. Link is available in the description.
Sir why didn't you register connection string in program.cs file?
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.
@@ravindradevrani thank you sir👍
👍
Can you make a video for mapping model to view and view to model.
what does it mean ' mapping model to view and view to model'
@@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.
Making viewModel and mappers to map to model.
Yeah yeah...i understand.. you are talking about automappers
I already have created a video
ua-cam.com/video/emzLJNApJO4/v-deo.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.
@@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.
Is it DB First Approch?
Yes
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
There would a .sln file..click on it.
It will automatically open on visual studio.
How to get my sql server in vs studio
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
Thank you so much for your response I'm very grateful I'm not getting appsetings.json
I'm doing in vs 2022
Hello sir you video is good cab i get the source code of the project
yeah i always provide source code in every video.
Find the Link is in the description.
Sir the link is not working
Ok..i have to see, why it is not working. I will notify when its updated
I have accidentally created a private repository, thanks for noticing. Now everything is working fine.
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
Sorry, but It's hard to tell
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?
Command should be
Create procedure sp_update_person(
......
)
You are missing the term "create"
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
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
table's names are id, name, email, address @@ravindradevrani
okey sir, i found the mistake. thank you@@ravindradevrani