See yesterday's post for some context... So we can't rely on EntityDataReader . GetSchemaTable() and a DataAdapter to do the filling of our DataTable for us. We have to do it ourselves. As with any problem the first step is to define the steps:...

Okay so about 5 posts back I promised: "...At this point we have an enumeration of all EntitySet s available. In the next post I explain how we can use that…" Well better late than never... If you remember last time I showed you this piece of...

One of the key decisions with LINQ to Entities (L2E) is that all predicates in an L2E expression must be converted into store expressions, so that the store does all the heavy lifting. This means for example if you try the following: var matches...

So earlier today I was lamenting that an anonymous type can't be shared between functions with Wes Dyer , when he said "Well actually they can..." Cue me learning something cool. The first step is to create a seemingly innocent method: public...

In my last Metadata post I suggested using a string template to create an EntityConnection connection string. Well it turns out there is a better way... Enter the EntityConnectionStringBuilder class. The only thing it is missing is the ability to specify...

For a while LINQ to SQL has had compiled Queries... and now in Beta3 of the Entity Framework, due out soon, we have them too. The idea behind compiled queries is that you don't want to re-process the same LINQ expression every time it is encountered...

So why does this: EntityDataReader reader = command.ExecuteReader(); Throw an exception? Well it is to-do with correctness and setting expectations. First things first, this is what you should do: EntityDataReader reader = command.ExecuteReader...

In my last post I hinted that using the Entity Frameworks Value layer and Metadata allows you to work against any Entity Data Model in a loosely coupled way. Let’s see how… So let’s imagine you are working against the Value layer. With code something...

One of the things I am doing at the moment is writing a bunch of Entity Framework code with one common theme, leveraging metadata. In the spirit of transparency here is what I have learnt (just this, nothing else at all...) When working with the...

So Alex Henderson , who took over running the Auckland Architecture chats from me, has been busy recently compiling a wiki full of SharePoint Hacks . Hopefully this will grow overtime, but even as it is it is a useful resource. Asad, who has been...

Seeing as this is my first post on this blog, a few things about me are in order. My name is Alex James, a new Microsoft employee, based in Redmond. My family and I have moved to Seattle from NZ just so I could take this job. Now NZ is a pretty nice...