Using ADO.net in MVC5 application

Fares Ayyad

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?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Fares Ayyad9y ago
@Nilesh

Could you refere to the best practices or an article to use entity framework
Manikandan Murugesan9y ago
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/
Nilesh Shah9y ago
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.