MOC 10265a DMOC Developing Data Access Solutions With Visual Studio 2010 Lab Manual

Lab Instructions......Page 1
Module 1:
Lab Instructions: Introduction to Data Access Technologies......Page 3
Lab: Analyzing Data Access Scenarios......Page 4
Exercise 1: Identifying Data Access Technologies......Page 5
Module 2:
Lab Instructions: Building Entity Data Models......Page 8
Lab: Using Entity Data Models......Page 9
Lab Scenario......Page 11
Exercise 1: Generating an EDM from AdventureWorks......Page 12
Exercise 2: Adding Entities and Associations......Page 13
Exercise 3: Using the Generate Database Wizard......Page 16
Exercise 4: Mapping Entities to Multiple Tables......Page 17
Exercise 5: Implementing an Inheritance Hierarchy......Page 19
Exercise 6: Using Stored Procedures......Page 21
Exercise 7: Creating a Complex Type......Page 22
Module 3:
Lab Instructions: Querying Entity Data......Page 24
Lab: Querying Entity Data......Page 25
Exercise 1: Retrieving All Contact Entities......Page 27
Exercise 2: Retrieving Contact Entities by Using a Filter......Page 29
Exercise 3: Retrieving RewardsClaimed Entities......Page 31
Exercise 4: Querying the Rewards Family of Entities......Page 33
Exercise 5: Executing a Stored Procedure......Page 35
Module 4:
Lab Instructions: Creating, Updating, and Deleting Entity Data......Page 37
Lab: Creating, Updating, and Deleting Entity Data......Page 38
Exercise 1: Maintaining Contact and Reward Data......Page 40
Exercise 2: Maintaining RewardsClaim Data......Page 47
Module 5:
Lab Instructions: Handling Multi-User Scenarios by Using Object Services......Page 53
Lab: Handling Multi-User Scenarios by Using Object Services......Page 54
Exercise 1: Handling Concurrency of Rewards Claimed Data......Page 56
Exercise 2: Updating the RewardsClaimed and ArchivedRewardsClaimed Information by Using a Transaction......Page 61
Module 6:
Lab Instructions: Building Optimized Solutions by Using Object Services......Page 65
Lab: Building Optimized Solutions by Using Object Services......Page 66
Exercise 1: Improving the Performance of Query Operations......Page 68
Exercise 2: Improving the Performance of Update Operations......Page 73
Module 7:
Lab Instructions: Customizing Entities and Building Custom Entity Classes......Page 79
Lab: Customizing Entities and Building Custom Entity Classes......Page 80
Exercise 1: Using a Template to Add Custom Functionality to Entity Classes......Page 82
Exercise 2: Creating Custom Entity Classes......Page 87
Module 8:
Lab Instructions: Using POCO Classes with the Entity Framework......Page 92
Lab: Using POCO Classes with the Entity Framework......Page 93
Exercise 1: Using POCO Classes......Page 95
Exercise 2: Extending Your POCO Classes......Page 100
Module 9:
Lab Instructions: Building an N-Tier Solution by Using the Entity Framework......Page 105
Lab: Building an N-Tier Solution by Using the Entity Framework......Page 106
Exercise 1: Creating the Contacts and Orders Data Access Tier......Page 108
Exercise 2: Protecting Data Access Operations......Page 124
Module 10:
Lab Instructions: Handling Updates in an N-Tier Solution by Using the Entity Framework......Page 137
Lab: Handling Updates in an N-Tier Solution by Using the Entity Framework......Page 138
Exercise 1: Handling Updates in the Data Access Tier......Page 140
Exercise 2: Detecting and Handling Order Conflicts......Page 151
Module 11:
Lab Instructions: Building Occasionally Connected Solutions......Page 165
Lab: Building Occasionally Connected Solutions......Page 166
Exercise 1: Modifying the Orders Application to Use Offline XML Data......Page 168
Exercise 2: Modifying the Orders Application to Synchronize Locally Cached Data......Page 179
Module 12:
Lab Instructions: Querying Data by Using WCF Data Services......Page 183
Lab: Creating and Using WCF Data Services......Page 184
Exercise 1: Exposing Order Data as a WCF Data Service......Page 186
Exercise 2: Consuming a WCF Data Service......Page 189
Exercise 3: Restricting Access to Data That a WCF Data Service Exposes......Page 192
Exercise 4: Implementing a Business Operation in a WCF Data Service......Page 194
Module 13:
Lab Instructions: Updating Data by Using WCF Data Services......Page 198
Lab: Updating Data by Using WCF Data Services......Page 199
Exercise 1: Updating Entities by Using a WCF Data Service......Page 201
Exercise 2: Creating and Deleting Entities by Using a WCF Data Service......Page 204
Exercise 3: Restricting Create, Update, and Delete Requests......Page 210
Module 14:
Lab Instructions: Using ADO.NET......Page 213
Lab: Using ADO.NET......Page 214
Exercise 1: Using ADO.NET to Retrieve Read-Only Information Quickly and Perform Simple Data Modifications......Page 216
Exercise 2: Developing the Product List Web Application......Page 231
Exercise 3: Enabling Data Modifications......Page 235
Module 15:
Lab Instructions: Using LINQ to SQL......Page 243
Lab: Using LINQ to SQL......Page 244
Exercise 1: Using LINQ to SQL to Build a Data Access Layer......Page 246
Exercise 2: Updating a Database by Using a Stored Procedure......Page 252
Exercise 3: Building a Custom Entity Class......Page 254
Module 1:
Lab Answer Key: Introduction to Data Access Technologies......Page 261
Exercise 1: Identifying Data Access Technologies......Page 262
Module 2:
Lab Answer Key: Building Entity Data Models......Page 265
Exercise 1: Generating an EDM from AdventureWorks......Page 266
Exercise 2: Adding Entities and Associations......Page 269
Exercise 3: Using the Generate Database Wizard......Page 272
Exercise 4: Mapping Entities to Multiple Tables......Page 280
Exercise 5: Implementing an Inheritance Hierarchy......Page 283
Exercise 6: Using Stored Procedures......Page 288
Exercise 7: Creating a Complex Type......Page 290
Module 3:
Lab Answer Key: Querying Entity Data......Page 292
Exercise 1: Retrieving All Contact Entities......Page 293
Exercise 2: Retrieving Contact Entities by Using a Filter......Page 298
Exercise 3: Retrieving RewardsClaimed Entities......Page 303
Exercise 4: Querying the Rewards Family of Entities......Page 308
Exercise 5: Executing a Stored Procedure......Page 315
Module 4:
Lab Answer Key: Creating, Updating, and Deleting Entity Data......Page 319
Exercise 1: Maintaining Contact and Reward Data......Page 320
Exercise 2: Maintaining RewardsClaim Data......Page 352
Module 5:
Lab Answer Key: Handling Multi-User Scenarios by Using Object Services......Page 371
Exercise 1: Handling Concurrency of Rewards Claimed Data......Page 372
Exercise 2: Updating the RewardsClaimed and ArchivedRewardsClaimed Information by Using a Transaction......Page 387
Module 6:
Lab Answer Key: Building Optimized Solutions by Using Object Services......Page 400
Exercise 1: Improving the Performance of Query Operations......Page 401
Exercise 2: Improving the Performance of Update Operations......Page 412
Module 7:
Lab Answer Key: Customizing Entities and Building Custom Entity Classes......Page 440
Exercise 1: Using a Template to Add Custom Functionality to Entity Classes......Page 441
Exercise 2: Creating Custom Entity Classes......Page 461
Module 8:
Lab Answer Key: Using POCO Classes with the Entity Framework......Page 491
Exercise 1: Using POCO Classes......Page 492
Exercise 2: Extending Your POCO Classes......Page 505
Module 9:
Lab Answer Key: Building an N-Tier Solution by Using the Entity Framework......Page 517
Exercise 1: Creating the Contacts and Orders Data Access Tier......Page 518
Exercise 2: Protecting Data Access Operations......Page 566
Module 10:
Lab Answer Key: Handling Updates in an N-Tier Solution by Using the Entity Framework......Page 586
Exercise 1: Handling Updates in the Data Access Tier......Page 587
Exercise 2: Detecting and Handling Order Conflicts......Page 611
Module 11:
Lab Answer Key: Building Occasionally Connected Solutions......Page 651
Exercise 1: Modifying the Orders Application to Use Offline XML Data......Page 652
Exercise 2: Modifying the Orders Application to Synchronize Locally Cached Data......Page 691
Module 12:
Lab Answer Key: Querying Data by Using WCF Data Services......Page 701
Exercise 1: Exposing Order Data as a WCF Data Service......Page 702
Exercise 2: Consuming a WCF Data Service......Page 709
Exercise 3: Restricting Access to Data That a WCF Data Service Exposes......Page 714
Exercise 4: Implementing a Business Operation in a WCF Data Service......Page 720
Module 13:
Lab Answer Key: Updating Data by Using WCF Data Services......Page 728
Exercise 1: Updating Entities by Using a WCF Data Service......Page 729
Exercise 2: Creating and Deleting Entities by Using a WCF Data Service......Page 735
Exercise 3: Restricting Create, Update, and Delete Requests......Page 752
Module 14:
Lab Answer Key: Using ADO.NET......Page 759
Exercise 1: Using ADO.NET to Retrieve Read-Only Information Quickly and Perform Simple Data Modifications......Page 760
Exercise 2: Developing the Product List Web Application......Page 797
Exercise 3: Enabling Data Modifications......Page 806
Module 15:
Lab Answer Key: Using LINQ to SQL......Page 824
Exercise 1: Using LINQ to SQL to Build a Data Access Layer......Page 825
Exercise 2: Updating a Database by Using a Stored Procedure......Page 839
Exercise 3: Building a Custom Entity Class......Page 842