Microsoft 70-516: Accessing Data with Microsoft .NET Framework 4 – C#

The Microsoft Exam 70-516 TS: 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.

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

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
• Review
• Test Our Knowledge

Section 2 – Working with Connected Classes

• Connected Classes
• DbConnection Object
• Connection Strings
• SQL Server Connection String
• Connection Pooling
• Command Object
• Multiple Active Result Sets
• DbDataAdapter Object
• DataRow Object
• Saving Changes Using Update
• Opening the Connection
• DbProviderFactory Classess
• Working with Transaction
• Transaction Isolation Levels
• Distributed Transactions
• Review
• 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
• Review
• Test Our Knowledge

Section 4 – Using ADO.NET LINQ to SQL

• Modelling Your Data
• Mapping Stored Procedures
• Examining an Entity Class
• DataContext Class
• Eager Loading vs. Lazy Loading
• Executing Queries
• Outer Joins
• Grouping
• Paging
• Changes to the Database
• Life Cycle of an Entity
• Modifying Existing Entities
• Adding an Entity
• Stored Procedures
• Submitting Changes
• Review
• Test Our Knowledge

Section 5 – Using ADO.NET LINQ to XML

• XMLDocument Object
• Searching
• 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
• ObjectContext
• Provider and Connection String Information
• Working with Complex Types
• Implement Stored Procedures
• Partial Classes and Methods
• Implementing Inheritanc
• 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
• Review
• 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
• SaveChangesOption
• Payload Formats
• Using Interceptors
• Review
• 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
• Synchronization
• Microsoft Sync Framework
• Review

Section 9 – Test Our Knowledge

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

Course Delivery:    Online