Zlatko Michailov on Entity SQL
The ultimate Entity SQL blog
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...
Date: 09/09/2008
Moving On...
I have to admit publically that I’ve decided to take on new challenges unrelated to EDM and Entity...
Date: 05/27/2008
New version of eSqlBlast - compatible with .NET Framework 3.5 SP1 Beta
The .NET Framework SP1 Beta-compatible version of eSqlBlast is available at...
Date: 05/12/2008
Primer to EntityConnectionStringBuilder
Following the spirit of Primer to ConnectionStringBuilder from ADO.NET 2.0, let’s see how the...
Date: 03/14/2008
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...
Date: 03/14/2008
eSqlBlast on Code Gallery
MSDN Code Gallery is now live! It’s a place to download compiled binaries rather than source code....
Date: 01/31/2008
The Edm.Length() Canonical Function over SqlClient
I recently blogged about canonical functions in Entity Framework and SQL Server’s LEN() function....
Date: 12/20/2007
SQL Server’s LEN() Function
There is a peculiarity around the LEN() function in SQL Server that not many people have realized or...
Date: 12/14/2007
Entity Framework and Object/Relational Mapping
Often, people categorize Entity Framework as an Object/Relational Mapper and try to compare it to...
Date: 12/14/2007
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)...
Date: 12/12/2007
Entity Framework Beta 3 Is Available for Download
Entity Framework Beta 3 and related packages are available for public download: · Entity Framework...
Date: 12/06/2007
Entity SQL: Canonical Functions
Canonical functions were introduced in the Beta 2 release of Entity Framework. Their purpose is to...
Date: 12/05/2007
Definition: API
API = syntax + behavior
Date: 12/04/2007
What Do ObjectQuery’s Builder Methods Build
Until Beta 2 ObjectQuery’s builder methods used to build a Command Tree. There were multiple...
Date: 12/04/2007
How to Get the Native SQL from an ObjectQuery
The way to get the native SQL generated for an ObjectQuery is exactly the same as for EntityCommand...
Date: 12/04/2007
How to Get the Native SQL from an EntityCommand
With the Beta 3 release, Entity Framework is introducing an easy way to get the native SQL from an...
Date: 12/04/2007
How to Do Custom Mapping Using Entity SQL Views
This post was intended to be a reply to this question...
Date: 11/21/2007
LINQ to Entities: Compiled Queries
Last Friday I blogged about making local variables behave consistently in LINQ to Entities queries....
Date: 11/19/2007
Behavior of Variables in LINQ to Entities Queries
LINQ is very nice about referencing local variables without any additional declaration. When I ran...
Date: 11/16/2007
How to Parse an EntityDataReader
2007.12.18: Please accept my apologies – today I discovered (and fixed) two bugs in the parsing...
Date: 11/16/2007
Entity SQL Tip #1
A well defined query against a well defined entity data model does not need JOIN. Navigation...
Date: 11/01/2007
Live Appearance: Nov 27, 2007 in Vancouver, BC
On Nov 27, 2007 I'll speak about Query Options for Entity Framework at DevTeach in Vancouver, BC....
Date: 10/24/2007
Query Complexity Factors
A query issued through Entity Framework undergoes three main transformations: 1. Compilation 2....
Date: 10/24/2007
Entity SQL - Quick Reference
Literals “abc” Value abc ‘abc’ Value abc 1 Value 1 {2} Value 2 {3, 4, 5} Value 3 4 5 Rows ROW(1 AS...
Date: 10/24/2007
Entity SQL
ADO.NET’s Entity Client comes with a client-side query engine that provides a consistent...
Date: 10/24/2007