In the example, the entity class and associated column properties will persist the
Title, FirstName, MiddleName, LastName, EmailAddress, and EmailPromotion columns from the
Person.Contact table to and from the database. Any other columns in the table will not be persisted
and are considered transient.
205
Part III: LINQ to SQL
Mapping Relationships
Queries to the database generally require pulling information from multiple tables, not just a single table.
Those tables are typically joined via a primary key/foreign key relationship. LINQ to SQL??™s Association
attribute can represent those database associations.
The Association attribute??™s properties are described in the following table. They can be used to
customize the associations.
Property Description
Name The name of the association.
Storage Specifies the storage field/variable.
IsUnique Specifies whether the FK is a unique
constraint.
IsForeignKey Specifies whether the association/
constraint is a foreign key.
ThisKey Identifies members of the entity
class to represent the key values on
this side of the association.
Pages:
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340