LINQ queries demonstrate how to operate and query the OData objects wrapped in an Entity Framework data model. Below are some examples of LINQ queries supported by the Entity framework.
Contains
Retrieve all records from the Books table that contain "A" in their Author name. |
| ||||
Count
Count all entities that match a given criterion. |
| ||||
Filter
Select records from the table Books that belong to Location_City equal to Delhi. |
| ||||
Group By
Group records from the Books table based on the Location_City property. The groups are then ordered in descending order based on the Location_City. |
| ||||
Join
Cross join between Books and Employees tables. |
| ||||
Limit
Retrieve the first 10 records from the Books table. |
| ||||
Order By
Sort records from the Books table by Title in descending order. |
|