Zlatko Michailov on Entity SQL

The ultimate Entity SQL blog

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 a...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 : http://go.microsoft.com/fwlink/?LinkID...
  • Blog Post: 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 the “syntax” part of the API. The behavior is...
  • Blog Post: 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 and thus – difficult to cache. · Tracing...
  • Blog Post: 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() and IServiceProvider.CreateCommandDefinition...
  • Blog Post: 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 one, instead. It’s a single method directly exposed...
  • Blog Post: How to Do Custom Mapping Using Entity SQL Views

    This post was intended to be a reply to this question http://forums.microsoft.com/msdn/showpost.aspx?postid=2440161&siteid=1 on the Entity Framework forum, but its size exceeds the forum server limit. Besides, it’s useful in general. So I decided to post it here. In this post you’ll find an entire...
  • Blog Post: LINQ to Entities: Compiled Queries

    Last Friday I blogged about making local variables behave consistently in LINQ to Entities queries . And the solution I recommended was compiled queries. But just today I realized that I haven’t blogged about compiled queries in general yet. The main purpose of compiled queries to improve performance...
  • Blog Post: Behavior of Variables in LINQ to Entities Queries

    LINQ is very nice about referencing local variables without any additional declaration. When I ran my first such LINQ to Entities query, I was ecstatic. The next moment I was puzzled – are the values of those variables picked at compile-time and later used as constants, or are they picked at each execution...
  • Blog Post: How to Parse an EntityDataReader

    2007.12.18 : Please accept my apologies – today I discovered (and fixed) two bugs in the parsing code. One is a silly error. The other is that collections should be treated as primitive types and refs with regard to the number of fields. The code bellow includes the changes. 2007.12.04 : Last week...
  • Blog Post: XSL Transformation of CSDL into HTML

    The attached XSL script neatly renders an Entity Framework CSDL file into HTML. Below is the NorthwindEF model that we’ve been using for our samples, rendered using that XSL script: Northwind Entity Sets Entity Types Complex Types Associations Entity Sets Northwind...
  • Blog Post: Entity SQL Tip #1

    A well defined query against a well defined entity data model does not need JOIN . Navigation properties in combination with nesting sub-queries should be used instead. These latter constructs represent task requirements much more closely than JOIN does. That makes it easier to build and maintain...
  • Blog Post: 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. Following is a preliminary outline of the talk: An overview of the Query Pipeline and the processes that take place there. Shapes of results that Entity Framework can produce. Interesting queries...
  • Blog Post: Query Complexity Factors

    A query issued through Entity Framework undergoes three main transformations: 1. Compilation 2. Query view expansion 3. Native SQL generation 1. Compilation Compilation is the process of producing a Command Tree. 1.1. Entity SQL 1.1.1. Navigation Properties Navigation is not natively...
  • Blog Post: Entity SQL - Quick Reference

    Literals “abc” Value abc ‘abc’ Value abc 1 Value 1 {2} Value 2 {3, 4, 5} Value 3 4 5...
  • Blog Post: Entity SQL

    ADO.NET’s Entity Client comes with a client-side query engine that provides a consistent entity-level platform over different store providers. The input to that query engine is an entity-level query written in a language naturally called Entity SQL . The purpose of Entity SQL is to provide a common,...
Page 1 of 1 (22 items)