MS2541 Core Data Access with Microsoft Visual Studio 2005
|Please Note: Dates are for courses conducted by our training partner in Sydney. Newcastle based training dates available on request|
|Walk-In Week starting:||Call 02 4969-0690 for the next course date|
This three-day instructor-led 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. The workshop also describes how to
create, read, and write XML data.
Before attending this workshop, students must:
- 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
- Have a good understanding of basic relational database concepts
- Be able to use basic SQL commands
- Have a good understanding of XML including XML declaration, elements, attributes, and namespaces
- Be able to explain XML schema concepts
Unit 1: Connecting to Databases and Reading Data
Unit 2: Querying and Updating Databases by Using Commands
- What Is ADO.NET?
- The Process for Connecting to a Database and Reading Data
- What Is Connection Pooling?
Unit 3: Performing Transactional Operations
- ADO.NET Commands
- The Process for Passing Parameters into Commands
Unit 4: Performing Disconnected Operations Programmatically
- What Is a Transaction?
- The Process for Managing Local Transactions
- The Process for Managing Distributed Transactions
- Isolation Levels
- What Is the ADO.NET Disconnected Model?
- The Process for Loading and Saving Data in a DataSet
- What Are DataViews?
Unit 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards
Unit 6: Performing XML Operations on Disconnected Data
- Comparing Untyped DataSets with Typed DataSets
- What Are Table Adapters?
- Demonstration: Creating a Typed DataSet by Using Visual Studio 2005 Wizards
Unit 7: Reading and Writing XML Data
- XML Representations of DataSets
- What Are DiffGrams?
Unit 8: Processing XML Data by Using DOM
- The Process for Serially Reading XML Data
- The Process for Serially Writing XML Data
- What Is DOM?
- What Are DOM Trees?
- Types of XML Nodes in a DOM Tree
|Forsythes Training provides instructor led computer training on the Microsoft Office and Adobe range of applications.|
We service Newcastle, the Hunter Valley, Lake Macquarie and the Central and Northern Coasts of New South Wales (NSW) Australia.With our mobile training room we can provide a range of courses on-site at your premises.