EmailAddress,
hre.EmployeeID, hre.NationalIDNumber, hre.Title, hre.HireDate
FROM Person.Contact pc
INNER JOIN HumanResources.Employee hre ON pc.ContactID = hre.ContactID
ORDER BY pc.LastName
The key, then, is to apply this same join functionality in LINQ to SQL. You accomplish that through
types that assist in representing the primary key/foreign key relationships between tables within a
database. These two types are the EntitySet and EntityRef generic types, each of which is of type(of
TEntity). These types provide collections for the ??????many??™??™ part of a one-to-many relationship. Both the
EntitySet and EntityRef types are used in conjunction with the [Association] attribute, which helps
define and represent a relationship.
EntitySet (of TEntity)
The EntitySet type provides a collection for the results of the ??????many??™??™ side of a one-to-many relationship.
In other words, it signifies that the defined relationship is a one-to-many relationship. As stated
earlier, it is used together with the [Association] attribute to define and represent a relationship.
Pages:
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397