none
VS 2010 performance using LinqToSql RRS feed

  • Question

  • I have a database with about 400 tabels. Using Linqpad I can construct queries using LinqToSql objects. Linqpad is able to generate these objects within seconds. However, it takes VS 2010 a very long time. After creating the autogenerated file with all the objects of the database I cannot access that file. VS 2010 becomes unresponsive.

    So, using VS 2010 I am unable to perform some core business coding tasks using LinqToSql. I have posted performance problems and other problems. I am getting very frustrated. Answers are not provided. VS 2010 is by far the most expensive piece of software I use. 

    I am not happy....

    (I was happy with VS 2008, and I am happy with Windows 7)


    Best regards -- Casper

    Best regards -- Casper
    • Moved by Yi Feng Li Saturday, June 25, 2011 8:30 AM LINQ to SQL issue (From:Visual Studio Editor)
    Tuesday, June 21, 2011 3:54 PM

Answers

  • Hello,

     

    Thank you for posting.

    From your description, there’s now an Any-CPU build for LINQPad 4.x. http://www.linqpad.net/preview/LINQPad4-AnyCPU.zip This is useful if you have queries that require more than 3GB of RAM. This lets you use all available memory on X64 systems. It also lets you reference external assemblies built only for X64. In addition, this is that you cannot reference external assemblies built only for X86. (And X86 is the default for executables in VS2010). Please check this reference for more information. http://www.linqpad.net/Beta.aspx

     

    Hope this helps.

    Best Regards,


    Larcolais Gong[MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Saturday, June 25, 2011 4:29 PM

All replies

  • Following a suggestion from another related thread, also me complaining about the unresponsiveness of VS 2010, I tried to add database tables (551) to the designer using VS 2010 in Safe Mode. As I am writing this post, VS 2010 is going at it, actually it is unresponsive. Again using a tool like Linqpad (also includes intellisense) creating a Linq library is almost done on the fly! This is in sharp contrast with the really poor performance of VS 2010.

    So, there must be something in the software that uses a Shlemiel the painter's algorithm. 


    Best regards -- Casper
    Thursday, June 23, 2011 3:44 PM
  • Hi halcwb,

     

    Thank you for your suggestion. We are glad to hear the feedback from our customer. We recommend you submit your suggestion to our Connect site, http://connect.microsoft.com/, our engineer will evaluate it seriously.   

     

    Since your issue is about Linq to SQL, I’m moving this thread to Linq to SQL forum, http://social.msdn.microsoft.com/forums/en-US/linqtosql/threads/, there are more expert who know this topic, they may help find some workaround for you.

     

    Thank you very much

    YI


    Yi Feng Li [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Saturday, June 25, 2011 8:30 AM
  • Hello,

     

    Thank you for posting.

    From your description, there’s now an Any-CPU build for LINQPad 4.x. http://www.linqpad.net/preview/LINQPad4-AnyCPU.zip This is useful if you have queries that require more than 3GB of RAM. This lets you use all available memory on X64 systems. It also lets you reference external assemblies built only for X64. In addition, this is that you cannot reference external assemblies built only for X86. (And X86 is the default for executables in VS2010). Please check this reference for more information. http://www.linqpad.net/Beta.aspx

     

    Hope this helps.

    Best Regards,


    Larcolais Gong[MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Saturday, June 25, 2011 4:29 PM
  • Any update? Would you mind letting us know how it goes?

    Best Regards,


    Larcolais Gong[MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, June 28, 2011 6:28 AM
  • Hello,

    Unfortunately, VS2010 performance in creating LinqToSql classes is still very poor, especially compared to Linqpad. As reported above, I tried creating a DBML file dragging 500+ tables to the designer using VS in safe mode. But still this takes a considerable amount of time. So, I keep wondering, why is Linqpad so fast and VS2010 so slow??


    Best regards -- Casper
    Monday, July 18, 2011 1:12 PM