MOC 10265a DMOC Developing Data Access Solutions With Visual Studio 2010 Trainer WorkBook Vol2

Developing Data Access Solutions
with Microsoft® Visual Studio® 2010......Page 1
Module 10:
Handling Updates in an N-Tier Solution by Using the Entity Framework......Page 19
Module Overview......Page 20
Lesson 1:
Tracking Entities and Persisting Changes......Page 21
Tracking Changes in an N-Tier Solution......Page 23
Change Tracking with Self-Tracking Entities in an N-Tier Solution......Page 26
Demonstration: Change Tracking with Self-Tracking Entities in an N-Tier Solution
......Page 33
Change Tracking with Simple Entities in an N-Tier Solution......Page 35
Demonstration: Change Tracking with Simple Entities in an N-Tier Solution
......Page 44
Change Tracking with Data Transfer Objects in an N-Tier Solution......Page 46
Demonstration: Change Tracking with Data Transfer Objects in an N-Tier Solution
......Page 55
Connecting to the Database......Page 57
Lesson 2:
Managing Exceptions in an N-Tier Solution......Page 60
The UpdateException and OptimisticConcurrencyException Exceptions......Page 61
Handling OptimisticConcurrencyException Exceptions in the Client......Page 63
Managing Concurrency with Self-Tracking Entities......Page 65
Demonstration: Managing Concurrency with Self-Tracking Entities......Page 70
Lab: Handling Updates in an N-Tier Solution by Using the Entity Framework......Page 72
Exercise 1: Handling Updates in the Data Access Tier......Page 74
Exercise 2: Detecting and Handling Order Conflicts......Page 85
Lab Review......Page 99
Module Review and Takeaways......Page 100
Module 11:
Building Occasionally Connected Solutions......Page 103
Module Overview......Page 104
Lesson 1:
Offline Data Caching by Using XML......Page 105
Detecting the Availability of a Web Service......Page 107
Introduction to LINQ to XML......Page 110
LINQ to XML Classes......Page 112
Persisting Entity Data to Local XML Files......Page 114
Loading Data from XML Files into Entities......Page 116
Encrypting XML Files......Page 118
Lesson 2:
Using the Sync Framework......Page 124
Synchronization Scenarios......Page 126
Understanding Synchronization......Page 128
Synchronization vs. Merge Replication and RDA......Page 130
Sync Framework Architecture......Page 133
Configuring Synchronization......Page 135
Synchronizing Data......Page 138
Handling Conflicts......Page 141
Using the Configure Data Synchronization Dialog Box......Page 144
Security Considerations for Synchronization......Page 147
Lab: Building Occasionally Connected Solutions......Page 148
Exercise 1: Modifying the Orders Application to Use Offline XML Data......Page 150
Exercise 2: Modifying the Orders Application to Synchronize Locally Cached Data......Page 161
Lab Review......Page 165
Module Review and Takeaways......Page 166
Module 12:
Querying Data by Using WCF Data Services......Page 169
Module Overview......Page 170
Lesson 1:
Introducing WCF Data Services......Page 171
Introduction to the REST Model......Page 172
The Role of the Open Data Protocol......Page 174
Exposing Data by Using a WCF Data Service......Page 176
Hosting a WCF Data Service......Page 179
Lesson 2:
Creating a WCF Data Service......Page 184
Building a WCF Data Service for an Entity Data Model......Page 186
Accessing a WCF Data Service by Using a Web Browser......Page 190
Filtering, Selecting, and Ordering Data by Using Query Expressions......Page 195
Paging Through Data That a WCF Data Service Exposes......Page 199
Configuring a WCF Data Service by Using a DataServiceConfiguration Object......Page 203
Handling Exceptions in a WCF Data Service......Page 207
Implementing Operations in a WCF Data Service......Page 211
Deploying a WCF Data Service......Page 217
Lesson 3:
Consuming a WCF Data Service......Page 221
Generating the Client Library for a WCF Data Service......Page 223
Querying Data in a Client Application......Page 226
Filtering and Projecting Data in a Client Application......Page 232
Handling Associations Between Entities......Page 237
Handling WCF Data Service Exceptions in a Client Application......Page 242
Invoking WCF Data Service Operations......Page 244
Materializing Data from a WCF Data Service into a Custom Type......Page 249
Lesson 4:
Protecting Data and Operations in a WCF Data Service......Page 252
Protecting a WCF Data Service......Page 254
Granting Access to Entities......Page 257
Restricting Data Access by Using Query Interceptors......Page 260
Granting Access to Operations......Page 263
Lab: Creating and Using WCF Data Services......Page 267
Exercise 1: Exposing Order Data as a WCF Data Service......Page 269
Exercise 2: Consuming a WCF Data Service......Page 272
Exercise 3: Restricting Access to Data That a WCF Data Service Exposes......Page 275
Exercise 4: Implementing a Business Operation in a WCF Data Service......Page 277
Lab Review......Page 281
Module Review and Takeaways......Page 282
Module 13:
Updating Data by Using WCF Data Services......Page 285
Module Overview......Page 286
Lesson 1:
Creating, Updating, and Deleting Data in a WCF Data Service......Page 287
WCF Data Services Data Modifications and the HTTP Protocol......Page 289
Using the WCF Data Services Client Library......Page 293
Modifying Data by Using the WCF Data Services Client Library......Page 295
Handling Data-Modification Errors in the Client......Page 300
Managing Entity Relationships......Page 302
Managing Concurrency......Page 305
Lesson 2:
Preventing Unauthorized Updates and Improving Performance......Page 306
Preventing Unauthorized Updates......Page 308
Batching Multiple Operations......Page 312
Lesson 3:
Using WCF Data Services with Nonrelational Data......Page 314
Demonstration: Creating a WCF Data Service to Access Nonrelational Data......Page 315
Using the Reflection Provider......Page 317
Working with Binary Data......Page 320
Lab: Updating Data by Using WCF Data Services......Page 326
Exercise 1: Updating Entities by Using a WCF Data Service......Page 328
Exercise 2: Creating and Deleting Entities by Using a WCF Data Service......Page 331
Exercise 3: Restricting Create, Update, and Delete Requests......Page 337
Lab Review......Page 340
Module Review and Takeaways......Page 341
Module 14:
Using ADO.NET......Page 343
Module Overview......Page 344
Lesson 1: Retrieving and Modifying Data by Using ADO.NET Commands
......Page 346
Introduction to Data Providers......Page 348
Connecting to a Data Source by Using a DbConnection Object......Page 350
Executing Commands by Using a DbCommand Object......Page 354
Retrieving Data by Using a DbDataReader Object......Page 360
Implementing Create, Update, and Delete Operations by Using a DbCommand Object......Page 364
Querying and Maintaining Data by Using Stored Procedures......Page 367
Querying BLOB and FILESTREAM Data......Page 371
Lesson 2:
Retrieving and Modifying Data by Using DataSets......Page 376
What Is a DataSet Object?......Page 378
Populating a DataSet Object and Accessing Data......Page 381
Using Typed and Untyped DataSet Classes......Page 385
Creating, Modifying, and Deleting Data by Using a DataSet Object......Page 389
Validating Data and Saving Changes......Page 395
Lesson 3:
Managing Transactions and Concurrency in Multiuser Scenarios......Page 400
Using Transactions......Page 402
Understanding Isolation Levels......Page 408
Handling Concurrency Violations......Page 412
Lab: Using ADO.NET......Page 414
Exercise 1: Using ADO.NET to Retrieve Read-Only Information Quickly and Perform Simple Data Modifications......Page 416
Exercise 2: Developing the Product List Web Application......Page 431
Exercise 3: Enabling Data Modifications......Page 435
Lab Review......Page 443
Module Review and Takeaways......Page 444
Module 15:
Using LINQ to SQL......Page 447
Module Overview......Page 448
Lesson 1:
Implementing a Logical Data Model by Using LINQ to SQL......Page 450
The LINQ to SQL Object Model......Page 452
Modeling Associations and Relationships......Page 456
Building a LINQ to SQL Object Model by Using the Object Relational Designer......Page 460
Demonstration: Creating a LINQ to SQL Object Model......Page 464
The DataContext Class......Page 466
Retrieving Data by Using LINQ to SQL......Page 469
Making Changes and Updating a Database......Page 474
Customizing Insert, Update, and Delete Operations by Using Stored Procedures......Page 478
Lesson 2:
Managing Performance and Handling Concurrency......Page 481
Improving Throughput and Consistency by Using Immediate Loading......Page 483
Improving Performance with LINQ to SQL......Page 487
Examining SQL Commands and Change Sets......Page 491
Handling Change Conflicts......Page 495
Lab: Using LINQ to SQL......Page 500
Exercise 1: Using LINQ to SQL to Build a Data Access Layer......Page 502
Exercise 2: Updating a Database by Using a Stored Procedure......Page 508
Exercise 3: Building a Custom Entity Class......Page 510
Lab Review......Page 517
Module Review and Takeaways......Page 518
Course Evaluation......Page 520
Exercise 1: Identifying Data Access Technologies......Page 521
Exercise 1: Generating an EDM from AdventureWorks......Page 525
Exercise 2: Adding Entities and Associations......Page 528
Exercise 3: Using the Generate Database Wizard......Page 532
Exercise 4: Mapping Entities to Multiple Tables......Page 539
Exercise 5: Implementing an Inheritance Hierarchy......Page 543
Exercise 6: Using Stored Procedures......Page 547
Exercise 7: Creating a Complex Type......Page 549
Exercise 1: Retrieving All Contact Entities......Page 551
Exercise 2: Retrieving Contact Entities by Using a Filter......Page 556
Exercise 3: Retrieving RewardsClaimed Entities......Page 561
Exercise 4: Querying the Rewards Family of Entities......Page 567
Exercise 5: Executing a Stored Procedure......Page 573
Exercise 1: Maintaining Contact and Reward Data......Page 577
Exercise 2: Maintaining RewardsClaim Data......Page 609
Exercise 1: Handling Concurrency of Rewards Claimed Data......Page 627
Exercise 2: Updating the RewardsClaimed and ArchivedRewardsClaimed Information by Using a Transaction......Page 642
Exercise 1: Improving the Performance of Query Operations......Page 655
Exercise 2: Improving the Performance of Update Operations......Page 666
Exercise 1: Using a Template to Add Custom Functionality to Entity Classes......Page 695
Exercise 2: Creating Custom Entity Classes......Page 715
Exercise 1: Using POCO Classes......Page 745
Exercise 2: Extending Your POCO Classes......Page 758
Exercise 1: Creating the Contacts and Orders Data Access Tier......Page 771
Exercise 2: Protecting Data Access Operations......Page 819
Exercise 1: Handling Updates in the Data Access Tier......Page 839
Exercise 2: Detecting and Handling Order Conflicts......Page 863
Exercise 1: Modifying the Orders Application to Use Offline XML Data......Page 903
Exercise 2: Modifying the Orders Application to Synchronize Locally Cached Data......Page 942
Exercise 1: Exposing Order Data as a WCF Data Service......Page 953
Exercise 2: Consuming a WCF Data Service......Page 960
Exercise 3: Restricting Access to Data That a WCF Data Service Exposes......Page 965
Exercise 4: Implementing a Business Operation in a WCF Data Service......Page 971
Exercise 1: Updating Entities by Using a WCF Data Service......Page 979
Exercise 2: Creating and Deleting Entities by Using a WCF Data Service......Page 985
Exercise 3: Restricting Create, Update, and Delete Requests......Page 1002
Exercise 1: Using ADO.NET to Retrieve Read-Only Information Quickly and Perform Simple Data Modifications......Page 1009
Exercise 2: Developing the Product List Web Application......Page 1046
Exercise 3: Enabling Data Modifications......Page 1055
Exercise 1: Using LINQ to SQL to Build a Data Access Layer......Page 1073
Exercise 2: Updating a Database by Using a Stored Procedure......Page 1087
Exercise 3: Building a Custom Entity Class......Page 1090