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