In the space of about two dozen lines, you were able to access
data, query that data, and loop through that data simply and efficiently. In other technologies, you would
have had to create a connection to the database, create an instance of a SqlCommand object and any other
objects needed to execute a query, and write T-SQL code in your .NET code enclosed in quotation marks
And that??™s not to mention all the work that has to be done once you get the data back??”casting to the
appropriate data types, and so on.
The good news is that LINQ does all of that for you. Sweet! And we haven??™t even covered XML yet.
Standard Query Operators
The LINQ standard query operators make up an API that provides the means of querying various
data sources, such as arrays, collections, and even XML and relational data. They are a set of methods
that are implemented by each specific LINQ provider (LINQ to SQL, LINQ to XML, LINQ to Objects,
10
Chapter 1: Project LINQ
and so on). The operators form a LINQ query pattern that operates on a sequence (an object that implements
the IEnumerable
or IQueryable interface).
Pages:
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47