Fares Ayyad

Fares Ayyad

  • NA
  • 235
  • 71.8k

Using ADO.net in MVC5 application

Jul 4 2017 5:39 AM
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?  

Answers (3)