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...

Author: Zlatko Michailov - MSFT 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...

Author: Zlatko Michailov - MSFT 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...

Author: Zlatko Michailov - MSFT Date: 05/12/2008

Primer to EntityConnectionStringBuilder

Following the spirit of Primer to ConnectionStringBuilder from ADO.NET 2.0, let’s see how the...

Author: Zlatko Michailov - MSFT 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...

Author: Zlatko Michailov - MSFT Date: 03/14/2008

MSDN Code Gallery is now live! It’s a place to download compiled binaries rather than source code....

Author: Zlatko Michailov - MSFT 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....

Author: Zlatko Michailov - MSFT 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...

Author: Zlatko Michailov - MSFT 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...

Author: Zlatko Michailov - MSFT 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)...

Author: Zlatko Michailov - MSFT 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...

Author: Zlatko Michailov - MSFT Date: 12/06/2007

Entity SQL: Canonical Functions

Canonical functions were introduced in the Beta 2 release of Entity Framework. Their purpose is to...

Author: Zlatko Michailov - MSFT Date: 12/05/2007

Definition: API

API = syntax + behavior

Author: Zlatko Michailov - MSFT 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...

Author: Zlatko Michailov - MSFT 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...

Author: Zlatko Michailov - MSFT 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...

Author: Zlatko Michailov - MSFT Date: 12/04/2007

How to Do Custom Mapping Using Entity SQL Views

This post was intended to be a reply to this question...

Author: Zlatko Michailov - MSFT Date: 11/21/2007

LINQ to Entities: Compiled Queries

Last Friday I blogged about making local variables behave consistently in LINQ to Entities queries....

Author: Zlatko Michailov - MSFT 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...

Author: Zlatko Michailov - MSFT 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...

Author: Zlatko Michailov - MSFT Date: 11/16/2007

XSL Transformation of CSDL into HTML

The attached XSL script neatly renders an Entity Framework CSDL file into HTML. Below is the...

Author: Zlatko Michailov - MSFT Date: 11/16/2007

Entity SQL Tip #1

A well defined query against a well defined entity data model does not need JOIN. Navigation...

Author: Zlatko Michailov - MSFT 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....

Author: Zlatko Michailov - MSFT Date: 10/24/2007

Query Complexity Factors

A query issued through Entity Framework undergoes three main transformations: 1. Compilation 2....

Author: Zlatko Michailov - MSFT 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...

Author: Zlatko Michailov - MSFT Date: 10/24/2007

Entity SQL

ADO.NET’s Entity Client comes with a client-side query engine that provides a consistent...

Author: Zlatko Michailov - MSFT Date: 10/24/2007