In this course, learn about the features provided by ADO.NET 2.0. Learn to connect to data sources, retrieve and manipulate data, and perform data updates. Examine the various ADO.NET classes, including Connection, Command, DataReader, DataSet, DataTable, DataRelation, and more. See how to apply constraints and relationships to disconnected data. Learn how to update data, including how to handle stored procedures, parameters, and return values. Understand how to search, sort, and filter data stored in a DataSet or DataTable. Become familiar with strongly typed DataSets and learn their advantages. See how to leverage the power of XML through serialization, Diffgrams,and the XMLDataDocument object. Examine new ADO.NET features that support SQL Server 2005 technologies, including asynchronous commands, Multiple Active Result Sets, bulk inserts, and more.
At course completion, students will be able to:
Connect to multiple types of data sources, including SQL Server and Microsoft Jet/Access
Retrieve data, using the DataAdapter, Command, and DataReader classes
Create and configure Command parameters
Cache data using the DataTable and DataSet classes
Apply constraints to DataTable and DataColumn objects
Create relations between DataTable objects, using the DataRelation class
Update data using DataAdapter and Command classes
Work with strongly typed DataSet and DataTable classes
Retrieve and update data using TableAdapter classes
Handle exceptions and data errors, including concurrency errors
Search, sort, and filter data using the DataView class
Work with auto-increment columns in multi-user applications
Retrieve and generate XML data
Take advantage of new SQL Server 2005 features
This course will be taught using Microsoft
Visual Studio.
