Le Roi Est Mort, Vive Le Roi!

Now that SQL Server 2008 is out the door, I’m full throttle on my new job. I’m totally excited about the improvement I’m working on, and I can’t wait to start blogging about it (once it’s out of secrecy.)   Today I’m only changing the outlook of my blog to reflect my new emploi. Yes,…


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 http://code.msdn.microsoft.com/esql/Release/ProjectReleases.aspx?ReleaseId=991. 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: http://msdn.microsoft.com/en-us/vstudio/cc533448.aspx


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…


eSqlBlast on Code Gallery

MSDN Code Gallery is now live! It’s a place to download compiled binaries rather than source code. The latest eSqlBlast is available at http://code.msdn.com/esql.


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…


SQL Server’s LEN() Function

There is a peculiarity around the LEN() function in SQL Server that not many people have realized or paid attention to. It’s the treatment of trailing spaces. The documentation says:           “Returns the number of characters of the specified string expression, excluding trailing blanks.” (The highlighting is mine.)   Indeed           SELECT LEN(‘abc’), LEN(‘abc         ‘);…


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…