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…

0

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