com
catherine0@adventure-works.com
kim2@adventure-works.com
humberto0@adventure-works.com
pilar1@adventure-works.com
frances0@adventure-works.com
margaret0@adventure-works.com
carla0@adventure-works.com
jay1@adventure-works.com
Obviously there is much more to LINQ to SQL, but the examples here illustrate what it can do and the
basic features and fundamental concepts of LINQ to SQL.
If you were to query this table via SQL Query Analyzer or SQL ServerManagement Studio, you??™d know
that the Person.Contact table in the AdventureWorks database is 28 rows shy of 20,000, so the preceding
list is only the first nine, but you get the idea. How would you filter this query to return only a specific
few rows?
Typically I like to wait until the third or fourth chapter to start handing out ??????homework assignments,??™??™
but with the background presented in this chapter you should be able to figure this out quite easily. The
Person.Contact table has some additional columns that you can use to filter the results. For example, it
has a column named Title, which contains values such as ??????Mr.
Pages:
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57