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

Developing Data Access Solutions
with Microsoft® Visual Studio® 2010......Page 1
Student Prerequisites......Page 19
Course Objectives......Page 20
Course Outline......Page 21
Course Materials......Page 24
Virtual Machine Configuration......Page 26
Course Hardware Level......Page 27
Module 1:
Introduction to Data Access Technologies......Page 29
Module Overview......Page 30
Lesson 1:
Data Access Technologies......Page 31
Overview of the ADO.NET Entity Framework......Page 32
Overview of LINQ......Page 34
Overview of the Sync Framework......Page 36
Overview of WCF Data Services......Page 38
Overview of ADO.NET......Page 40
Lesson 2:
Data Access Scenarios......Page 42
New Development Projects......Page 43
Legacy Applications......Page 46
Lab: Analyzing Data Access Scenarios......Page 47
Exercise 1: Identifying Data Access Technologies......Page 48
Lab Review......Page 51
Module Review and Takeaways......Page 52
Module 2:
Building Entity Data Models......Page 53
Module Overview......Page 54
Lesson 1:
Introduction to Entity Data Models......Page 55
Introduction to Data Models......Page 56
Model Design Strategies......Page 58
Introduction to the Entity Designer......Page 60
Demonstration: Creating a Model from a Database......Page 62
Mapping a Model to a Database......Page 64
The XML Behind the Model......Page 65
Demonstration: Reviewing the Model's XML......Page 67
Model Deployment Considerations......Page 68
Lesson 2:
Modifying an Entity Data Model......Page 70
Adding Entities to a Model......Page 71
Adding Associations Between Entities......Page 73
Demonstration: Adding Entities and Associations......Page 75
Generating Transact-SQL Scripts from a Model......Page 77
Demonstration: Generating Transact-SQL Scripts......Page 79
Lesson 3:
Customizing an Entity Data Model......Page 81
Using Entity Splitting......Page 83
Demonstration: Using Entity Splitting......Page 85
Implementing an Inheritance Hierarchy......Page 87
Adding a Stored Procedure to a Model......Page 89
Demonstration: Adding a Stored Procedure......Page 91
Using Complex Types......Page 93
Lab: Using Entity Data Models......Page 95
Lab Scenario......Page 97
Exercise 1: Generating an EDM from AdventureWorks......Page 98
Exercise 2: Adding Entities and Associations......Page 99
Exercise 3: Using the Generate Database Wizard......Page 102
Exercise 4: Mapping Entities to Multiple Tables......Page 103
Exercise 5: Implementing an Inheritance Hierarchy......Page 105
Exercise 6: Using Stored Procedures......Page 107
Exercise 7: Creating a Complex Type......Page 108
Lab Review......Page 110
Module Review and Takeaways......Page 111
Module 3:
Querying Entity Data......Page 113
Module Overview......Page 114
Lesson 1:
Retrieving Data by Using LINQ to Entities......Page 116
Connecting to the Conceptual Model......Page 118
Defining the Query......Page 121
Executing the Query......Page 126
Lesson 2:
Retrieving Data by Using Entity SQL......Page 131
Entity SQL Syntax......Page 132
Using Entity SQL......Page 135
Lesson 3:
Retrieving Data by Using the EntityClient Provider......Page 138
Understanding the EntityClient Provider for the Entity Framework......Page 139
Connecting to the Model by Using an EntityConnection Object......Page 141
Creating Queries by Using an EntityCommand Object......Page 143
Processing Query Results by Using an EntityDataReader Object......Page 146
Lesson 4:
Retrieving Data by Using Stored Procedures......Page 150
Invoking Stored Procedures......Page 151
Invoking Stored Procedures with Output Parameters......Page 153
Lesson 5:
Unit Testing Your Data Access Code......Page 155
Establishing a Unit-Testing Environment......Page 156
Creating Unit Tests......Page 158
Demonstration: Adding a Unit Test Project......Page 162
Lab: Querying Entity Data......Page 164
Exercise 1: Retrieving All Contact Entities......Page 166
Exercise 2: Retrieving Contact Entities by Using a Filter......Page 168
Exercise 3: Retrieving RewardsClaimed Entities......Page 170
Exercise 4: Querying the Rewards Family of Entities......Page 172
Exercise 5: Executing a Stored Procedure......Page 174
Lab Review......Page 176
Module Review and Takeaways......Page 177
Module 4:
Creating, Updating, and Deleting Entity Data......Page 179
Module Overview......Page 180
Lesson 1:
Understanding Change Tracking in the Entity Framework......Page 181
The ObjectContext and ObjectStateManager Classes......Page 183
Attaching and Detaching Objects......Page 186
Change Tracking and Identity Resolution......Page 188
Lesson 2:
Modifying Data in an Entity Data Model......Page 190
Creating and Saving a New Entity......Page 192
Updating and Saving an Entity......Page 195
Deleting an Entity from an Entity Set......Page 198
Using Stored Procedures to Persist Changes to the Database......Page 200
Demonstration: Adding Stored Procedures to the Model......Page 204
Lab: Creating, Updating, and Deleting Entity Data......Page 206
Exercise 1: Maintaining Contact and Reward Data......Page 208
Exercise 2: Maintaining RewardsClaim Data......Page 215
Lab Review......Page 221
Module Review and Takeaways......Page 222
Module 5:
Handling Multi-User Scenarios by Using Object Services......Page 225
Module Overview......Page 226
Lesson 1:
Handling Concurrency in the Entity Framework......Page 227
Concurrent Data Access......Page 229
How the Entity Framework Detects Concurrency Conflicts......Page 231
Demonstration: Setting Concurrency Options in the Model......Page 233
Handling Optimistic Concurrency Exceptions......Page 235
Creating Unit Tests to Verify Concurrency Behavior......Page 239
Lesson 2:
Transactional Support in the Entity Framework......Page 243
Transactions and the Entity Framework......Page 244
Managing Transactions in the Entity Framework......Page 246
Retrying Failed Transactions......Page 252
Lab: Handling Multi-User Scenarios by Using Object Services......Page 256
Exercise 1: Handling Concurrency of Rewards Claimed Data......Page 258
Exercise 2: Updating the RewardsClaimed and ArchivedRewardsClaimed Information by Using a Transaction......Page 263
Lab Review......Page 267
Module Review and Takeaways......Page 268
Module 6:
Building Optimized Solutions by Using Object Services......Page 271
Module Overview......Page 272
Lesson 1:
The Stages of Query Execution......Page 273
The Query Execution Process......Page 274
Performance Enhancement Options......Page 277
Lesson 2:
Change Tracking and Object Materialization......Page 279
The Life Cycle of Entity Objects......Page 280
Entity Materialization......Page 283
The Impact of Change Tracking on Performance......Page 286
Lesson 3:
Using Compiled Queries......Page 288
The Benefits of Compiled Queries......Page 289
How to Compile a Query......Page 290
Lesson 4:
Using Design-Time Generated Entity Framework Views......Page 294
The Benefits and Drawbacks of Design-Time Generated Views......Page 295
Demonstration: Generating Views at Design Time to Improve Query Performance......Page 297
Lesson 5:
Monitoring Performance......Page 299
Logging SQL Statements Generated by the Entity Framework......Page 301
Using Performance Monitor......Page 304
Lesson 6:
Performing Asynchronous Data Modifications......Page 307
The Benefits of Asynchronous Data Modifications......Page 308
How to Perform Asynchronous Data Modifications......Page 310
Lab: Building Optimized Solutions by Using Object Services......Page 314
Exercise 1: Improving the Performance of Query Operations......Page 316
Exercise 2: Improving the Performance of Update Operations......Page 321
Lab Review......Page 327
Module Review and Takeaways......Page 328
Module 7:
Customizing Entities and Building Custom Entity Classes......Page 331
Module Overview......Page 332
Lesson 1:
Overriding Generated Classes......Page 333
Using Partial Classes......Page 334
Using Partial Property Change Methods......Page 336
Demonstration: Using the OnChanging Method......Page 338
Using Partial Events......Page 340
Creating Extension Methods......Page 345
Lesson 2:
Using Templates to Customize Entities......Page 347
Adding Code Generation Items to a Model......Page 349
Code Generation Templates......Page 351
Defining Custom Interfaces in a Template......Page 354
Implementing Template Interfaces in a Model......Page 358
Using the Template Implementation......Page 360
Demonstration: Using Templates to Customize Entities......Page 362
Lesson 3:
Creating and Using Custom Entity Classes......Page 364
Defining a Custom Entity Class......Page 365
Using Entity Attributes......Page 367
Customizing an EDM for Custom Classes......Page 370
Developing Entity Properties......Page 372
Using a Custom Entity Class......Page 375
Lab: Customizing Entities and Building Custom Entity Classes......Page 377
Exercise 1: Using a Template to Add Custom Functionality to Entity Classes......Page 379
Exercise 2: Creating Custom Entity Classes......Page 384
Lab Review......Page 389
Module Review and Takeaways......Page 390
Module 8:
Using POCO Classes with the Entity Framework......Page 393
Module Overview......Page 394
Lesson 1:
Requirements for POCO Classes......Page 395
What Are POCO Entity Classes?......Page 396
Defining a Custom ObjectContext Class......Page 398
Demonstration: Switching Off Object Layer Generation......Page 402
Lesson 2:
POCO Classes and Lazy Loading......Page 404
Requirements for Lazy Loading......Page 405
Explicitly Loading POCO Entities......Page 407
Lesson 3:
POCO Classes and Change Tracking......Page 410
Requirements for Change Tracking......Page 411
Tracking Changes in POCO Entity Objects by Using Snapshots......Page 413
Lesson 4:
Extending Entity Types......Page 415
Extending Generated Types......Page 416
Interfaces and Inheritance for Custom Entity Types......Page 418
Lab: Using POCO Classes with the Entity Framework......Page 421
Exercise 1: Using POCO Classes......Page 423
Exercise 2: Extending Your POCO Classes......Page 428
Lab Review......Page 433
Module Review and Takeaways......Page 434
Module 9:
Building an N-Tier Solution by Using the Entity Framework......Page 437
Module Overview......Page 438
Lesson 1:
Designing an N-Tier Solution......Page 440
Architectural Issues......Page 441
Strategies for N-Tier Applications......Page 444
Hosting Your Service......Page 446
Lesson 2:
Defining Operations and Implementing Data Transport Structures......Page 448
Demonstration: Using the Self-Tracking Entity T4 Template......Page 450
Data Transport Structures......Page 452
Creating a WCF Service......Page 456
Working with Parent/Child Relationships......Page 463
Demonstration: Examining an End-to-End Example......Page 466
Lesson 3:
Protecting Data and Operations......Page 468
Authentication and Authorization......Page 469
Encrypting Data......Page 472
Protecting Against Common Attacks......Page 474
Lab: Building an N-Tier Solution by Using the Entity Framework......Page 476
Exercise 1: Creating the Contacts and Orders Data Access Tier......Page 478
Exercise 2: Protecting Data Access Operations......Page 494
Lab Review......Page 507
Module Review and Takeaways......Page 508