Choose and reorder the data operation in which they are applied by LinqDataSource.
Explanation:
The LinqDataSource class is used to allow the use of LINQ in ASP.NET Web pages by
using the markup text to fetch and modify the data from a data object. It uses LINQ to SQL to
automatically generate the data commands. The data object can be either an in-memory datacollection or an object that displays data from a database. A user can fetch or alter the data without
writing SQL commands for each operation. The LinqDataSource control applies data operations in
the following order:
1.Where: It is used to specify which data records to return.
2.Order By: It is used to sort.
3.Group By: It is used to aggregate data records that share values.
4.Order Groups By: It is used to sort grouped data.
5.Select: It is used to specify which fields or properties to return.
6.Auto-sort: It is used to sort data records by a property that a user has selected.
7.Auto-page: It is used to get a subset of data records that were selected by a user.
The user can add conditions to the Where property to filter a data record, otherwise the
LinqDataSource control gets every record from the data object.