VS Data Team's WebLogAll things Visual Studio Data related.New Data Tools Features in Visual Studio Orcas- March 9, 2007 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 back to relational database without writing complex data access logic. It is the latest enhancement in data access technology and there are many different...http://blogs.msdn.com/vsdata/archive/2007/03/09/new-data-tools-features-in-visual-studio-o... TableAdapter and Multiple Result Sets- March 8, 2007 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 data from database. And DataSet.Fill() method allows you to retrieve multiple result sets from a stored...http://blogs.msdn.com/vsdata/archive/2007/03/08/tableadapter-multiple-result-sets.aspx |