Enums in the Entity Designer

One of the most highly-requested features for the Entity Framework is first-class support for Enums, and we are happy to provide support for this feature in the Entity Designer in the June 2011 CTP recently released. If you haven’t checked it out already, find the bits here: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26660 We’d like to give you a look…

21

Spatial Types in the Entity Designer

One of the highly-anticipated features coming in the next version of Entity Framework is Spatial support. We’d like to give you a look at the experience of developing with Spatial types in the Entity Designer. If you haven’t already, take a look at what is going on under the hood with Spatial types in the…

12

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

Foreign Keys in the Entity Framework

Background A number of months ago we asked whether Foreign Keys (FKs) in Conceptual and Object models were important. The feedback we got indicated that there are a real mix of opinions on the topic. Some people are all for them while others think that FKs pollute the conceptual model. The fact that our customers…

43

Update on Computed Properties

A while back I wrote a post that introduced the concept of Computed Properties. Since that time we’ve had a number of conversations with both customers and internal partners and we’ve had some new ideas, that have changed our thinking somewhat.  First off we decided to implement Model Defined Functions, which are significantly more powerful…

11

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

Using Stored Procedures to load structured data.

V1 of the Entity Framework allows you to use stored procedures in two main ways: Mapping Create, Update and Delete entity operations to appropriate stored procedures. Doing a FunctionImport that allows you to return an enumeration of Entities* Now the thing is, in order to return an enumeration of Entities, you have to map the Entity…

9