Chapter 9. An alternative way of querying: Entity SQL
- Executing queries using Entity SQL
- Executing queries using query-builder methods
- Using the Entity Client data provider
In this chapter, we’ll cover one of the hidden gems of Entity Framework: Entity SQL. LINQ to Entities has made this language almost obsolete, and developers don’t feel comfortable with it—its string-based nature is less expressive than the object-oriented LINQ. But thinking that Entity SQL is useless is a huge mistake, because some types of queries are easier to write using such a language.
In the first part of the chapter, we’ll discuss the querying capabilities of Entity SQL, focusing on different types of common operations, exactly as we did ...