Slow Visual Studio 2008 performance from the IDE when viewing all data sources

Question

We use Visual Studio 2008 to develop our core product. We have a C # solution with approximately 5 projects and 250 data sources.

It takes 15 to 25 seconds each time I do either Data> Show Data Sources, or if I struck out the control (DataBindings) to bind the value of the control to the data source.

Besides reducing the number of data sources used, is there a way to speed up the browsing / selection of data sources, especially when I browse and bind controls to a data source? I know that I can copy and paste settings (DataBindings) instead of calling a drop-down list, but it would be nice to use the drop-down menu for convenience.

Answer 1

How about using the Entity Framework if your database supports it. I think this can improve design performance. Creating your datasets using a database schema and all binding properties can also be enabled programmatically.