Doel

Het leren omgaan met Visual Studio .NET 2010-datatechnieken, zoals ADO.NET, Entity Framework, LINQ, WCF Data Services en het Sync Framework.

Architecture and Data Access Technologies:

• Data Access Technologies
• Data Access Scenarios.

Entity Data Models:

• Introduction to Entity Data Models
• Modifying the Entity Data Model
• Customizing the Entity Data Model
• 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
• Understanding Change Tracking in the Entity Framework
• Modifying Data in an Entity Data Model
• Handling Concurrency in the Entity Framework
• Transactional Support in the Entity Framework.

Advanced Entity Framework:

• 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
• Overriding Generated Classes
• Using Templates to Customize Entities
• Creating and Using Custom Entity Classes
• Requirements for POCO Classes
• POCO Classes and Lazy Loading
• POCO Classes and Change Tracking
• Extending Entity Types
• Designing an N-Tier Solution
• Defining Operations and Implementing Data Transport Structures
• Protecting Data and Operations
• Tracking Entities and Persisting Changes
• Managing Exceptions in an N-Tier Solution.

Building Occasionally Connected Solutions:

• Offline Data Caching by Using XML
• Using the Sync Framework.

Using WCF Data Services:

• Creating a WCF Data Service
• Consuming a WCF Data Service
• Protecting Data and Operations in a WCF Data Service
• Creating, Updating, and Deleting Data in a WCF Data Service
• Preventing Unauthorized Updates and Improving Performance
• Using WCF Data Services with Nonrelational Data.

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.

Using LINQ to SQL:

• Implementing a Logical Data Model by Using LINQ to SQL
• Managing Performance and Handling Concurrency