locked
Entity Framework and Performance RRS feed

  • Question

  • when we use EF to fetch data from db then it is just generate sql....if we write inline sql for db operation then we always get slow performance. EF does the same thing and the difference is we access database object in strongly type fashion.
    • Moved by CoolDadTx Tuesday, May 3, 2011 1:48 PM EF related (From:Visual C# General)
    Monday, May 2, 2011 6:00 PM

Answers

  • I am a little unclear what you question is but if you are looking for EF performance suggestion check out this forum because I believe it has the answer you may be looking for.

    http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/5a0a6e6e-32bf-4967-98f3-759ed2ee0c10/

    • Marked as answer by Jackie-Sun Thursday, May 12, 2011 7:48 AM
    Monday, May 2, 2011 6:02 PM
  • On 5/2/2011 2:00 PM, Mou_kolkata wrote:
    > when we use EF to fetch data from db then it is just generate sql....if
    > we write inline sql for db operation then we always get slow
    > performance. EF does the same thing and the difference is we access
    > database object in strongly type fashion.
     
    This implies in general with speeding up queries.
     
    <http://www.asp.net/entity-framework/tutorials/maximizing-performance-with-the-entity-framework-in-an-asp-net-web-application>
     
     
    <http://msdn.microsoft.com/en-us/library/bb896240.aspx>
     
    <http://msdn.microsoft.com/en-us/library/bb738562.aspx>
     
    • Marked as answer by Jackie-Sun Thursday, May 12, 2011 7:49 AM
    Monday, May 2, 2011 7:26 PM

All replies