Using ADO.net in MVC5 application

Question

Hello I'm wondering if i can use ADO.net (SQLConnection SQLCommand etc...) with MVC5 application and use OWIN etc... in all of my projects with MVC5 I only worked with entity framework but i noticed that in large applications there's a performace issues i read about this and if found that using StoredProcedures will solve the performace issues in some way. but is it possibel to solve the issue permanantly using ADO.net OR if there's any body work with EF6 can give me tricks to solve performace issues when using entity framework. If it's possible to use ADO.net is there any limitation such as working on OWIN or another feature in MVC5?

Nilesh Shah · Answer

you can ofcourse work with ADO.Net in MVC there is no restriction. But your conclusion that EF has performance issues that's why you want to use ADO.Net is wrong. There are many things coming into picture which determines a DB's performance ranging from table design itself missing indices on tables poorly written SQL queries insufficient CPU core and memory allocated to SQL Server instance and many more. Try to look at those things too. You can also call an SP using EF. So there is no need for you to move to ADO.Net for only using an SP.

Fares Ayyad · Answer

@Nilesh Could you refere to the best practices or an article to use entity framework

Manikandan Murugesan · Answer

Refer the following Links : http://www.c-sharpcorner.com/UploadFile/0c1bb2/insertupdatedelete-in-Asp-Net-mvc-5-using-ado-net / http://www.c-sharpcorner.com/UploadFile/francissvk/crud-operations-in-Asp-Net-mvc-using-ado-net/