LINQ query syntax and methods

1. Select

The Select operator projects the values in a single sequence or collection. In the following example, use Select to return all the columns of the employee table from the sequence:

2. using (NorthwindDataContext db=new northwinddatacontext ())
4. {
6. //linq query Syntax (basic syntax)
8. var query =
10. From e in db. Employees
12. where E.firstname.startswith ("M")
14. Select E;
16. //linq Method Syntax (Basic method)
18. var q =
20. Db. Employees
22. . Where (E = E.firstname.startswith ("M"))
24. . Select (e = e);
26. foreach (Var item in query)
28. {
30. Console.WriteLine (item. FirstName);
32. }
34. }

Of course, you can also return a single column, for example:

1. var query =
2. From e in db. Employees
3. where E.firstname.startswith ("M")
4. Select E.firstname;

You can also return a few columns in a sequence, for example:

1. var query =
2. From e in db. Employees
3. where E.firstname.startswith ("M")
4. Select New
5. {
6. E.firstname,
7. E.lastname,
8. E.title
9. };

2. SelectMany

The SelectMany operator provides the ability to combine multiple from clauses, which merges the results of each object into a single sequence. Here is an example:

2. using (NorthwindDataContext db=new northwinddatacontext ())
4. {
6. //query syntax
8. var query =
10. From e in db. Employees
12. From O in e.orders
14. Select O;
16. //Method Syntax
18. var q =
20. Db. Employees
22. . SelectMany (e = e.orders);
24. foreach (Var item in query)
26. {
28. Console.WriteLine (item. Freight);
30. }
32. }

second, the restriction operator

Where is the restriction operator, which applies the filtering criteria to the sequence and filters the data in the sequence according to the provided logic.

The where operator does not start execution of the query. When you start a time-lapse query on a sequence to begin execution, the filter is applied to the query. The use of the Where operator has already appeared in the first section and is no longer redundant.

third, sort operators

Sorting operators, including order BY, OrderByDescending, ThenBy, ThenByDescending, and reverse, provide ascending or descending sorting.

1.

The order by operator sorts the elements in the sequence in ascending. The following example demonstrates this:

2. using (NorthwindDataContext db = new northwinddatacontext ())
4. {
6. //query syntax
8. var query =
10. From e in db. Employees
12. E.firstname
14. Select E;
16. //Method Syntax
18. var q =
20. Db. Employees
22. . (E = e.firstname)
24. . Select (e = e);
26. foreach (Var item in Q)
28. {
30. Console.WriteLine (item. FirstName);
32. }
34. }

Here you can specify how the sequence is ordered by using the overloaded method order (Func,icomparer).

2. OrderByDescending

The orderbydescending operator arranges the elements in a sequence in descending order. The usage is the same as the by, no longer demonstrated here.

3. ThenBy

The ThenBy operator implements ascending order of sequences by sub-keyword. The query syntax for this operator is slightly different from the method syntax, as shown in the following code:

2. using (NorthwindDataContext db = new northwinddatacontext ())
4. {
6. //query syntax
8. var query =
10. From e in db. Employees
12. E.firstname,e.lastname
14. Select E;
16. //Method Syntax
18. var q =
20. Db. Employees
22. . (E = e.firstname)
24. . ThenBy (e = e.lastname)
26. . Select (e = e);
28. foreach (Var item in query)
30. {
32. Console.WriteLine (item. FirstName);
34. }
36. }

4. ThenByDescending

The thenbydescending operator implements descending order of sequences by the secondary keyword. The query syntax for this operator is slightly different from the method syntax, as shown in the following code:

2. using (NorthwindDataContext db = new northwinddatacontext ())
4. {
6. //query syntax
8. var query =
10. From e in db. Employees
12. E.firstname,e.lastname Descending
14. Select E;
16. //Method Syntax
18. var q =
20. Db. Employees
22. . (E = e.firstname)
24. . ThenByDescending (e = e.lastname)
26. . Select (e = e);
28. foreach (Var item in query)
30. {
32. Console.WriteLine (item. FirstName);
34. }
36. }

5. Reverse

The reverse will reverse the elements in the sequence sequentially from the back to the front. It is important to note that the return value of the reverse method is void, as shown in the following code:

2. using (NorthwindDataContext db = new northwinddatacontext ())
4. {
6. //Method Syntax
8. var q =
10. Db. Employees
12. . Select (e = e.firstname)
14. . ToList ();
16. Q.reverse ();
18. foreach (Var item in Q)
20. {
22. Console.WriteLine (item);
24. }
26. }

LINQ query syntax and methods