Architecture and Data Access Technologies
o Data Access Technologies
o Data Access Scenarios
Building Entity Data Models
o Introduction to Entity Data Models
o Modifying the Entity Data Model
o Customizing the Entity Data Model
Querying Entity Data
o Retrieving Data by Using LINQ to Entities
o Retrieving Data by Using Entity SQL
o Retrieving Data by Using EntityClient Provider
o Retrieving Data by Using Stored Procedures
o Unit Testing Your Data Access Code
Creating, Updating, and Deleting Entity Data
o Understanding Change Tracking in the Entity Framework
o Modifying Data in an Entity Data Model
Handling Multi-User Scenarios by Using Object Services
o Handling Concurrency in the Entity Framework
o Transactional Support in the Entity Framework
Building Optimized Solutions by Using Object Services
o The Stages of Query Execution
o Change Tracking and Object Materialization
o Using Compiled Queries
o Using Design-Time Generated Entity Framework Views
o Monitoring Performance
o Performing Asynchronous Data Modifications
Customizing Entities and Building Custom Entity Classes
o Overriding Generated Classes
o Using Templates to Customize Entities
o Creating and Using Custom Entity Classes
Using POCO Classes with the Entity Framework
o Requirements for POCO Classes
o POCO Classes and Lazy Loading
o POCO Classes and Change Tracking
o Extending Entity Types
Building an N-Tier Solution by Using the Entity Framework
o Designing an N-Tier Solution
o Defining Operations and Implementing Data Transport Structures
o Protecting Data and Operations
Handling Updates in an N-Tier Solution by Using the Entity Framework
o Tracking Entities and Persisting Changes
o Managing Exceptions in an N-Tier Solution
Building Occasionally Connected Solutions
o Offline Data Caching by Using XML
o Using the Sync Framework
Querying Data by Using WCF Data Services
o Introduction to WCF Data Services
o Creating a WCF Data Service
o Consuming a WCF Data Service
o Protecting Data and Operations in a WCF Data Service
Updating Data by Using WCF Data Services
o Creating, Updating, and Deleting Data in a WCF Data Service
o Preventing Unauthorized Updates and Improving Performance
o Using WCF Data Services with Nonrelational Data
Using ADO.NET
o Retrieving and Modifying Data by Using ADO.NET Commands
o Retrieving and Modifying Data by Using DataSets
o Managing Transactions and Concurrency in Multiuser Scenarios
Using LINQ to SQL
o Implementing a Logical Data Model by Using LINQ to SQL
o Managing Performance and Handling Concurrency
