Share via


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

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