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;

USING

This is a funny one. It's a way of introducing namespaces just like in C#.

So, if I want to construct an instance of my Northwind.Shippers entity (Northwind being the namespace that's defined in my CSDL file) then I can do;

Northwind.Shippers(1, 'Acme', '123 456 789')

and the USING statement can make that more compact for me by allowing me to do;

Using Northwind;
Shippers(1, 'Acme', '123 456 789')

and, kind of like C#, I can also define aliases such as;

Using x=Northwind;
x.Shippers(1, 'Acme', '123 456 789')

but, as far as I can tell, you can't do this kind of trick;

Using myShipper=Northwind.Shippers;
myShipper(1, 'Acme', '123 456 789')

but that doesn't seem like the end of the world :-)