Chapter 3: Stepping Beyond theBasics ������������������������������������������������������������������ 97
Specifying Fields ......................................................................................................................... 98
Joins ......................................................................................................................................... 101
Left Outer Join ..................................................................................................................... 102
Right Outer Join ................................................................................................................... 104
Cross Join ............................................................................................................................ 109
Inner Join: Method Syntax ................................................................................................... 110
Grouping.................................................................................................................................... 112
Query Syntax ....................................................................................................................... 112
Method Syntax ..................................................................................................................... 114
Logical Operators ...................................................................................................................... 115
Logical OR ........................................................................................................................... 119
Paging andFiltering Results ..................................................................................................... 121
Concurrency .............................................................................................................................. 125
Summary................................................................................................................................... 130
Chapter 4: Data Validation andPOCOs ������������������������������������������������������������������ 133
Validation Using DataAnnotations ............................................................................................. 134
Using Recursion................................................................................................................... 143
POCOs ....................................................................................................................................... 153
Helper Classes ..................................................................................................................... 156
Validating Using aClass ...................................................................................................... 168
Summary................................................................................................................................... 177
Chapter 5: Stored Procedures, Table Design, andModifications �������������������������� 179
Stored Procedures .................................................................................................................... 179
Calling aStored Procedure withOne Parameter ................................................................. 185
Inserting Into Multiple Tables .............................................................................................. 189
Table andEntity Design ............................................................................................................. 192
Making Changes totheTable .................................................................................................... 194
Summary................................................................................................................................... 201
评论5