Microsoft MVP's painstaking efforts: the practical use of LINQ

Real-world applications

[Author] (FA) Fabrice marguerie; (MEI) Steve eichert; (MEI) Jim Wooley [works with the author] [Translator's introduction]
[Translated by] Chen lifu [same translator's work]
[Book name] Turing programming Series
[Release news agency] People's post and telecommunications Publishing House [book no.] 9787115208514
[Shelving time]
[Publication date] May August 2009 [Opening] 16

Sample free trial: http://www.china-pub.com/195668

[Edit recommendations]
Microsoft MVP's painstaking work, the LINQ bible.
In-depth and comprehensive, fascinating ..
Rich examples, taking into account the C # and VB. NET languages...

[Content Overview]
LINQ is Microsoft. NET software development platform, which establishes an efficient bridge between object-oriented language and various data sources, greatly reducing the complexity of software development ..

This book is comprehensive and detailed, covering almost all technical points. The advantages and disadvantages of the various features provided by LINQ are explained objectively, so that readers can make choices based on specific situations. In addition, it also explains the scalability of LINQ, which can be used for more advanced data processing. The book has a reasonable organizational structure and smooth writing, making readers feel like they are on a technical trip. In an in-depth and thorough explanation, the example is used to provide C # and VB for the same topic.. Net instance, and provide comments on the key points of the instance, truly achieving the realm of simplicity...

This book is suitable for software developers who use C # and VB. NET.

[Contents]
The first part starts from here.
Chapter 2 Introduction to LINQ 2
1.1 What is LINQ 2
1.1.1 overview 3
1.1.2 functions of LINQ 3
1.1.3 as a language extended LINQ 4
1.2 Why do I need LINQ 6?
1.2.1 FAQ 6
1.2.2 resolving conceptual disorder 8
1.2.3 solution 12 provided by LINQ
1.3 design objectives and origins of LINQ 13
1.3.1 design objective of the LINQ project 13
1.3.2 History 14
1.4 LINQ to objects preliminary: querying memory
Set 15
1.4.1 prerequisites 15
1.4.2 Hello LINQ to objects 17
1.5 LINQ to XML: Query XML Document 20
1.5.1 why do I need LINQ to XML 20?
1.5.2 Hello LINQ to XML 22
1.6 preliminary introduction to LINQ to SQL: querying relational databases
Database 26
1.6.1 overview of Functions of LINQ to SQL 26
1.6.2 Hello LINQ to SQL 26
1.6.3 learn more about LINQ to SQL 30
1.7 summary 30
Chapter 3 C # and enhanced features of VB 31
2.1 new language enhancements 31
2.1.1 list all processes currently running 32
2.1.2 encapsulate returned results into Class 33
2.2 implicit type local variable 34
2.2.1 syntax 35
2.2.2 Using implicit local variables to improve the instance
Procedure 35
2.3 initialize object and set 37
2.3.1 motivation for introducing object initiators 37
2.3.2 set initiator 38
2.3.3 use the object initiator to improve the instance program 39
2.4 Lambda expression 40
2.4.1 delegated review 40
2.4.2 anonymous method 42
2.4.3 lambda expressions 42
2.5 Extension Method 47
2.5.1 example of creating an extension method 47
2.5.2 more use of the LINQ standard query operator
Example 50
2.5.3 introduce the extension method into the instance program 51
2.5.4 notes 52
2.6 anonymous type 54
2.6.1 combination of anonymous data 55
2.6.2 the type without a name is also type 55
2.6.3 use anonymous type to improve instance program 56
2.6.4 anonymous type restriction 57
2.7 summary 58
Chapter 2 LINQ building block 61
3.1 extensions of. Net to LINQ 61
3.1.1 Language extension review 61
3.1.2 composition of the core elements of the LINQ Foundation 62
3.2 series 63
3.2.1 ienumerable <t> interface 63
3.2.2 iterator Review 64
3.2.3 delayed query execution 66
3.3 query operator 69
3.3.1 what is the query operator 69
3.3.2 standard query operator 71
3.4 query expression 72
3.4.1 what is a query expression 72
3.4.2 compile a query expression 73
3.4.3 standard query operators and Query expressions
Link 75
3.4.4 limit 76
3.5 Expression Tree 78
3.5.1 Lambda expression review 78
3.5.2 what is the expression tree 78
3.5.3 iqueryable; latency
Method 81 for query execution
3.6 LINQ assembly and namespace 81
3.7 summary 83
Part 2: Query objects in memory
Chapter 4 be familiar with LINQ to objects 86
4.1 Introduction to instance programs 86
4.1.1 program objective 86
4.1.2 program functions 87
4.1.3 business logic entity 87
4.1.4 database architecture 87
4.1.5 sample data 89
4.2 Use LINQ to operate a set of 90 in memory
4.2.1 what to query 90
4.2.2 supported operations 94
4.3 In ASP. NET and Windows Forms
Use LINQ 95
4.3.1 Data Binding in Web applications 95
4.3.2 in Windows Forms applications
Data Binding 100
4.4 common standard query operators 103
4.4.1 constraint operator where 104
4.4.2 projection operator 105
4.4.3 distinct operator 107
4.4.4 conversion operator 108
4.4.5 aggregation operator 109
4.5 Display the set 110 in memory in different ways
4.5.1 sorting 110
4.5.2 nested query 111
4.5.3 group 113
4.5.4 use connection 114
4.5.5 partition 117
4.6 conclusion 121
Chapter 1 query over basic memory data 5th
5.1 common use cases 122
5.1.1 query non-generic set 123
5.1.2 grouping by multiple conditions 125
5.1.3 dynamic query 127
5.1.4 LINQ to text files 135
5.2 design model 137
5.2.1 function Creation Mode 138
5.2.2 foreach mode 140
5.3 performance analysis 142
5.3.1 select an appropriate stream operation method 142
5.3.2 be careful to execute 144 immediately
5.3.3 LINQ to objects will reduce the code
Performance? 146
5.3.4 the cost of using LINQ to objects is 149
5.3.5 performance and conciseness: neither fish nor bear's paw
What about both? 151
5.4 Conclusion 152
Part 3 query Relational Data
Chapter 2 Introduction to SQL 6th
6.1 going to LINQ to SQL 157
6.1.1 creating object ing 159
6.1.2 set datacontext 161
6.2 read data through LINQ to SQL 161
6.3 continue to improve query 165
6.3.1 filter 165
6.3.2 sorting and grouping 167
6.3.3 aggregation 168
6.3.4 connection 169
6.4 hierarchical objects for operations 171
6.5 The timing of data loading and why do we need to care about these 174
6.5.1 delayed loading 174
6.5.2 loading details immediately 175
6.6 update data 177
6.7 Conclusion 179
Chapter 2 uncover the essence of LINQ to SQL 7th
7.1 ing between objects and relational data 180
7.1.1 add attribute 181 to the class
7.1.2 use an external XML file for ing 185
7.1.3 use sqlmetal tool 186
7.1.4 LINQ to SQL designer 188
7.2 convert a query expression to SQL 190
7.2.1 iqueryable API 190
7.2.2 Expression Tree 191
7.3 lifecycle of business entities: 193
7.3.1 tracking changes 195
7.3.2 submit change 196
7.3.3 offline data operation 198
7.4 conclusion 200
Chapter 2 advanced features of LINQ to SQL 8th
8.1 concurrent modification 201
8.1.1 pessimistic concurrency 201
8.1.2 Optimistic Concurrency 202
8.1.3 handling concurrency exceptions 204
8.1.4 use transactions to resolve conflicts 207
8.2 advanced database functions 208
8.2.1 use an SQL statement to directly obtain the result
Object 209
8.2.2 use stored procedure 210
8.2.3 User-Defined Function 217
8.3 improve business logic layer 220
8.3.1 pre-compiled query 220
8.3.2 Use partial classification to implement custom services
Logic 221
8.3.3 use part method 223
8.3.4 use Object Inheritance 225
8.4 introduction to LINQ to entities 229
8.5 conclusion 231
Part 4 XML operations
Chapter 2 Introduction to LINQ to XML 9th
9.1 what is xml api 234
9.2 why is another XML programming API 235 required?
9.3 Design Principles of LINQ to XML 236
9.3.1 core concept: function creation 238
9.3.2 core concept: Context-independent XML
Creation process 238
9.3.3 core concept: simplified name 239
9.4 inheritance system of related classes in LINQ to XML 241
9.5 operate XML 243 in LINQ
9.5.1 load XML 243.
9.5.2 parsing XML 245
9.5.3 create an XML 246
9.5.4 use Visual Basic XML literal
Create an XML 249
9.5.5 create XML document 251
9.5.6 add content 254 to XML
9.5.7 remove content from XML 255
9.5.8 update XML 256
9.5.9 operation attribute 258
9.5.10 save XML 258
9.6 conclusion 259
Chapter 4 query and
Convert XML 260
10.1 LINQ to XML axis method 261
10.1.1 element 262
10.1.2 attribute 263
10.1.3 elements 264
10.1.4 descendants 264
10.1.5 ancestore 267
10.1.6 elementsafterself and nodes-
Afterself, elementsbefore-
Self and nodesbeforeself
Method 268
10.1.7 XML axis attribute 269 of Visual Basic
10.2 standard query operator 271
10.2.1 use select for projection 273
10.2.2 use where for filtering 274
10.2.3 sorting and grouping 275
10.3 use XPath to query LINQ to XML objects 278
10.4 convert XML 279
10.4.1 convert from LINQ to XML 279
10.4.2 use XSLT to convert LINQ to XML
Object 282
10.5 conclusion 284
Chapter 2 common scenarios of LINQ to XML 11th
11.1 construct Objects Based on XML 285
11.1.1 objective 286
11.1.2 287
11.2 create XML 290 Based on the object
11.2.1 target 290
11.2.2 291
11.3 create XML 295 based on data in the database
11.3.1 objective 296
11.3.2 297
11.4 filter and mix slave databases and XML
301 of the data obtained in
11.4.1 target 302
11.4.2 302
11.5 read XML and update database 306
11.5.1 objective 306
11.5.2 307
11.6 convert text files to XML 319
11.6.1 objective 319
11.6.2 implement 320
11.7 Conclusion 322
Part 5: LINQ is everywhere
Chapter 2 extended LINQ 12th
12.1 explore the extension mechanism of LINQ 324
12.1.1 how to implement the 325 features of LINQ
12.1.2 custom LINQ extensions can be implemented
What 326
12.2 create a custom query operator 327
12.2.1 improved standard query operator 327
12.2.2 secondary or domain-related queries
Operator 330
12.3 basic query operator customization 334
12.3.1 review query and translation mechanism 334
12.3.2 specification for query expression mode 335
12.3.3 Example 1: trace standard query Operators
337 of the execution process
12.3.4 restriction: query expression conflict 338
12.3.5 Example 2: Non-generic, domain-related
The operator 340
12.3.6 Example 3: non-sequential query operator 342
12.4 Query Web Services: LINQ to Amazon 343
12.4.1 introduction of LINQ to Amazon 344
12.4.2 demand 345
12.4.3 346
12.5 iqueryable and iqueryprovider:
LINQ to Amazon advanced version 352
12.5.1 iqueryable and iqueryprovider
Interface 353
12.5.2 implementation 356
12.5.3 what happened 357
12.6 conclusion 358
Chapter 2 LINQ 13th
13.1 linqbooks application overview 359
13.1.1 function 359
13.1.2 program UI overview 360
13.1.3 Data Model 362
13.2 LINQ to SQL and data access layer 362
13.2.1 review of the traditional three-tier architecture 362
13.2.2 use a dedicated data access layer or
LINQ to SQL 364
13.2.3 in linqbooks
Use 368
13.3 use of LINQ to XML 374
13.3.1 import data from Amazon 374
13.3.2 generate RSS 376
13.4 use of LINQ to dataset 377
13.5 use LINQ to objects 380
13.6 scalability 380
13.6.1 custom query operator 380
13.6.2 create and use custom LINQ
Providers' 381
13.7 outlook for the future 381
13.7.1 custom LINQ function 382
13.7.2 LINQ to XSD: Strong-type LINQ
To XML 382
13.7.3 Plinq: supporting parallel computing
LINQ 383
13.7.4 LINQ to entities, ADO. net
Entity Framework's LINQ
Interface 383
13.8 conclusion 384
Chapter 4 using LINQ to operate dataset 14th
14.1 LINQ to dataset overview 385
14.2 dataset review 386
14.2.1 dataset application scenarios and functions 386
14.2.2 what is dataset 387
14.2.3 Visual Studio 2008 and. Net 3.5
To support the use
389 Improvement
14.3 querying weak dataset 390
14.3.1 load data 390 for Dataset
14.3.2 dataset 394 is not queried using LINQ
14.3.3 use LINQ to dataset to query
Weak data type dataset 395
14.4 query a strongly Typed Dataset 399
14.4.1 generate a strong data set 400
14.4.2 load data for a strong data set of 402
14.4.3 use LINQ to dataset to query
Strongly Typed Dataset 404
14.5 bind the query result of LINQ to dataset
UI control 406
14.5.1 use copytodatatable
Copy the query result to Dataset
Datatable 406
14.5.2 use asdataview for Bidirectional
Data Binding 408
14.6 use the query in LINQ to Dataset
Operator 410
14.6.1 field used for datarow <t> and
Setfield <t> operator 410
14.6.2 set operators and
Datarowcomparer comparison
Datarow 1, 411
14.7 conclusion 412
Appendix standard query operator 414