Course 10265: Developing Data Access Solutions with Microsoft Visual Studio 2010

This course is already delivered, please contact us for the next available session tel:+357 22 44 14 92
Course Outline in PDF

Overview:

In this course, experienced developers who know the basics of data access (CRUD) in Windows client and Web application environments will learn to optimize their designs and develop better performing data access code by using the ADO.NET Entity Framework, LINQ, WCF Data Services, the Sync Framework, and ADO.NET.

Who Should Attend:

This course is for professional .NET software developers who use Microsoft Visual Studio in a team-based, medium-sized to large development environment

At Course Completion:

After completing this course, students will be able to:
•Experience developing n-tier applications that access various data sources
•Experience implementing data binding within their applications
•Some experience using LINQ and ADO.NET
•A conceptual understanding of the Entity Framework
•Experience using Visual Studio 2008 in the following task areas:
•Declaring and initializing typed variables using the Camel case naming convention
•Using arithmetic, relational, and logical operators in code statements
•Using branching statements to control code execution
•Using looping statements to iterate through collections or repeat steps until a specified condition is met
•Declaring, raising, and handling events
•Responding to and throwing exceptions
•Implementing interfaces and polymorphism
•Implementing shared and static members
•Implementing generics
•Creating components and class libraries
•Implementing basic service calls: Basics of creating and consuming XML Web Services, Basics of creating and consuming WCF Services
•Using .NET Configuration Files
•Deploying .Net Framework Applications using ClickOnce and the MS Installer
•Data Access experience in Windows Client application development as follows:
•Connect to a data source
•Implement data binding
•Implement data validation at the UI layer

Outline:   

Module 1: Architecture and Data Access Technologies

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

Module 2: Building Entity Data Models

Lessons
•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
•Adding Entities and Associations
•Using the Generate Database Wizard
•Mapping Entities to Multiple Tables
•Implementing an Inheritance Hierarchy
•Using Stored Procedures
•Creating a Complex Type

Module 3: Querying Entity Data

Lessons
•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

Module 4: Creating, Updating, and Deleting Entity Data

Lessons
•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

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

Lessons
•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

Module 6: Building Optimized Solutions by Using Object Services.

Lessons
•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

Module 7: Customizing Entities and Building Custom Entity Classes

Lessons
•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

Module 8: Using POCO Classes with the Entity Framework

Lessons
•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

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

Lessons
•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

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

Lessons
•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

Module 11: Building Occasionally Connected Solutions

Lessons
•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

Module 12: Querying Data by Using WCF Data Services

Lessons
•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

Module 13: Updating Data by Using WCF Data Services

Lessons
•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

Module 14: Using ADO.NET

Lessons
•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

Module 15: Using LINQ to SQL

Lessons
•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

 

sd sd sd sd sd sd sd sd sd sd sd sd