DefiningQuery versus QueryView

The Entity Framework is a flexible beast. So much so that it provides not one but two ways to create views over the database. DefiningQueries live in the storage schema file, or ssdl, and are written in the native SQL of the database engine being used, i.e. T-SQL for SqlServer. QueryViews on the other hand…


Colin Meek talks about his EF Extensions

Colin is a super smart colleague of mine, who works as a developer on the Entity Framework. So it is great to see him start a blog. His first post is super cool, because he discusses a set of extensions he put together that get around some of mapping limitations of the Entity Framework.  He…


Associations with Payloads - closing the loop

I’m assuming you’ve read part 1 and part 2, if not why not? Just kidding, they will make this post a little easier to understand though. I’m going to show you how to create a read-only association with a Payload.  Okay so imagine you have this model: And you want to have be able to do this: var products =…


All the power at your disposal

I invite you to take a look at this forum post from ‘Benys’ It illustrates the power of the Entity Framework’s mapping capabilities + partial classes. The short answer to a lot of “Does the EF support … ?” type questions is often no.  Often however the longer answer, is a little easier to digest….