Core Data Access with Microsoft Visual Studio

Required skills

Course Outline

Datacentric applications and ADO.NET

• Common databases and types
• Working with data in the connected and disconnected environment
• Data access models (layer-based structures)
• ADO.NET architecture

Working in an environment connected to a data source

• Creating a Connection object
• Handling exceptions
• Connection Pooling
• Getting and updating data using a Command object
• Types of Command object, working with parameters and saved procedures
• Obtaining ReadOnly ForwardOnly data streams using DataReader-type objects

Creating transactions

• What are transactions?
• Local and distributed transactions
• Transaction isolation

Working in an environment disconnected from the data source

• Fundamental ADO.NET objects for working in disconnected environment - overview
• DataAdapter, TableAdapter
• Non-typed and typed datasets
• Defining tables and relations in a dataset
• Modifying data in datasets
• Saving modified data to the data server
• LastInWins technique and optimistic competition technique
• DataBinding control elements
• Working with DataGridView

Processing XML data

• XML representation of a dataset
• DiffGramy
• XML data entry and reading
• Working with XML data using a DOM model
• Designing web services using the ADO.NET model
• Web service description
• Creating a web service providing data
• Synchronous and asynchronous web service call