Welcome to MSDN Blogs Sign in | Join | Help

December 2007 - Posts

Wednesday, December 19, 2007 11:21 PM

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
Posted by Zlatko Michailov | 2 Comments
Friday, December 14, 2007 4:03 PM

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,
Posted by Zlatko Michailov | 2 Comments
Filed under:
Friday, December 14, 2007 2:11 PM

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
Posted by Zlatko Michailov | 3 Comments
Filed under:
Wednesday, December 12, 2007 4:38 PM

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,
Posted by Zlatko Michailov | 1 Comments
Thursday, December 06, 2007 9:44 AM

Entity Framework Beta 3 Is Available for Download

Entity Framework Beta 3 and related packages are available for public download: · Entity Framework Runtime : http://go.microsoft.com/fwlink/?LinkId=104981 · Entity Framework Tools : http://go.microsoft.com/fwlink/?LinkId=104983 · Entity Framework Samples
Posted by Zlatko Michailov | 5 Comments
Filed under:
Wednesday, December 05, 2007 5:01 PM

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
Posted by Zlatko Michailov | 7 Comments
Tuesday, December 04, 2007 5:11 PM

Definition: API

API = syntax + behavior
Posted by Zlatko Michailov | 3 Comments
Filed under:
Tuesday, December 04, 2007 4:26 PM

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
Posted by Zlatko Michailov | 0 Comments
Filed under: ,
Tuesday, December 04, 2007 3:51 PM

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 – using the new ToTraceString() method introduced in Beta 3. Previously that would require a similar (even more obscure) pattern that involved ObjectQuery.CreateCommandTree()
Posted by Zlatko Michailov | 2 Comments
Filed under: ,
Tuesday, December 04, 2007 3:31 PM

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 EntityCommand. There was public API to get to the native SQL, but the pattern was too obscure, and I don’t want to go into detail. Let’s discuss the new
Posted by Zlatko Michailov | 4 Comments
 
Page view tracker