Moving On…

I have to admit publically that I’ve decided to take on new challenges unrelated to EDM and Entity Framework. Starting today I’ll be working on the lower levels of the SQL Server Connectivity stack.   I’d like to thank all of you who’ve been reading my Entity SQL blog and who’ve been using Entity Framework….


New version of eSqlBlast – compatible with .NET Framework 3.5 SP1 Beta

The .NET Framework SP1 Beta-compatible version of eSqlBlast is available at The release includes a source code zip as well.    The SP1 Beta distributions of .NET Framework 3.5 and Visual Studio 2008 are available through:


Primer to EntityConnectionStringBuilder

Following the spirit of Primer to ConnectionStringBuilder from ADO.NET 2.0, let’s see how the pattern has evolved in Entity Framework.   Building an Entity Connection String from Scratch What’s important to keep in mind before we dive into code samples, is that an entity connection string consists of two separate connection strings – one for…


Why Should I Use Entity Framework?

If your app is small enough, i.e. you write your own database schema (for SQL Server) and you write the only app over that schema, you don’t really need Entity Framework. In that case, you may consider LINQ to SQL.   Now let’s think big. Let’s say you are an app/service vendor but your are not…


The Edm.Length() Canonical Function over SqlClient

I recently blogged about canonical functions in Entity Framework and SQL Server’s LEN() function. The purpose of those two posts was to lay out the foundation for this one, and to allow it to be brief and coherent. Please read those two posts before proceeding.   If you’ve been using the Edm.Length() canonical function from…


Entity Framework and Object/Relational Mapping

Often, people categorize Entity Framework as an Object/Relational Mapper and try to compare it to other O/R Mappers. I dare say that’s an apples-to-oranges kind of comparison. While Entity Framework does have ORM capabilities, that is only a fraction of its functionality, and more importantly, those ORM capabilities are achieved through a fundamentally different approach…


eSqlBlast – The Ultimate Tool for Writing Entity SQL Queries

2007.12.18: Today I posted an update to How to Parse an EntityDataReader – I discovered (and fixed) two bugs in the parsing code. Since the code is taken from eSqlBlast, the same fix should be applied to it too. The code is in project Core, class XmlVisitor, method VisitRecord. I’ll try to push a refresh to CodePlex soon. Sorry…


Entity Framework Beta 3 Is Available for Download

Entity Framework Beta 3 and related packages are available for public download: ·         Entity Framework Runtime: ·         Entity Framework Tools:        ·         Entity Framework Samples:   ·         Entity Framework Documentation:  


Entity SQL: Canonical Functions

Canonical functions were introduced in the Beta 2 release of Entity Framework. Their purpose is to expose a [virtually] canonical API beyond the core language constructs. Consumers of canonical functions should be aware that Entity Framework defines only the “syntax” part of the API. The behavior is entirely up to the store provider. Not the…


What Do ObjectQuery’s Builder Methods Build

Until Beta 2 ObjectQuery’s builder methods used to build a Command Tree. There were multiple problems with that: ·         Duplicate code – there is already a component that builds Command Trees from Entity SQL. ·         Caching – Command Trees are expensive to hash and thus – difficult to cache. ·         Tracing – getting a meaningful…