Join

EntitySpaces Dynamic Query API offers fantastic join capabilities. Below is an example of how powerful and simple the Dynamic Query API is.

C#

VB

Produces the following SQL

Of course, RightJoin, LeftJoin, and FullJoin are also supported. The nice thing about this approach is that you are spoonfed the syntax via intellisense, no need to stop and create a view (although you can if you want to and generate your business entities off of the view). The "c", "o" and "oi" shown above are merely the aliases used when building the SQL.