NET 179
Creating XML 179
Overview of XML Literals 180
Expressions 182
Embedding Queries 184
Understanding Whitespace in Visual Basic XML Literals 184
Accessing XML 185
Loading XML 188
Manipulating XML Using the ParseMethod 189
LINQ to XML Visual Basic Example 191
Summary 194
Part III: LINQ to SQL
Chapter 10: LINQ to SQL Overview 199
Understanding LINQ to SQL 200
LINQ to SQL Object Model 201
Attribute-BasedMapping 202
Using the Database Attribute 202
Mapping Tables 203
Mapping Columns 203
Mapping Relationships 206
Mapping Stored Procedures 207
Mapping Functions 208
Using the Parameter Attribute 209
The Basics of Relational Data 209
Primary Keys 210
Foreign Keys 212
Summary 215
Chapter 11: LINQ to SQL Queries 217
Query Concepts 217
DataContext 219
xviii
Contents
Strongly Typed DataContext 220
Data Manipulation 221
Insert 222
Update 224
Delete 225
Working with Objects 225
Insert 225
Update 226
Delete 226
Stored Procedures and User-Defined Functions 227
Mapping and Calling Stored Procedures 227
Mapping and Calling User-Defined Functions 240
Summary 244
Chapter 12: Advanced Query Concepts 245
Database Relationships 245
Representing Relationships 245
Querying 250
Compiled Queries 251
Remote versus Local Query Execution 251
Remote Execution 252
Local Execution 252
Deferred versus Immediate Data Loading 252
DataShape Class 254
Turning Off Deferred Loading 254
Composite Keys 255
Read-Only Data 255
Summary 256
Chapter 13: More about Entity Classes 257
Tracking Entity Changes 258
Submitting Entity Changes 258
Concurrent Changes and Concurrency Conflicts 263
UpdateCheck 263
ConflictMode 264
ChangeConflictException 265
RefreshMode 265
Utilizing Transactions 267
Summary 269
xix
Contents
Chapter 14: LINQ to DataSet 271
Overview of LINQ to DataSet 272
Creating a LINQ to DataSet Project 272
Loading Data into a DataSet 273
Using the DataAdapater 273
LINQ to DataSet Queries 275
Querying a Single Table 275
Querying across Multiple Tables 277
Typed DataSets 278
Data Binding 279
Comparing DataRows 281
Summary 284
Chapter 15: Advanced LINQ to SQL Topics 287
Object Relational Designer 287
Creating and Opening the O/R Designer 288
Creating/Configuring the DataContext 288
Creating Entity Classes for Tables/View Mapping 290
DataContext Mapping for Stored Procedures/Functions 292
Calling Stored Procedures to Save Data Using Entity Classes 293
Extending O/R Designer-Generated Code 294
Pluralization of Classes in the O/R Designer 296
SQLMetal 296
External Mapping 299
Multi-Tier Operations 302
N-Tier Best Practices 303
Optimistic Concurrency 303
Insertion/Deletion 304
N-Tier Examples 304
Designer Example 305
Summary 310
Appendixes
Appendix A: Case Study 313
Appendix B: LINQ to Entities: The ADO.
Pages:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25