Filters
| |
Query Synax |
Method Syntax |
Purpose |
Where |
where n == value |
.Where( (n) => n == "value") |
Filters on conditional statement |
OfType |
- |
.OfType<typeName> |
Filters by type |
Joins
| |
Query Synax |
Method Syntax |
Purpose |
Join |
from p in Parent
join c in Child on
p.Id equals c.Id
select new { p.Value, c.ChildValue } |
Parent.Join(Child,
p => p.Id,
c => c.Id,
(p, c) => new { p, c }) |
Joins two collections on condition |
GroupJoin |
from p in Parent
join c in Child on
p.Id equals c.Id into g
select new { Parent = p, Children = g } |
Parent.GroupJoin(Child,
p => p.Id,
c => c.Id,
(p, c) => new { p, c }) |
Joins two collections on condition, grouping by key value |
Joins (copy)
| |
Query Synax |
Method Syntax |
Purpose |
Join |
from p in Parent
join c in Child on
p.Id equals c.Id
select new { p.Value, c.ChildValue } |
Parent.Join(Child,
p => p.Id,
c => c.Id,
(p, c) => new { p, c }) |
Joins two collections on condition |
GroupJoin |
from p in Parent
join c in Child on
p.Id equals c.Id into g
select new { Parent = p, Children = g } |
Parent.GroupJoin(Child,
p => p.Id,
c => c.Id,
(p, c) => new { p, c }) |
Joins two collections on condition, grouping by key value |
|
