What's New in Data

This version of Visual Studio includes the following new features for developing applications that access data:

  • Language-Integrated Query (LINQ) technology presents important programming-language advances over Visual Studio 2005. LINQ to SQL applies LINQ technology to relational databases. For more information about getting started with LINQ to SQL, see LINQ to SQL.

  • The Object Relational Designer (O/R Designer) assists developers in creating and editing the LINQ to SQL objects that map between an application and a database. The O/R Designer creates the DataContext, entity classes, and DataContext methods that are used by LINQ to SQL to communicate with the remote database and handle data that is used in your application. For more information, see O/R Designer Overview.

  • N-Tier support for typed datasets provides enhancements to the Dataset Designer that assist in separating TableAdapter code and typed dataset code into discrete projects. For more information, see N-Tier Data Application Overview.

  • Hierarchical update capabilities have been incorporated into the Dataset Designer to enable saving data in multiple related tables. A new TableAdapterManager object providing generated code that includes the save logic necessary for maintaining referential integrity has been added to typed datasets. Instead of calling the Update method for each TableAdapter, call the TableAdapterManager.UpdateAll method. For more information, see Hierarchical Update.

    • By default, hierarchical updates are enabled for datasets that are created in this version of Visual Studio. You can control hierarchical updates by setting the Hierarchical Update property in the Dataset Designer. For detailed information, see How to: Enable and Disable Hierarchical Update.
  • Local database caching incorporates a SQL Server Compact 3.5 database and Microsoft Synchronization Services for ADO.NET into an application and prepares the application to periodically synchronize the data with a remote database on a server. Local database caching enables applications to reduce the number of round trips between the application and a database server. This can increase performance when you are working with data that changes infrequently or when applications are not always able to connect to the remote database. For more information, see Occasionally Connected Applications Overview.

  • Microsoft SQL Server Compact 3.5 is a compact database that can be deployed on desktop computers, smart devices, and Tablet PCs. SQL Server Compact 3.5 is a local database that is easily incorporated into applications and is easily deployed. For more information, see Using SQL Server Compact 3.5 (Visual Studio).

See Also


What's New in Visual Studio 2008

What's New in ADO.NET

What's New in Visual Database Tools

What's New in Visual Basic

What's New in Visual C#

Additions to Windows Forms for the .NET Framework 2.0

Change History




July 2008

Added information about configuring local database caching by using the Data Source Configuration Wizard.

SP1 feature change.

July 2008

Added information about configuring local database caching to use SQL Server change tracking.

SP1 feature change.