CRUD without Entity Framework in ASP.NET Core MVC

Рет қаралды 103,075

Күн бұрын

ASP.NET Core MVC CRUD Operations without Entity Framework
In this ASP.NET Core MVC tutorial, we'll implement CRUD operations using stored procedures without entity framework. We've connected to the database using ADO.NET and all of the CRUD operations insert, update, delete, and retrieve are implemented with the help of stored procedure.
Main Points Discussed :
- Connect to SQL Server without EF
- Easy way to create .NET Core MVC Controller
- Created Stored Procedures for CRUD Operations
- Executed above Stored Procedures from .NET Core MVC
Discussion @ Time
___________________
00:00 - Intro
01:20 - Create Database
03:06 - Create ViewModel
04:09 - Create Controller
10:24 - Form Design for Insert & Update Operations
15:56 - Form Validation
19:41 - Stored Procedure for CRUD Operations
22:10 - Insert Operation
30:51 - Retrieve Operation
35:39 - Update Operation
41:01 - Delete Operation
📂 GitHub Repository
► bit.ly/3jHg3zN
💖 Buy me a Coffee
PayPal: bit.ly/3L36ut4
UPI/QR Code Scan: geni.us/ScanQRCode
🌀 Related Videos
bit.ly/36IA1cH : MVC CRUD with Entity Framework
goo.gl/T9Nb8r : Angular CRUD with Web API
goo.gl/wp17ta : Angular User Registration With Web API
goo.gl/4gDFfC : Angular Login Logout With Web API
goo.gl/ySUFf8 : Similar MVC Tutorials
🔗 Find me in
Udemy : bit.ly/3RtyQSB
Facebook : / codaffection
GitHub : github.com/codaffection
Discord : / discord
Twitter : / codaffection
#AspNetCore #EntityFramework #CodAffection

Пікірлер: 70

@CodAffection 3 жыл бұрын

goo.gl/RFY5C2 : Subscribe to CodAffection goo.gl/bPcyXW : Buy me a Coffee bit.ly/2HcyCLD : MVC CRUD with Entity Framework goo.gl/T9Nb8r : Angular CRUD with Web API goo.gl/wp17ta : Angular User Registration With Web API goo.gl/4gDFfC : Angular Login Logout With Web API goo.gl/ySUFf8 : Similar MVC Tutorials

@BawzGames 2 жыл бұрын

You can be proud of this tutorial, so clear and well paced

@MrCoolsay Жыл бұрын

Boom!, your guide is really helpful, short, concise, and simple to follow

@mulegilbert 3 жыл бұрын

Thanks a lot for this. Really helped

@jaybharatjay 3 жыл бұрын

This is second video I am watching from your published. I can say you are doing very very hard work to make things simple. Really nice work you are doing for us. Thanks very much.

@CodAffection 3 жыл бұрын

Thanks for your wonderful feedback.

@danishhussainomex7896 Жыл бұрын

Booooooom...! This is all I was looking for, Thank you for such a details and professional Tutorial. It is really appreciated.

@CodAffection Жыл бұрын

Glad you enjoyed it!

@manuelvalenzuela399 2 жыл бұрын

Excellent!

@RicardoAmaro123 2 жыл бұрын

Excelent video tutorial!

@nadyarahmalestanti7202 3 жыл бұрын

thank u, u are amazing mr!!!!

@SurajSharma-qv8jx Жыл бұрын

Nice tutorial !! I love the way you are explaining.

@CodAffection Жыл бұрын

Glad to hear.

@nayakmanisha1320 2 жыл бұрын

Awesome thank you 🙏

@MohammedRabeeh-rq6eo Жыл бұрын

Thank you so much for this tutorial. It really worked.

@CodAffection Жыл бұрын

Glad to hear that.

@maxmaraval1461 3 жыл бұрын

Thank you very much. you are a magician : when you say boooom !!!

@CodAffection 3 жыл бұрын

@mi5956 3 жыл бұрын

Thank you, perfect on time, I will buy you a coffee

@CodAffection 3 жыл бұрын

Much appreciated!

@atreyamehta4759 3 жыл бұрын

Thank You So Much......

@pedrolustosa5840 3 жыл бұрын

You''re a fantastic teacher. A hug from brazil. Master, are you can teach understand ModelViews ?

@spusystemprogrammer3327 Жыл бұрын

Thank you

@reazurrahman3515 3 жыл бұрын

Very nice👍👍

@ShebinlalIT 11 ай бұрын

gud explanation

@tiseysoft5504 3 жыл бұрын

Good

@Tty490 11 ай бұрын

Thanks!

@CodAffection 11 ай бұрын

Really appreciated. thank you so much.

3 жыл бұрын

Thank you. Please continue to this video for relational data like Book Category and an other video for paging, sorting and filtering. Next add repository pattern for CRUD operations. It will be a good referance for beginners. And a good alternatif for EF is Dapper.

@ibrahimal-habian4796 2 жыл бұрын

Thank you brother , It's clear and simple tutotrial at all . Hot to make select list or dropdown list using stored procedure and asp core mvc , I tried many solutions but not working , for ex: list of categories and subcatecories

@karencotto4895 3 жыл бұрын

Does this work with MySQL changing the library to the corresponding one?

@abdullahquhtani4247 2 жыл бұрын

Fantastic 👍🏼. Is there a tutorial for API PROJECT using the same technique (stored procedure)?!

@manoswiniswain9877 3 жыл бұрын

sir can you tell me .i supposed to create one website in that website there should be one excel upload file .we need upload that excel .after that it will read the columns of the header and will tell the datatype .please suggest me sir please

@saurabhkatrojwar2290 2 жыл бұрын

After publish our MVC or API project, Controllers and Models .dll created in one single bin folder not seperately. Is it possible to generate dll of Controller and Models dll seperately in seperate folders. Thanks

@hamzaalitaj708 3 жыл бұрын

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) after entering the data this error pops up

@jadinemeghrajh9918 Жыл бұрын

Heyyyy! How do you get the DevConnection string? Mine is giving an error: An unhandled exception occurred while processing the request. ArgumentException: Keyword not supported: 'multipleactiveresultset'.

@CodAffection Жыл бұрын

I think you missed last character 's' in multipleactiveresultsets.

@sandeepkumar-ol5lg 3 жыл бұрын

Everything is perfect but I’m looking for same video with max of all client controls covered like in the the page a couple of radio buttons , checkbox and a dropdown list will be better

@RohitNVolgs Жыл бұрын

Hello sir which package you install here plz tell

@Desilonde101 3 жыл бұрын

3:16 class add class and then first ooption of class is not available in my visual studio what can i do?

@hamzaalitaj708 3 жыл бұрын

error while creating the contoller at the start, please tell the solution

@marsel5802 3 жыл бұрын

I wrote everything same and I did everything same but when i Click submit to save book it say ti me An unhandled exception occurred while processing the request.

@jadinemeghrajh9918 Жыл бұрын

Sammmme 😔 this is depressing...

@orangecoder3416 Жыл бұрын

Thank You for this tutorial. But AddOrEdit is anti-single responsibility principle method!)))

@CodAffection Жыл бұрын

Yes, it is. If you are strictly following SOLID principles, you should create separate views for both create and upadate operation. I combined both of them because both the forms are almost similar. In future if there are requirements to change the form design making changes at one place would be more productive and easy. At the end, try to stick what's good from your experience. If I find a convincing reason like this I think out side SOLID principles.

@chanakyakhatri5194 3 жыл бұрын

Hi sir I am trying to make a ecommerce and I am not able to do add items in the cart and saving into the data (using asp.net core and angular ) can you please make a kind of tutorial to add the products into the cart and saving them into the sql , ecommerce kind of tutorial pls

@hienit187 3 жыл бұрын

if it's foreign key ??

@rahavgautam5862 3 жыл бұрын

hi sir that's a great tutorial , can you make a shopping cart kind of project in .net core and angular pls!

@CodAffection 3 жыл бұрын

Sure thing.

@rahavgautam5862 3 жыл бұрын

@@CodAffection thankyou sir :)

@abderrahmenalhelaoui5813 3 жыл бұрын

please make us a video on wpf mvvm

@dawoodanwar2076 3 жыл бұрын

I could not find bookdb file from github source code kindly update code

@swagatikajena580 3 жыл бұрын

Sir i am very need for a mvc project.please give me a mvc project with source code.i need to pratice and need to put in my resume.please help.🙏

@paulojamero9670 Жыл бұрын

Aside from combining the add and edit function, which is a bad practice.. Is this a good practice to learn? I'm newbie and looking for best practices. Thanks!

@CodAffection Жыл бұрын

If you are talking with SOLID principle in mind, you are 100% correct. But in real world projects, YOU have to choose a best practice according to the project you are working. Now coming to our application here, most of the scenario for both create and update operation the form fields are same with few minor changes here and there. You could design these forms separately. but what I found is that whenever there is a modifcation or a bug fix, we've to do them in both of these places.As the number of such controllers grows, it gets more difficult. Its only my oppinion, more power to you.

@paulojamero9670 Жыл бұрын

@@CodAffection Great! Do you have a SEARCH FUNCTION tutorial that follows the pattern on this tutorial?

@Martin-ju4ue Жыл бұрын

can you please make ms excel as a database all the data must store in excell

@vijayalakshmikamma5511 2 жыл бұрын

Dotnet developer MVC core -category code explain sir

@marilu9138 3 жыл бұрын

well now i feel that i i can't live without EF.

@someonesoumya 3 жыл бұрын

u can live with oxygen

@ashraf6850 3 жыл бұрын

Hello sir without scaffolding crud operation banao asp.net MVC EntityFramework please sir

@shantanupatil6064 10 ай бұрын

Please mention your upi Id ,as everyone don't has paypal account

@raiscl 3 жыл бұрын

I'm sorry but you start the project saying that we won't use EF, than to create a controller you install a bunch of unecessary EF shit because its easier..... not cool.