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