ADO .NET Using Visual C# 2005
Course Title: ADO .NET Using Visual C# 2005
Course #: ADO3I
Duration: 3 days
Overview:
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.
Topics:
Accessing Data with ADO.NET
Audience: C# .NET developers needing to communicate with datasources.
Prerequisites: SQL Programming, Fundamentals of XML and The .NET Framework Using C#. The ability to write simple Windows Forms applications and a working knowledge of SQL Server are recommended.
Course #: ADO3I
Duration: 3 days
Overview:
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.
Topics:
Accessing Data with ADO.NET
- The ADO.NET Object Model
- Connecting to Data
- Understanding Connection Pooling
- Using Provider Statistics
- Introducing Command Classes
- Working with Data Readers
- Digging Deeper into Commands and DataReaders
- Populating a DataTable
- Filling DataSets Using a DataAdapter
- Using the Load Method
- Retrieving Schema Information
- DataSets and XML
- Using Constraints
- Foreign Key Constraints
- Other Constraints
- Creating DataRelations
- Navigation Pathways
- Expressions and Relations
- Specifying XML Nesting
- Creating Commands with CommandBuilders
- Creating Custom Commands
- Using Stored Procedures
- Performing Batch Updates
- Using a Loosely Typed DataSet
- Creating a Strongly Typed DataSet
- Using a Strongly Typed DataSet
- Issues with Using a Strongly Typed DataSet
- Using Structured Exception Handling
- Handling Provider Errors
- Using Transactions
- Handling Concurrency Conflicts
- The Sample Project
- Working with DataTables
- Working with DataViews
- The AutoIncrement Property
- Retrieving New Database Values
- Avoiding Multi-User Conflicts
- Merging Inserted Rows
- Other Considerations
- ADO.NET and XML
- Saving DataSet Data as XML
- Loading XML Data into a DataSet
- Working with DataSets and XML Together
- Working with XML Data in SQL Server
- Enumerating Servers on a Network
- Asynchronous Processing
- Multiple Active Result Sets (MARS)
- Bulk Copy Operations
- SQL Server Max Data Types
- SQL Server User Defined Types
- SQL Server Snapshot Isolation
Audience: C# .NET developers needing to communicate with datasources.
Prerequisites: SQL Programming, Fundamentals of XML and The .NET Framework Using C#. The ability to write simple Windows Forms applications and a working knowledge of SQL Server are recommended.
Clients
