ADO.NET - a new way of handling data
Peter Ty
Developer Evangelist
.NET and Developer Group
Agenda
Overview of Data in .NET
Getting Data from a SQL Database
Working with Data
Data as XML
Tips and Tricks
Introduction to ADO.NET
What is ADO.NET
Natural Evolution of ADO
Interoperability
Based on standards like XML, XSD
Scalability
Targets distributed, disconnected web scenarios
Model
Distributed architecture replacing client/server
Integration of data from multiple heterogeneous sources
Introduction to ADO.NET
Why ADO.NET
To Accommodate Web Application Model
Loosely coupled
Maintaining state between requests
Uses HTTP
Introduction to ADO.NET
Comparison Between ADO and ADO.NET

Communicates with standardized calls to the DataAdapter
Provided by RecordSet but typically supports connected access
Disconnected Access
Uses a navigation paradigm for non-sequential access
Scans RecordSet rows sequentially
Data Visitation
Supports the DataRelation object
Require the JOIN query
Relationship Between Multiple Tables
DataSet can contain one or more tables represented by DataTable Object
RecordSet can contain one table
Memory-resident Data Representation

下一页