In this chapter, you learned how to issue basic queries to retrieve entities from a database. LINQ was the driving force behind getting the data from the database through Entity Framework. There are two basic approaches to using LINQ: the method and query syntaxes. The query syntax is quite similar to SQL, whereas the method syntax may be more suitable for developers with more experience in C# or VB.NET than SQL. We saw how to use both approaches to filter data. We saw that the where clause can be used to combine multiple conditions using logical operators. The ordering of data can be done as well, using either the OrderBy and OrderByDescending methods or ascending or descending keywords. In order to support multiple orders by conditions, we can use the ThenBy method. What we retrieved from the database were entities that were mapped to tables. We often do not need to think about this; simply assume that the Entity Framework persistence engine is taking care of these nitty-gritty...