Microsoft has taken a moralizing stance on some of the new data-access features in Visual Studio 2005. For reasons only they understand, the Microsoft Visual Studio development team has chosen to hide some Visual Studio features that many of you have been using since the first release of Visual Studio. For example, every ADO.NET book, article, or course explains how to create an updatable DataSet with the DataAdapter Configuration Wizard (DACW). But when you start Visual Studio 2005, you won't find this wizard in the Toolbox—at least not in the July Community Technology Preview (CTP) build. The Command and Connection wizard icons for each of the providers are gone too. These features are still in the product, but Microsoft has hidden them. If you're like me, you still find uses for these productivity aids—especially when teaching folks how to use ADO.NET. Fortunately, it's not hard to expose them again. Just follow these steps:
Unfortunately, not all of the productivity features we got used to in Visual Studio 2003 are still in Visual Studio 2005. For example, when you want to create a quick call to a stored procedure to build the Parameters collection, Visual Studio 2003 lets you drag a stored procedure from the Server Explorer to the form, and Visual Studio takes care of the rest. This method doesn't work in Visual Studio 2005. But I understand that one of the new refactoring add-ins can build a Parameters collection from a stored procedure, so all hope is not lost.