Linq to SQL running very slow compare to normal sql query RRS feed

  • Question

  • Linq to sql query is giving very low performance compare to sql query.can any one tell me is that linq to sql is slow compare to ado .net sql queries.
    Saturday, November 10, 2012 9:36 PM


All replies

  • Hi Rahulraics,

    Welcome to the MSDN Forum.

    I am trying to involve some other one into this case, please wait it patiently.

    Thank you.

    Best regards,

    Mike Feng
    MSDN Community Support | Feedback to us
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, November 12, 2012 8:05 AM
  • LINQ to SQL supports the use of compiled queries for this purpose: http://msdn.microsoft.com/en-us/library/Bb399335(v=vs.90).aspx

    Tuesday, November 13, 2012 11:08 PM
  • Hi,

    it should not hamper the performance . It is meant for productivity from many angles . Can you share you LINQ query , perhaps that one is not optimized or you may have written it in some wrong way !

    Wednesday, November 14, 2012 12:41 PM
  • Closing this thread as answer was provided.
    Friday, November 30, 2012 2:44 AM