What is Fastest way to fetch data from database in mvc4 and webapi 2

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sashkhdr · Answer 1 · 2014-10-14T21:15:00

Solution 1

By using Entity Framework You Can Fetch Data Fast

Posted 14-Oct-14 21:15pm

sashkhdr

Comments

Rajib Mahata 15-Oct-14 3:42am

which will be the best taking .edmx file

sashkhdr 15-Oct-14 3:53am

yes

Mycroft Holmes 16-Oct-14 4:00am

Rubbish - EF is not FAST it carries too much overhead. The fastest method IMHO is to use a darareader. Personally I use a datatable.fill and pass the data as a poco opbject.

sashkhdr 17-Oct-14 10:21am

okay....IMHO means

sris 426 8-Dec-14 5:20am

EF is not suitable for fetching the records. How about if i use EF to submit a single record. I have a user registration screen, I want to submit the user data to db. Is using EF in this scenario is good or not?