Accessing Data with Microsoft .NET Framework 4 (70-516) Online Training

Accessing Data with Microsoft .NET Framework 4 (70-516) Online Training

Course Outline

This Microsoft Exam 70-516 MCTS: Accessing Data with Microsoft .NET Framework 4 course is designed to build the student's knowledge and skills on accessing data sources using ADO.NET and the .NET Framework.

OUR Price


£125.00+ VAT



£195.00+ VAT


Key Features

  • 12 Months Unlimited 24x7 Online Access
    • 24x7 online access to the course materials - anytime, anywhere, and on any device. Just log-in online and learn the skills you need - all at your own pace.
  • Self-Paced Navigation
    • With all courses arranged via multiple on-demand sections, comprehensive navigation & controls allow you to fast forward, skip, rewind, restart, and effectively control your learning pace. This makes it easy to stop at any time, and then quickly get back to where you left off.
  • Expert Instructor-Led Multimedia Training
    • Get trained with full multimedia materials by the finest expert instructors in IT today. This creates a truly personal learning experience, and simulates all the benefits of classroom based learning - all from the comfort of your own home/office.
  • Multi-Tiered Exam Preparation
    • Objective Testing : Utilising questions that follow a specific module, focusing on specific key skills within that area of knowledge.
    • Full Practice Exams : Broad-base exams that cover multiple modules, or the entire syllabus.
    • Certification Practice : Learn where your strong & weak points exist. Simulators give you the chance to practice an actual certification exam. These simulators adhere to the same format as the actual exam provided by a testing centre.
    • The flexibility of these exam simulators & practice-tests allows you to monitor what you've learned, giving you the confidence required to pass your exams at the first attempt.
Accessing Data with Microsoft .NET Framework 4 (70-516) Online Training

Course Description

Candidates for this exam use Microsoft Visual Studio 2010 and ADO.NET 4 to develop the data access layer of an application. Candidates should have a minimum of two to three years of experience developing application components that interact with a variety of data sources. In addition, candidates should have a thorough understanding of relational database concepts and should have a minimum of one to two years of experience using a relational database management system.

Candidates should also have a good grasp of the following:

  • ADO.NET 4 coding techniques and framework components
  • ADO.NET Data Services LINQ
  • LINQ to SQL
  • Entity Framework technologies
  • Structured Query Language (SQL)
  • Stored procedures
  • Database Structures/Schemas (Objects) XML

Students can select either VB or C# for their training language.


70-516 Accessing Data with Microsoft .NET Framework 4.0

Section 1 - Working with Disconnected Classes
ADO.NET Classes - DataTable
ADO.NET Classes - DataRow
Enumerating a Data Table
DataSet Object
DataRelation Object
Merging DataSets
DataTable and DataSet Classes
Write XML
Data Binding
Test Our Knowledge

Section 2 - Working with Connected Classes
Connected Classes
DbConnection Object
Connection Strings
SQL Server Connection String
Connection Pooling
DbCommand Object
Multiple Active Result Sets
DbDataAdapter Object
DataRow Object
Saving Changes Using Update
Opening the Connection
DbProviderFactory Classes
Working with Transactions
Transaction Isolation Levels
Distributed Transactions
Test Our Knowledge

Section 3 - Understanding Language-Integrated Query
Deferred Execution
Object Initializers
Lambda Expressions
Extension Methods
Query Extension Methods
Last Extension Method
LINQ Enabled Features
Using LINQ Queries
Test Our Knowledge

Section 4 - Using ADO.NET LINQ to SQL
Modeling Your Data
Mapping Stored Procedures
Examining an Entity Class
DataContext Class
Eager Loading vs. Lazy Loading
Executing Queries
Inner Joins
Outer Joins
Changes to the Database
Life Cycle of an Entity
Modifying Existing Entities
Adding an Entity
Stored Procedures
Submitting Changes
Test Our Knowledge

Section 5 - Using ADO.NET LINQ to XML
XMLDocument Object
XMLReader Class
XDocument Family
XDocument Class
Using LINQ to XML
Test Our Knowledge

Section 6 - ADO.NET Entity Framework
LINQ to SQL vs. Entity Framework
Data Model Mapping
Code First Model
Database First Model
Generated Model
Mapping Details Properties
Provider and Connection String Information
Working with Complex Types
Implement Stored Procedures
Partial Classes and Methods
Implementing Inheritance
TPC inheritance
Updating the Database Schema
Entity Object Generator
POCO Entities
Model Defined Functions
Querying and Updating
Opening an Entity Connection
EntityCommand Object
Functions and Methods
Entity Sets
ObjectContext Class
Deleting Entities
Stored Procedures
Submitting Changes
Test Our Knowledge

Section 7 - Using WCF Data Services
Creating Data Services
Configuring Data Services
Return Database Information
Querying the Data Service
Working with Filters
OData Functions
Consuming Data Services
Binding to Data Service
Payload Formats
Using Interceptors
Test Our Knowledge

Section 8 - Developing Reliable Applications
Implementing Instrumentation
Monitor Performance
Handling Exceptions
Protecting Your Data
Symmetric Cryptography
Asymmetric Cryptography
RSA Encryption
Hashing and Salting
Microsoft Sync Framework

Section 9 - Test Our Knowledge
Using ADO.NET Deployment
Visual Studio Deployment
Package Publish Web Tab
Web.config Transformations
Silverlight Considerations
Test Our Knowledge
Program Review and Resources

(Any associated exam costs are not included)
FREE : IT Certification & Career Training Guide