What's New in Data
ADO.NET is an evolutionary improvement to Microsoft ActiveX Data Objects (ADO). It represents a standards-based programming model that facilitates the development of distributed applications, especially Web applications. ADO.NET uses standards-based XML as a medium for data transfer, making it particularly appropriate for exchanging data between components and applications, even on unlike platforms.
Visual Basic Note If you are familiar with data access in Visual Basic 6.0, see Data Changes in Visual Basic .NET.
What's New in Visual Basic .NET 2003
Visual Basic .NET 2003 includes two new .NET Framework data providers and enhanced support for large XML Schemas.
- .NET Framework Data Provider for ODBC
- The .NET Framework Data Provider for ODBC provides optimized performance when working with ODBC data sources. For more information, see .NET Framework Data Providers.
- .NET Framework Data Provider for Oracle
- The .NET Framework Data Provider for Oracle provides optimized performance when working with Oracle databases. For more information, see .NET Framework Data Providers.
- Improved Design-Time Experience for Working with Large XML Schemas
- The XML Designer provides improved viewing options when working with schemas that contain many elements. A new zooming feature has been added that enables fine control over how schemas are viewed in the designer. The ability to expand and contract elements in a nested hierarchy has also been added to the designer. For more information, see XML Designer.
What's New in Visual Basic .NET 2002
Visual Basic .NET 2003 also includes the following features, which were introduced in Visual Basic .NET 2002.
- Access Data Sources with High-Performance Data Components
- ADO.NET provides high-performance .NET Framework data providers for direct access to databases and other data sources. Data providers give you precise control over SQL commands and stored procedures that can return data or scalar values or perform other database operations. Data reader objects provide an extremely fast way to return read-only data from a data source. For more information, see .NET Framework Data Providers.
- Work with Disconnected Data
- To make the most efficient use of database and server resources, you can create datasets that act as a relational cache for data drawn from a data source. (A data source is typically a database, but can also be XML or any source for which data providers are available.) You can define data adapters that fill the dataset and propagate dataset changes back to the data source using stored procedures or SQL statements. For more information about this new data model, see Introduction to Data Access with ADO.NET.
- Create Datasets with Strongly Typed Access
- With ADO.NET you can create a dataset based on an XML schema, producing a typed class in which tables and columns become first-class objects in the object model. Typed access makes code easier to read, is less error prone, and is fully supported by IntelliSense in the Visual Studio Code Editor. For more information, see Creating ADO.NET Typed DataSets from Schemas.
- Exchange Data As XML With Other Applications or Components
- You can serialize data into and out of XML streams that can be exchanged with other XML-enabled applications or components by using either the built-in features of datasets or XML-specific methods. ADO.NET can easily create XML Web services with methods that return datasets as XML. For more information, see Building XML Web Services Using ASP.NET.
- Use Wizards for Configuring Data Access
- Wizards can be used to create and configure data adapters and connections.
The Data Form Wizard helps you create a form that is bound to a dataset, creating type-appropriate data-bound controls. The Data Form Wizard can create simple forms bound to a single table or master-detail forms bound to related tables, and can display data one record at a time or in a data-bound grid. For more information, see Data Form Wizard and Creating Data Adapters Using a Wizard.
- Add Data Components to a Form or Component by Dragging
- Server Explorer greatly simplifies data configuration by providing the capability to drag and drop tables from existing data stores to create data adapters and connection objects. Adapters, connections, commands, data views, and dataset objects are all available for drag and drop operations from the Data tab of the Toolbox. For more information, see Data Tab, Toolbox.
- Create XML Schemas
- You can also use the Visual Studio .NET XML Designer to visually design XML Schemas, which are files that validate XML data as well as describe the structure of datasets. For more information, see Introduction to XML Schemas.
- Edit XML Documents
- XML can be edited in a code editor with IntelliSense, or by using a graphical user interface. XML documents can also be validated against any XML schema. For more information, see XML Files.
- Bind Any Control Property to Data
- Whether you are working with Windows Forms or Web Forms pages, you can bind any property — or multiple properties — of any control to data. For step-by-step examples, see Walkthrough: Displaying Data in a Web Forms Page and Walkthrough: Displaying Data in a Windows Form Using a Parameterized Query.
- Work with Data Programmatically
- The data classes provided in the .NET Framework are used to create and manipulate data and XML in code. For more information, see Data Namespaces in Visual Studio and XML Namespaces.
- Work with ADO
- ActiveX Data Objects (ADO) is still supported using the COM interoperability support in the .NET Framework. For more information, see COM Component Compatibility.