Skip to content

Instantly share code, notes, and snippets.

@ToJans
Created June 29, 2011 10:04
Show Gist options
  • Save ToJans/1053570 to your computer and use it in GitHub Desktop.
Save ToJans/1053570 to your computer and use it in GitHub Desktop.
Alternative join/alias syntax for Simple.Data
// @markrendle 's proposal
dynamic manager; // To hold the aliased reference
var q = _db.Employees.Query()
.Join(_db.Employees.As("Manager"), out manager).On(manager.Id == _db.Employees.ManagerId)
.Select(_db.Employees.Name, manager.Name.As("Manager"));
// or this
var r= _db.Employees.Query( q => q
.Join( q.Managers = _db.Employees).On(q.Managers.Id == q.Employees.ManagerId)
.Select(q.Employees.Name,q.Manager.Name.As("Manager"))
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment