RedBase Documentation

Welcome to the RedBase documentation portal. Browse the API reference, explore code examples, and learn how to build with REDB.

API Reference

Browse the REDB API documentation. Select a namespace or type from the tree on the left, or click on items below.

Showing: redb.Examples.ExamplesEf Show all

redb.Examples.ExamplesEf

Classes

C E000_BulkInsert_ef EF Core twin of : the same 100 complex employees, mapped to the entity graph by
C E001_SaveAsync_ef EF Core twin of : one new employee, mapped by hand and saved.
C E002_LoadAsync_ef EF Core twin of : find any employee, then load it by id, both times as the
C E003_UniqueKeys_ef EF Core twin of : a business key that soft delete releases and a typed violation
C E004_SubtreeAndElementKeys_ef EF Core twin of : unique keys over the content of a nested class, an
C E010_WhereSimple_ef EF Core twin of : up to 100 employees with Salary above 75000, as whole objects.
C E011_WhereAnd_ef EF Core twin of : Age >= 30 AND Salary > 70000, up to 100 whole employees.
C E012_WhereOr_ef
C E013_WhereNot_ef EF Core twin of : Position other than Manager, up to 100 whole employees.
C E014_WhereRange_ef
C E015_WhereTripleAnd_ef EF Core twin of : three conditions, highest salary first, top 100 whole
C E016_WhereChain_ef EF Core twin of : three chained Where calls, up to 100 whole employees.
C E020_DateTimeGreater_ef EF Core twin of : hired in the last two years, up to 100 whole employees.
C E021_DateTimeRange_ef EF Core twin of : hired between three and one year ago, up to 100 whole employees.
C E030_StringContains_ef EF Core twin of : LastName contains Smith, up to 100 whole employees.
C E031_StringStartsWith_ef EF Core twin of : FirstName starts with John, up to 100 whole employees.
C E032_StringContainsIgnoreCase_ef EF Core twin of : LastName contains smith in any case, up to 100 whole employees.
C E040_NestedProperty_ef EF Core twin of : HomeAddress.City is London, up to 100 whole employees.
C E041_DeepNested_ef EF Core twin of : HomeAddress.Building.Floor above 10, up to 100 whole employees.
C E050_ArrayContains_ef EF Core twin of : Skills contains C#, up to 100 whole employees.
C E051_ArrayMultiple_ef EF Core twin of : Skills has C# or Python, up to 100 whole employees.
C E052_ArrayNotContains_ef EF Core twin of : Skills has C# and not intern, up to 100 whole employees.
C E053_ArrayWithConditions_ef EF Core twin of : Skills has C#, Age >= 30, Salary > 70000, up to 100 whole employees.
C E060_DictContainsKey_ef EF Core twin of : PhoneDirectory has the key desk, up to 100 whole employees.
C E061_DictIndexer_ef EF Core twin of : BonusByYear[2023] above 6000, up to 100 whole employees.
C E062_DictNestedClass_ef EF Core twin of : OfficeLocations[HQ].City is New York, up to 100 whole employees.
C E063_DictTupleKey_ef EF Core twin of : PerformanceReviews[(2024, Q1)] is Excellent, up to 100 whole employees.
C E070_CountAsync_ef EF Core twin of : total and filtered count.
C E071_AnyAsync_ef EF Core twin of : does any employee exist.
C E072_AnyWithPredicate_ef EF Core twin of : is there anyone with Salary above 100000.
C E073_AllAsync_ef EF Core twin of : three AllAsync checks.
C E074_WhereIn_ef EF Core twin of : employees of three departments, up to 100 whole objects,
C E075_Select_ef EF Core twin of : ten fields of 100 employees from every depth, a projection, no
C E076_Distinct_ef EF Core twin of . redb removes objects whose whole content is the same. In EF the content of an empl...
C E080_OrderBy_ef EF Core twin of : five lowest and five highest salaries, whole employees.
C E081_OrderByThenBy_ef EF Core twin of : Department ascending, Salary descending, first 100 whole employees.
C E082_SkipTake_ef EF Core twin of : page 2 of 10 by LastName, whole employees.
C E083_OrderByDescending_ef EF Core twin of : five top earners and five oldest, whole employees.
C E087_TreeCleanup_ef EF Core twin of : every department node loaded, then removed. EF has no trash,
C E088_TreeCreateBulk_ef EF Core twin of : the same four-level department tree, built as one entity
C E089_TreeCreate_ef EF Core twin of : the same tree saved node by node, one SaveChangesAsync
C E090_TreeLoad_ef EF Core twin of : a subtree loaded to a given depth.
C E091_TreeCount_ef EF Core twin of : the count of department nodes.
C E092_TreeChildren_ef EF Core twin of : the CORP root and its direct children (_id_parent equal to the root).
C E093_TreePath_ef EF Core twin of : the path from a node up to the root.
C E094_TreeDescendants_ef EF Core twin of . All descendants of a node, at any depth, need a
C E095_TreeMove_ef EF Core twin of : a department moved under OFF-02 and back under OFF-01 by changing
C E096_TreeQuery_ef EF Core twin of : department nodes whose name contains "IT", ordered by name.
C E097_TreeQueryRoots_ef EF Core twin of : department nodes without a parent.
C E098_TreeQueryLeaves_ef EF Core twin of : department nodes that have no children.
C E099_TreeQueryLevel_ef EF Core twin of : the nodes at a given level below a root.
C E100_TreeTraversalDFS_ef EF Core twin of : depth-first walk over a tree loaded to a given depth.
C E101_TreeTraversalBFS_ef EF Core twin of : breadth-first walk over a tree loaded to a given depth.
C E102_TreeIsDescendant_ef EF Core twin of : whether a node lies anywhere below another.
C E103_TreeIsAncestor_ef EF Core twin of : whether a node lies anywhere above another.
C E104_TreeGetLevel_ef EF Core twin of : the depth of a node from its root.
C E105_TreeQueryWithRoot_ef EF Core twin of : a subtree query limited to a given depth.
C E106_TreeQueryChildrenOf_ef EF Core twin of : the direct children of the CORP root. The root lookup is outside the measurement.
C E107_TreeQueryMultiRoot_ef EF Core twin of : subtrees of several roots limited to a given depth.
C E108_TreeToTreeList_ef EF Core twin of : found nodes with their parent chain up to the root.
C E109_TreeToRootList_ef EF Core twin of : whole trees assembled from their roots.
C E110_TreeWhereHasAncestor_ef EF Core twin of : nodes filtered by a condition on any ancestor.
C E111_TreeWhereHasDescendant_ef EF Core twin of : nodes filtered by a condition on any descendant.
C E112_TreeStats_ef EF Core twin of : statistics of a tree loaded to a given depth.
C E113_TreeToFlatList_ef EF Core twin of : a filtered subtree limited to a given depth, as a flat list.
C E114_ListCreate_ef EF Core twin of : the list "ExampleStatuses" created anew. An earlier one is
C E115_ListAddItems_ef EF Core twin of : four items with aliases added to "ExampleStatuses" in one save.
C E116_ListGetByName_ef EF Core twin of : the list found by name, then its items, two queries as in redb.
C E117_ListItemWithObject_ef EF Core twin of : a city saved with its coordinates, then a list item
C E118_PropsListItemField_ef EF Core twin of : a person whose Status points at the item "Active",
C E119_PropsListItemArray_ef EF Core twin of : a person whose Roles point at the first three items,
C E120_ListItemWhereByValue_ef EF Core twin of : persons whose status item has the value "Active", whole.
C E121_ListItemWhereIn_ef EF Core twin of : persons whose status item value is one of three, whole.
C E122_ListItemDirectCompare_ef EF Core twin of : the "Active" item looked up, then persons whose Status is that item, whole.
C E123_ListItemArrayAny_ef EF Core twin of : persons with any role item valued "Active", whole.
C E124_SumAsync_ef EF Core twin of : SUM(Salary) and SUM(HomeAddress.Building.Floor) on the
C E125_AverageAsync_ef EF Core twin of : AVG(Age) and AVG(HomeAddress.Building.Floor) on the
C E126_MinMaxAsync_ef EF Core twin of : MIN and MAX of Salary and of
C E127_AggregateAsync_ef EF Core twin of : eight aggregates in one query. EF has no batch aggregate
C E128_GroupBySimple_ef EF Core twin of : per department total salary, average age, average
C E129_GroupByFiltered_ef EF Core twin of : Salary above 50000, grouped by department, with the
C E130_GroupByMultiKey_ef EF Core twin of : grouped by department and position, with the average
C E131_GroupByRedb_ef EF Core twin of : total salary and count per owner. The owner is a field of
C E132_WindowRowNumber_ef EF Core twin of . EF Core does not translate window functions
C E133_WindowRunningSum_ef EF Core twin of . EF Core does not translate window functions (dotnet/efcore#12747), open since 2018...
C E134_WindowLagLead_ef EF Core twin of . EF Core does not translate window functions (dotnet/efcore#12747), open since 2018...
C E135_WindowRank_ef EF Core twin of . EF Core does not translate window functions (dotnet/efcore#12747), open since 2018...
C E136_WindowNtile_ef EF Core twin of . EF Core does not translate window functions (dotnet/efcore#12747), open since 2018...
C E137_WindowFirstLast_ef EF Core twin of . EF Core does not translate window functions (dotnet/efcore#12747), open since 2018...
C E138_WindowFrame_ef EF Core twin of . EF Core does not translate window functions (dotnet/efcore#12747), open since 2018...
C E139_DistinctRedb_ef EF Core twin of : up to 100 employees unique by every header field except
C E140_DistinctByRedb_ef EF Core twin of : up to 100 employees with distinct names, as whole objects.
C E141_WhereInRedb_ef EF Core twin of : five keys, then the employees with those keys as whole objects.
C E142_GroupByArray_ef EF Core twin of : the metadata entries of the contacts of employees living
C E143_SumRedbAsync_ef EF Core twin of : SUM of the employee keys and the count, two queries.
C E144_MinMaxRedbAsync_ef EF Core twin of : first and last creation date of the employees, two
C E145_AverageRedbAsync_ef EF Core twin of : AVG, MIN and MAX of the employee keys, three queries as in redb.
C E146_AggregateRedbAsync_ef EF Core twin of : five aggregates over header fields in one query,
C E147_WindowPartitionByRedb_ef EF Core twin of : ROW_NUMBER over a partition, which EF Core cannot express.
C E148_WindowOrderByRedb_ef EF Core twin of : a running COUNT over a window frame, which EF Core cannot express.
C E149_SelectProjection_ef EF Core twin of : three fields of 100 employees, then the same 100 as
C E150_ArrayAggregation_ef EF Core twin of : SUM and AVG over every element of SkillLevels and the
C E150A_ArrayAggregationByIndex_ef EF Core twin of : SUM and AVG of SkillLevels[0], one query over the array table.
C E151_ArithmeticMultiply_ef EF Core twin of : Salary * 12 above 1 000 000, up to 100 whole objects and the count.
C E152_ArithmeticAddFields_ef EF Core twin of : Age * 1000 + Salary above 120 000, up to 100 whole objects and the count.
C E153_StringToLower_ef EF Core twin of : LastName.ToLower() contains "s", up to 100 whole objects and the count.
C E154_StringTrim_ef EF Core twin of : FirstName.Trim().Length above 3, up to 100 whole objects and the count.
C E155_StringChain_ef EF Core twin of : Department.ToUpper().Length above 5, up to 100 whole objects and the count.
C E156_MathAbs_ef EF Core twin of : |Age - 35| at most 5, up to 100 whole objects and the count.
C E157_DateTimeYear_ef EF Core twin of : objects created this year and older than 30, up to 100 whole
C E158_Parentheses_ef EF Core twin of : (Salary / 12) above 7000, up to 100 whole objects and the count.
C E159_NestedMath_ef EF Core twin of : |Salary - 80000| below 10000, up to 100 whole objects and the count.
C E160_TreeQueryExpressions_ef EF Core twin of : a filter over the whole subtree of a root.
C E161_SqlFunctionCoalesce_ef EF Core twin of : COALESCE(Age, 0) above 30, up to 100 whole objects and
C E162_SqlFunctionPower_ef EF Core twin of : POWER(Age, 2) above 900, up to 100 whole objects and the
C E163_SqlFunctionNested_ef EF Core twin of : SQRT(Salary) above 250, up to 100 whole objects and the
C E164_BaseFieldsSingle_ef EF Core twin of : one header row with value fields and no Props, saved and loaded back.
C E165_BaseFieldsBatch_ef EF Core twin of : ten header rows without Props, saved and loaded as a batch.
C E166_GenericNullProps_ef EF Core twin of : a header row marked as an employee but without an
C E167_MixedBatch_ef EF Core twin of : two plain header rows and two marked as employees without Props,
C E168_ArrayContains_ef EF Core twin of : Skills contains "C#", up to 100 whole objects and the count.
C E169_ArrayContainsOr_ef EF Core twin of : Skills contains "C#" or "Python", up to 100 whole objects and the count.
C E170_ArrayContainsAnd_ef EF Core twin of : Skills contains both "C#" and "SQL", up to 100 whole objects and the count.
C E171_ScalarPlusArray_ef EF Core twin of : Age above 30 and Skills contains "C#", up to 100 whole objects and the count.
C E172_StringLength_ef EF Core twin of : LastName.Length above 6, up to 100 whole objects and the count.
C E173_TreeQueryGroupBy_ef EF Core twin of : a grouping over the whole subtree of a root.
C E174_TreeQueryWindow_ef EF Core twin of : window functions over the whole subtree of a root.
C E175_TreeQueryGroupByWindow_ef EF Core twin of : grouping and window functions over the whole subtree of a root.
C E176_TreeDistinctBy_ef EF Core twin of : a distinct over the whole subtree of a root.
C E177_TreeDistinctByRedb_ef EF Core twin of : a distinct by a header field over the whole subtree of a root.
C E178_TreeOrderBy_ef EF Core twin of : a sorted page of the whole subtree of a root.
C E179_TreeOrderByDescending_ef EF Core twin of : a sorted page of the whole subtree of a root.
C E180_TreeDistinctByOrderBy_ef EF Core twin of : a distinct and sorted page of the whole subtree of a root.
C E181_DeleteSingle_ef EF Core twin of : create an employee, load it, delete it, load it again.
C E182_DeleteBatch_ef EF Core twin of : five employees saved, loaded as whole objects, deleted in one
C E183_FirstOrDefaultAsync_ef EF Core twin of : the top earner above 80000 as a whole object, and a miss.
C E184_WhereNullable_ef EF Core twin of : EmployeeCode null and not null, five whole objects and a
C E185_WhereBool_ef EF Core twin of : two counts and five whole objects under combined conditions.
C E186_ObjectReference_ef EF Core twin of : a project, an employee whose CurrentProject points at it,
C E187_UpdateExisting_ef EF Core twin of : an employee saved, loaded whole with tracking, three fields
C E188_SoftDeleteReference_ef EF Core twin of : a reference to a soft-deleted object. EF Core has no soft delete.
C E190_SumAsyncFiltered_ef EF Core twin of : SUM(Salary) of Engineering and of everyone, two queries.
C E191_WindowFiltered_ef EF Core twin of : ROW_NUMBER over a partition after a filter, which EF Core cannot express.
C E192_AggregateFiltered_ef EF Core twin of : five aggregates over the developers in one query.
C E193_AverageAsyncFiltered_ef EF Core twin of : AVG(Salary) of ages 30 to 40 and of everyone, two queries.
C E194_MinMaxAsyncFiltered_ef EF Core twin of : MIN and MAX of Salary in Sales and overall, four queries as in redb.
C E195_GroupByWindowFiltered_ef EF Core twin of : RANK over grouped totals, which EF Core cannot express.
C E200_SmokeSqlDump_ef EF Core twin of : a dump of redb's own SQL for diffing two redb builders.
C E201_NullCheckBaseIdAmbiguity_ef EF Core twin of : a regression probe of redb's own SQL builder.
C E202_PvtPrefilter_ef EF Core twin of : redb's SQL with and without its own prefilter step.
C E203_SeedVolume_ef EF Core twin of : seeds the same employees, arranged as the same reporting
C E204_TreePrefilter_ef EF Core twin of : filtered counts inside a subtree of any depth.
C E205_WhereRedbSystemFields_ef EF Core twin of : saves three employees with a service key and a
C E206_WhereRedbNarrowsFirst_ef EF Core twin of : a lead with 20 team members under it, then the same
C E997_DateTimeJulianVerify_ef EF Core twin of : three employees with far-apart hire dates, three
C EfExampleBase Base class of the EF Core twins of the examples (redb.Export/doc/PLAN_EF_BENCHMARK.md). A twin carri...