Search for Training

Developing Data Access Solutions with MS Visual Studio 2010

Course Overview


Developing Data Access Solutions with MS Visual Studio 2010

Course Content


Architecture and Data Access Technologies   

  • Data Access Technologies
  • Data Access Scenarios
  • Lab : Analyzing Data Access Scenarios
    • Identifying Data Access Technologies

Building Entity Data Models   

  • Introduction to Entity Data Models
  • Modifying the Entity Data Model
  • Customizing the Entity Data Model
  • Lab : Using Entity Data Models
    • Generating an EDM from the AdventureWorks Database
    • Using the Generate Database Wizard
    • Mapping Entities to Multiple Tables
    • Implementing an Inheritance Hierarchy
    • Using Stored Procedures
    • Creating a Complex Type

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
  • Unit Testing Your Data Access Code
  • Lab : Querying Entity Data
    • Retrieving All Contact Entities
    • Retrieving Contact Entities by Using a Filter
    • Retrieving RewardsClaimed Entities
    • Querying the Rewards Family of Entities
    • Executing a Stored Procedure

Creating, Updating, and Deleting Entity Data   

  • Understanding Change Tracking in the Entity Framework
  • Modifying Data in an Entity Data Model
  • Lab : Creating, Updating, and Deleting Entity Data
    • Maintaining Contact and Reward Data
    • Maintaining RewardsClaim Data

Handling Multi-User Scenarios by Using Object Services   

  • Handling Concurrency in the Entity Framework
  • Transactional Support in the Entity Framework
  • Lab : Handling Multi-User Scenarios by Using Object Services
    • Handling Concurrency of Rewards Claimed Data
    • Updating the RewardsClaimed and ArchivedRewardsClaimed Information by Using a Transaction

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
  • Lab : Building Optimized Solutions by Using Object Services
    • Improving the Performance of Query Operations
    • Improving the Performance of Update Operations

Customizing Entities and Building Custom Entity Classes   

  • Overriding Generated Classes
  • Using Templates to Customize Entities
  • Creating and Using Custom Entity Classes
  • Lab : Customizing Entities and Building Custom Entity Classes
    • Using a Template to Add Custom Functionality to Entity Classes
    • Creating Custom Entity Classes

Using POCO Classes with the Entity Framework   

  • Requirements for POCO Classes
  • POCO Classes and Lazy Loading
  • POCO Classes and Change Tracking
  • Extending Entity Types
  • Lab : Using POCO Classes with the Entity Framework
    • Using POCO Classes
    • Extending Your POCO Classes

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
  • Lab : Building an N-Tier Solution by Using the Entity Framework
    • Creating the Contacts and Orders Data Access Tier
    • Protecting Data Access Operations

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

  • Tracking Entities and Persisting Changes
  • Managing Exceptions in an N-Tier Solution
  • Lab : Handling Updates in an N-Tier Solution by Using the Entity Framework
    • Handling Updates in the Data Access Tier
    • Detecting and Handling Order Conflicts

Building Occasionally Connected Solutions   

  • Offline Data Caching by Using XML
  • Using the Sync Framework
  • Lab : Building Occasionally Connected Solutions
    • Modifying the Orders Application to Use Offline XML Data
    • Modifying the Orders Application to Synchronize Locally Cached Data

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
  • Lab : Creating and Using WCF Data Services
    • Exposing Order Data as a WCF Data Service
    • Consuming a WCF Data Service
    • Restricting Access to Data Exposed by a WCF Data Service
    • Implementing a Business Operation in a WCF Data Service

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
  • Lab : Updating Data by Using WCF Data Services
    • Updating Entities by Using a WCF Data Service
    • Creating and Deleting Entities by Using a WCF Data Service
    • Restricting Create, Update, and Delete Requests

Using ADO.NET   

  • Retrieving and Modifying Data by Using ADO.NET Commands
  • Retrieving and Modifying Data by Using DataSets
  • Managing Transactions and Concurrency in Multiuser Scenarios
  • Lab : Using ADO.NET
    • Using ADO.NET to Retrieve Read-Only Information Quickly and Perform Simple Data Modifications
    • Developing the Product List Web Application
    • Enabling Data Modifications

Using LINQ to SQL   

  • Implementing a Logical Data Model by Using LINQ to SQL
  • Managing Performance and Handling Concurrency
  • Lab : Using LINQ to SQL
    • Using LINQ to SQL to Build a Data Access Layer
    • Updating a Database by Using a Stored Procedure
    • Building a Custom Entity Class

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

What is the sum of 5 + 8? (security question)

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234

Subscribe to our weekly newsletter