CRUD without Entity Framework in ASP.NET Core MVC

Подписаться 146 тыс.

Просмотров 103 тыс.

50% 1

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

Опубликовано:

5 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 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.