MCTS Exam 70-516:  Accessing Data with Microsoft .NET Framework 4

Module 1: Data Access Technologies in .NET

·         Introduction  to ADO.NET Architecture

·         Consuming Data

• Writing SQL Queries
• Using DataReader,DbAdapter,DbTableAdapter

·         Introduction to Datasets:Dataset class hierarchy,Dataset Datatypes,User defined datatypes

• Creating relationships in Datasets:DataRelation class,DataView
• Validation and Errors on DataSet
• DataTableReader class
• Creating Typed datasets:TableAdapter

Module 2: Building Entity Data Models

• Generating and Querying an Entity Data Model(EDM)
• Querying data using Object Services
• Overriding Generated Classes
• Using Templates to Customize Entities
• Creating and Using Custom Entity Classes

Module 3: Querying Entity Data

·         Retrieving Data by Using LINQ to Entities

·         Retrieving Data by Using Entity SQL

·         Retrieving Data by Using EntityClient Provider

·         Retrieving Data by Using Stored Procedures

Module 4: Creating, Updating, and Deleting Entity Data

·         Understanding Change Tracking in the Entity Framework

·         Modifying Data in an Entity Data Model

·         Customizing the Entity Data Model

Module 5: Handling Multi-User Scenarios by Using Object Services

·         Handling Concurrency in the Entity Framework

·         Transactional Support in the Entity Framework

Module 6: Building Optimized Solutions by Using Object Services

·         The Stages of Query Execution

·         Change Tracking and Object Materialization

·         Using Compiled Queries

·         Using Design-Time Generated Entity Framework Views

·         Monitoring Performance

·         Performing Asynchronous Data Modifications

Module 7: Using POCO Classes with the Entity Framework

·         Requirements for POCO Classes

·         POCO Classes and Lazy Loading

·         POCO Classes and Change Tracking

·         Extending Entity Types

Module 8: Building an N-Tier Solution by Using the Entity Framework

·         Designing an N-Tier Solution

·         Defining Operations and Implementing Data Transport Structures

·         Protecting Data and Operations

Module 9: Handling Updates in an N-Tier Solution by Using the Entity Framework

·         Tracking Entities and Persisting Changes

·         Managing Exceptions in an N-Tier Solution

Module 10: Building Occasionally Connected Solutions

·         Microsoft Sync Framework

·         Offline Data Caching by Using XML

·         Sync Services for ADO.NET

Module 11: Querying Data by Using WCF Data Services

·         Introduction to WCF Data Services

·         Creating a WCF Data Service

·         Consuming a WCF Data Service

·         Protecting Data and Operations in a WCF Data Service

Module 12: Updating Data by Using WCF Data Services

·         Creating, Updating, and Deleting Data in a WCF Data Service

·         Preventing Unauthorized Updates and Improving Performance

·         Using WCF Data Services with Nonrelational Data

Module 13: Using LINQ to SQL

·         LINQ to SQL in disconnected mode

·         LINQ to SQL using Stored Procedures

·         DataContext,Mapping,

·         LINQ To SQL Data updation

For Details Contact Central Office Cochin :-

Ms. Angel / Ms. Harsha
Mobile: +91 9947422200/9744166610
Land phone: 91-484-4049001 / 03
Email id: mailto:enquiry@logicindia.net
Chat ids :- Yahoo : logicchat
                  Skype : logicenquiry
                  GTalk  : enquiry@logicindia.net