Published Monday, August 27, 2007 3:50 PM by mtaulty

Entity Framework - Entity Provider Level. Entity SQL - KEY.

Returning back to that list that I talked about in a previous post we had

ANYELEMENT,CREATEREF, DEREF, IS OF, KEY, MULTISET, NAVIGATE, OFTYPE, OVERLAPS, Projection (including here as I've not yet figured out what it is :-)), REF, ROW , SELECT (including here because it has some weirdness like VALUE), SET, TREAT, USING

For this post, let's take a look at;

KEY

KEY selects us the key portion of an entity. So, if we have something like [order details] in Northwind then selecting KEY is going to give us a tuple ( orderid, productid ). So, we can run a query with something like;

"select value(key(od)) from NorthwindContext.Order_Details as od"

 and that'll give us;

image

and so on.

# ADO.NET Entity Framework - Bringing Together A Few Previous Posts @ Wednesday, August 29, 2007 5:37 PM

This is just a convenience - links to the posts that I've made so far around beta 2 of the ADO.NET Entity...

Mike Taulty's Blog

# Entity Framework from Mike Taulty « vincenthome’s Software Development @ Friday, September 07, 2007 7:25 AM

PingBack from http://vincenthomedev.wordpress.com/2007/09/07/entity-framework-from-mike-taulty/

Entity Framework from Mike Taulty « vincenthome’s Software Development