2541 Core Data Access with Microsoft Visual Studio 2005 - Details
Return to All courses
Description:
This workshop provides students with the knowledge and skills to develop data-access applications by using the Microsoft .NET Framework and Microsoft Visual Studio 2005. The workshop describes how to access and update data in a database by using ADO.NET.
More Information
3 days
This workshop is intended for corporate and Independent Software Vendor (ISV) application developers who have a desire to learn more about specific technology areas in distributed application development.
Be able to manage a solution environment using the Visual Studio 2005 integrated development environment IDE and tools. Understand the .NET Framework 2.0 and the Common Language Runtime. Be able to program an application using a .NET Framework 2.0 compliant language. Know how to make assemblies available to other applications.
After completing this workshop, students will be able to: - Connect to databases and read data. - Query and update databases by using commands. - Perform transactional operations. - Perform disconnected operations programmatically. - Perform disconnected operations by using Visual Studio 2005 wizards. - Perform XML operations on disconnected data. - Read and write XML data. - Process XML data by using the Document Object Model DOM.
| Lesson 1: Connecting to Databases and Reading Data |
What Is ADO.NET? The Process for Connecting to a Database and Reading Data What Is Connection Pooling?
| |
| Lesson 2: Querying and Updating Databases by Using Commands |
ADO.NET Commands The Process for Passing Parameters into Commands
|
| Lesson 3: Performing Transactional Operations |
What Is a Transaction? The Process for Managing Local Transactions The Process for Managing Distributed Transactions Isolation Levels
|
| Lesson 4: Performing Disconnected Operations Programmatically |
What Is the ADO.NET Disconnected Model? The Process for Loading and Saving Data in a DataSet What Are DataViews?
|
| Lesson 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards |
Comparing Untyped DataSets with Typed DataSets What Are Table Adapters? Demonstration: Creating a Typed DataSet by Using Visual Studio 2005 Wizards
| |
| Lesson 6: Performing XML Operations on Disconnected Data |
XML Representations of DataSets What Are DiffGrams?
|
| Lesson 7: Reading and Writing XML Data |
The Process for Serially Reading XML Data The Process for Serially Writing XML Data
|
| Lesson 8: Processing XML Data by Using DOM |
What Is DOM? What Are DOM Trees? Types of XML Nodes in a DOM Tree
|
Please call Jon Kudlick, Director of Sales at (919) 336-1000, ext. 1025 or email sales@nhrtp.com for class information.
Contact us to learn more about our courses and certifications.
Return to Top