Example: Outer join and group join examples in C# FLWR and "method chaining "

gistfile1.txt

var q = 
	from iu in Items
	join u in OtherItems on iu.Id equals u.Id into ug
	from u in ug.DefaultIfEmpty()
	where u == null
	orderby iu.Id
	select iu;
	

var q1 =
	Items
	.GroupJoin(OtherItems, iu => iu.Id, u => u.Id, (iu, u) => new {iu, u})
	.Where(a => !a.u.Any())
	.OrderBy(a => a.iu.Id)
	.Select(a => a.iu);

q.Take(3).Dump("_0");
q1.Take(3).Dump("_1");