Some differences between ESQL and LINQ to Entities capabilities

John Papa asks in my comments about some differences among the two query languages. Let’s start from the beginning: What is almost the same Updatable queries: Neither LINQ to Entities nor ESQL currently enclose a real Data Manipulation Language. However, both can return tracked entities that you can then update and send back to the…

2

Entity SQL Non-Quirkiness

Zlatko has been posting about one LINQ to Entities new feature included in the upcoming Beta 3, so I decided to take revenge and make a 100% Entity SQL post. Here is something I ran against the other day: Let’s assume we need to retrieve the Order with the maximum OrderID, which is a really…

8

Choosing an Entity Framework API

Last month, a question was asked in the ADO.NET Prerelease forum that went more or less like this: Considering that there are many APIs you can use (Entity SQL, ObjectQuery<T>, LINQ to Entities), is there any guidance that could help me decide when to use each? The best I could do based on my knowledge…

1