Click here to Skip to main content
14,428,118 members
Rate this:
Please Sign up or sign in to vote.
What is Fastest way to fetch data from database in mvc4 and webapi 2?

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

By using Entity Framework You Can Fetch Data Fast
Rajib Mahata 15-Oct-14 3:42am
which will be the best taking .edmx file
sashkhdr 15-Oct-14 3:53am
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?

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

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100