Class E206_WhereRedbNarrowsFirst

Assembly: redb.Examples.dll

WhereRedb narrows first. A condition on the object's own columns (here the parent) is checked
on _objects before any Props field is read, so the query reads the fields of the few objects
that pass and nothing else. The same Props filter and page over the whole scheme reads every
employee. This is the shape of "the points of one route sorted by their number" or "the lines
of one order": a narrow parent, a Props filter, a page sorted by a Props field.

[ExampleMeta("E206", "WhereRedb - Narrow by Parent First", "Query", ExampleTier.Free, 1, new string[] { "WhereRedb", "ParentId", "Performance", "Composite" }, RelatedApis = new string[] { "IRedbQueryable.WhereRedb", "IRedbQueryable.Where", "IRedbQueryable.ToSqlStringAsync" })]
public class E206_WhereRedbNarrowsFirst : ExampleBase

Inheritance

Object→ExampleBase→E206_WhereRedbNarrowsFirst

Inherited Members

Methods

RunAsync(IRedbService)

Run the example and return result.

public override Task<ExampleResult> RunAsync(IRedbService redb)