Auto-Compiled LINQ Queries (Entity Framework June 2011 CTP)

When you write a LINQ to Entities query today, the Entity Framework walks over the expression tree generated by the C#/VB compiler and translates (or compiles) that into SQL.     Compiling the expression tree into SQL involves some overhead though, particularly for more complex queries.  In order to avoid having to pay this performance…

23

Spatial Types in the Entity Framework

One of the highly-anticipated features coming in the next version of Entity Framework is Spatial support. The team has been hard at work designing a compelling story for Spatial, and we would love to get your feedback on it. In this post we will cover: The basics of SQL Server’s  spatial support Design goals Walkthrough…

24

Table-Valued Function Support

One of the key features coming in the next release of Entity Framework is Table-Valued Function support.  It is a very popular customer request and we have been working diligently to design a solution that we hope you find simple, yet useful.  This design intends to make TVFs first-class citizens on Entity Framework, by allowing…

16

Model Defined Functions

Today the Entity Framework, and more specifically the Entity Data Model, have a limited notion of Functions. We are currently restricted to Function Imports that allow stored procedures to be invoked, and Canonical / Store Functions for database independent and database specific functions respectively. Now however we want to support functions defined, not just declared,…

22

EDM and Store functions exposed in LINQ

In this post Colin Meek and Diego Vega delve into some enhancements we are planning for LINQ to Entities, anyway over to them… Entity Framework v1 customers preferring to write their queries using LINQ often hit a limitation on the range of functions and query patterns supported in LINQ to Entities. For some of those…

14