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 Framework Beta 3 and Entity Designer CTP2 are out!

Today we made a huge step towards RTM. I know this is no news anymore, but well, it has been one of those days 😉 Now please, go get the bits, start creating your models with the designer. Then tweak them with some nice inheritance. Why not, taste a few EntityReaders. Generate some classes and…

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

Entity Framework FAQ

One of the best learning resources I have found since I joined my team at Microsoft is this page Danny Simmons has just published. Look here for his post explaining it. If you have any further questions that are not covered or you feel are not clear enough, feel free to add your questions in…

2

Stretching myself on the wrong axis

Something you need to learn as a Program Manager at Microsoft is how to scale. This mean that you need to drive issues, multitask, excel at doing it, choose your fights, etc. Last week I tried a different approach that kind of worked when I was younger: stretching on the time axis. I found that…

1

This is what happened since 10/23

I was in the kitchen close to my office having a coffee and mulling about what great thing I could do next about the blog. Then I came here and I saw this comment by Guillaume (a good friend in disguise), that translated from Spanish means “so, what happened since 10/23?”. I guess I will…

1

Hello Data

My name is Diego Vega and I am a new Program Manager in the Data Programmability team. This is my first post as a Microsoft employee! I came here from an ISV/small software company world: A world in which data access is such an important thing as breathing, and yet, it is seldom done unconsciously…

1