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 using Entity SQL. Similar queries using LINQ…


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 supported by database servers. It is implemented using APPLY operators to bring in the…

1

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 i, ‘abc’ AS s) i s 1 abc SELECT ROW(1 AS i, ‘abc’ AS s) AS Row FROM {11, 12, 13}; Row i s 1 abc i s 1…

1

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, entity-level, query language independent of any data store,…

1