Consolidate ESQL, Object Builders and Linq to Enties
Currently we have too many ways in EF4 to achieve data retrieval. Would be nice for the DEV community if there standardized, performat and easy to adopt one way - like Linq to Entities to write queries. This will reduce the burden of developer having to learn n-number query languages.
The DbContext API introduced in EF4.1 by design only exposes LINQ as a query language to avoid the burden and the confusion. We are still thinking that in some scenarios, especially for dynamic query composition, Entity SQL can be a better option, but we would expose it in a different way, and certainly we won’t add string-based query builder methods to DbSet/DbQuery. With the addition of auto-compiled queries LINQ to Entities performance is very close to Entity SQL. On the other hand, there is still a functionality gap between the two that needs to be filled, e.g. in Entity SQL it is possible to use LIKE directly.
I am marking this task as completed, but feel free to register new ideas for any functionality that EF is missing.