Programming with Microsoft ADO.NET
Program Outline
Module 1: Data-Centric Applications and ADO.NET
Take a closer look:
Download Sample Module 1 (Portable Document Format 1.12 MB).
The following topics are covered in this module:
Design of Data-Centric ApplicationsADO.NET ArchitectureADO.NET and XMLAfter completing this module students will be able to:
Give examples of storage options.Diagram the architecture of data-centric applications.Choose a connected disconnected or mixed environment based on application requirements.Use the System.Data namespaces in applications.Diagram the ADO.NET object model.Analyze typical business scenarios.Explain how to use ADO.NET with XML.Lab 1.1: Data-Centric Applications and ADO.NET
Module 2: Connecting to Data Sources
Take a closer look:
Download Sample Module 2 (Portable Document Format 1.02 MB).
The following topics are covered in this module:
Choosing a .NET Data ProviderDefining a ConnectionManaging a ConnectionHandling Connection ExceptionsConnection PoolingAfter completing this module students will be able to:
Choose a .NET data provider.Connect to SQL Server.Connect to OLE DB data sources.Manage a connection.Handle common connection exceptions.Implement and control connection pooling.Lab 2.1: Connecting to Data Sources
Module 3: Performing Connected Database Operations
The following topics are covered in this module:
Working in a Connected EnvironmentBuilding Command ObjectsExecuting Commands That Return a Single ValueExecuting Commands That Return RowsExecuting Commands That Do Not Return RowsUsing TransactionsAfter completing this module students will be able to:
Build a command object.Execute a command that returns a single value.Execute a command that returns a set of rows and process the result.Execute a command that defines database structure and permissions by using the data definition language (DDL) and data control language (DCL).Execute a command that modifies data.Use transactions.Lab 3.1: Performing Connected Database Operations
Module 4: Building DataSets
The following topics are covered in this module:
Working in a Disconnected EnvironmentBuilding DataSets and DataTablesBinding and Saving a DataSetDefining Data RelationshipsModifying Data in a DataTableSorting and FilteringAfter completing this module students will be able to:
Describe the disconnected environment.Build a DataSet and a DataTable.Bind a DataSet to a DataGrid.Open and save a DataSet.Define a data relationship.Modify data in a DataTable.Find and select rows in a DataTable.Sort and filter a DataTable by using a DataView.Lab 4.1: Building Binding Opening and Saving DataSets
Lab 4.2: Manipulating DataSets
Module 5: Reading and Writing XML with ADO.NET
The following topics are covered in this module:
Creating XSD SchemasLoading Schemas and Data into DataSetsWriting XML from a DataSetAfter completing this module students will be able to:
Generate an XSD schema from a DataSet by using graphical tools.Save a DataSet structure to an XSD schema file.Create and populate a DataSet from an XSD schema and XML data.Save DataSet data as XML.Write and load changes by using a DiffGram.Lab 5.1: Working with XML Data in ADO.NET
Module 6: Building DataSets from Existing Data Sources
The following topics are covered in this module:
Configuring a DataAdapter to Retrieve InformationPopulating a DataSet Using a DataAdapterConfiguring a DataAdapter to Update the Underlying Data SourcePersisting Changes to a Data SourceHow to Handle ConflictsAfter completing this module students will be able to:
Configure a DataAdapter to retrieve information.Populate a DataSet by using a DataAdapter.Configure a DataAdapter to modify information.Persist data changes to a data source.Manage data conflicts.Lab 6.1: Retrieving Data into a Disconnected Application
Lab 6.2: Retrieving and Updating Customers and Orders Data
Module 7: Building and Consuming a Web Service That Uses ADO.NET
The following topic is covered in this module:
Building and Consuming a Web Service That Returns DataAfter completing this module students will be able to:
Build a Web service.Consume a Web service in a client application.Troubleshoot errors in an ADO.NET application.Lab 7.1: Troubleshooting an ADO.NET Application
Related Exams
This course will help the student prepare for the following Microsoft Certified Professional exams:
Exam 70-305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NETExam 70-306: Developing and Implementing Windows based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NETExam 70-315: Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NETExam 70-316: Developing and Implementing Windows based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
Student Pre-Requisites
The course assumes that students have the following skills:
Understanding of relational database concepts: table row column primary keys foreign keys constraints and viewsData query and modification experience including experience with SELECT INSERT UPDATE and DELETE commandsExposure to XML documents style sheets and schemasExperience with Visual Basic .NET Visual Basic for Applications or previous versions of Visual BasicExperience building user interfaces including Web applications or Microsoft Windows applications
Student Materials
The course materials are yours to keep. You will be provided with the following software for use in the classroom:
Microsoft Windows 2000 ServerMicrosoft SQL Server 2000 Developer EditionXML for SQL Server 2000 Web Release 2 (WR2)Microsoft Visual Studio .NETMicrosoft Access 2002
Program Goals
After completing the course students will be able to:
Describe data-centric applications ADO.NET architecture and ADO.NET and XML.Connect to SQL Server and other data sources.Perform connected database operations including executing SELECT commands database definition commands dynamic SQL commands and commands that return data from a SQL Server database in XML.Build a DataSet schema populate it with data and modify the data programmatically.Build a DataSet from an existing data source.Use XML techniques while working with DataSets including mapping tables and columns creating XSD schemas building strongly typed DataSets and interacting with XMLDataDocuments.Build a Web service that uses ADO.NET to query and update a data source.Troubleshoot errors within an ADO.NET application.
