The stored procedure can then be specified as the source of the Insert Command of a Sql Data Adapter object.
I really wish I had the option to call someone at Microsoft and ask what the heck is going on here.
Net Framework code, then maybe I might be able to see where the bottleneck exists. It is very difficult for me to help you, so I am trying to give you other options. NET technology, in favor of LINQ-to-SQL, Entity Framework, and NHibernate.
Even then, I am not sure if there would be anything I could do to fix it since it would a problem within the Framework. Another possibility is to use the Performance Analysis feature from 2010, to see if it can identify any slow areas in your code.
Apparently, Visual Studio 2010's IDE behaves significantly different than it's Visual Studio 2005 counterpart.
However, I have no clue as to *why* it is happening. Update() method is an internal command, not one that I modified in any way. I don't feel so bad because it took six different Microsoft programmers and almost six months of time to discover the answer.