VS 2005 patch for SQL Server 2008

SQL Server 2008, Noverber 2007 CTP was recently released. We’ve also released a CTP of Visual Studio 2005 Support for SQL Server 2008. This will enable you to use VS2005 against SQL Server 2008. For more information about this patch, see the Knowledge Base Article 942246.

2

New Data Tools Features in Visual Studio Orcas

Here’s a list of new data tools features in Visual Studio. I will be discussing each one in more detail in upcoming posts. Object Relational Designer The object relational mapping technology lets you map relational databases to objects. Once the mapping is done, you can manipulate mapped objects as normal objects and easily submit changes…

2

TableAdapter and Multiple Result Sets

Several people asked me whether TableAdapter can be used to retrieve multiple result sets from stored procedures. The quick answer is… No, you can’t do that with TableAdapter.Fill() method that gets generated as a part of Typed Dataset. But there’s a very simple work-around. DataAdapter.Fill() & Multiple Result Sets TableAdapter.Fill() method calls DataAdapter.Fill() to retrieve…

2