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.Examples
Show all
redb.Examples.Examples
Classes
| E000_BulkInsert | Example: Bulk insert of complex employee records. |
| E001_SaveAsync | Example: Create and save a new employee. |
| E002_LoadAsync | Example: Load employee by ID. |
| E010_WhereSimple | Example: Simple Where filter by salary. |
| E011_WhereAnd | Example: Where with AND - filter by age and salary. |
| E012_WhereOr | Filter employees using OR condition. |
| E013_WhereNot | Filter employees using NOT equal condition. |
| E014_WhereRange | Filter employees by salary range. |
| E015_WhereTripleAnd | Filter employees using triple AND condition. |
| E016_WhereChain | Filter employees using chained Where() calls. |
| E020_DateTimeGreater | Filter employees by hire date. |
| E021_DateTimeRange | Filter employees by date range. |
| E030_StringContains | Filter employees using String.Contains. |
| E031_StringStartsWith | Filter employees using String.StartsWith. |
| E032_StringContainsIgnoreCase | Filter using case-insensitive String.Contains. |
| E040_NestedProperty | Filter employees by nested property. |
| E041_DeepNested | Filter employees by deeply nested property. |
| E050_ArrayContains | Query employees by skill using Array.Contains. |
| E051_ArrayMultiple | Query employees with multiple skills using Array.Contains with OR. |
| E052_ArrayNotContains | Query employees excluding specific skill. |
| E053_ArrayWithConditions | Query employees combining array Contains with other conditions (Pro). |
| E060_DictContainsKey | Query employees using Dictionary.ContainsKey. |
| E061_DictIndexer | Query employees using Dictionary indexer. |
| E062_DictNestedClass | Query employees using Dict indexer with nested class (Pro). |
| E063_DictTupleKey | Query employees using Dict with tuple key (Pro). |
| E070_CountAsync | Count employees using CountAsync. |
| E071_AnyAsync | Check if any employees exist using AnyAsync(). |
| E072_AnyWithPredicate | Check if any employees match a condition using AnyAsync(predicate). |
| E073_AllAsync | Check if ALL employees match a condition using AllAsync(predicate). |
| E074_WhereIn | Filter employees by a list of values using WhereIn. |
| E075_Select | Project specific fields using Select (server-side projection). |
| E076_Distinct | Get unique objects by Props hash using Distinct(). |
| E080_OrderBy | Sort employees by salary using OrderBy. |
| E081_OrderByThenBy | Sort employees by multiple fields using ThenBy. |
| E082_SkipTake | Paginate employees using Skip and Take. |
| E083_OrderByDescending | Sort employees in descending order using OrderByDescending. |
| E087_TreeCleanup | Cleanup existing tree data before E088/E089 tests. |
| E088_TreeCreateBulk | BULK create tree hierarchy (Pro feature) - FAST version. |
| E089_TreeCreate | Sequential create tree hierarchy (Pro feature) - SLOW version. |
| E090_TreeLoad | Load full tree with LoadTreeAsync. |
| E091_TreeCount | Count tree nodes with TreeQuery. |
| E092_TreeChildren | Get direct children of a node. |
| E093_TreePath | Get path from node to root. |
| E094_TreeDescendants | Get all descendants of a node. |
| E095_TreeMove | Move node to new parent. |
| E096_TreeQuery | LINQ queries on tree structures. |
| E097_TreeQueryRoots | Find root nodes in tree. |
| E098_TreeQueryLeaves | Find leaf nodes in tree. |
| E099_TreeQueryLevel | Filter tree nodes by level. |
| E100_TreeTraversalDFS | Depth-First traversal of tree. |
| E101_TreeTraversalBFS | Breadth-First traversal of tree. |
| E102_TreeIsDescendant | Check if node is descendant of another. |
| E103_TreeIsAncestor | Check if node is ancestor of another. |
| E104_TreeGetLevel | Get tree level of a node. |
| E105_TreeQueryWithRoot | TreeQuery scoped to specific root. |
| E106_TreeQueryChildrenOf | Query direct children of a node. |
| E107_TreeQueryMultiRoot | TreeQuery with multiple root parents. |
| E108_TreeToTreeList | ToTreeListAsync with Parent chain. |
| E109_TreeToRootList | ToRootListAsync - get full tree structure. |
| E110_TreeWhereHasAncestor | WhereHasAncestor - polymorphic ancestor filter. |
| E111_TreeWhereHasDescendant | WhereHasDescendant - find parents by child criteria. |
| E112_TreeStats | Tree statistics via TreeCollection. |
| E113_TreeToFlatList | Load tree nodes as flat list without Parent/Children links. |
| E114_ListCreate | Creates a new RedbList (dictionary/lookup table). |
| E115_ListAddItems | Adds multiple items to a RedbList using AddItemsAsync. |
| E116_ListGetByName | Gets a RedbList by name and retrieves its items. |
| E117_ListItemWithObject | Creates a ListItem with linked RedbObject. |
| E118_PropsListItemField | Object with ListItem field in Props. |
| E119_PropsListItemArray | Object with List of ListItems field in Props. |
| E120_ListItemWhereByValue | Query filtering by ListItem.Value property. |
| E121_ListItemWhereIn | Query filtering by ListItem.Value using WhereIn. |
| E122_ListItemDirectCompare | Query filtering by direct ListItem comparison. |
| E123_ListItemArrayAny | Query filtering by ListItem array using Any(). |
| E124_SumAsync | Calculates sum of a numeric field using SumAsync. |
| E125_AverageAsync | Calculates average of a numeric field using AverageAsync. |
| E126_MinMaxAsync | Calculates min and max of numeric fields using MinAsync/MaxAsync. |
| E127_AggregateAsync | Batch aggregation with multiple functions in single query. |
| E128_GroupBySimple | Groups objects by a field and calculates aggregates per group. |
| E129_GroupByFiltered | GroupBy with Where filter applied before grouping. |
| E130_GroupByMultiKey | GroupBy with composite key (multiple fields). |
| E131_GroupByRedb | GroupBy on base RedbObject fields without JOIN. |
| E132_WindowRowNumber | Window function ROW_NUMBER() with PARTITION BY. |
| E133_WindowRunningSum | Window function SUM() OVER for running totals. |
| E134_WindowLagLead | Window functions LAG/LEAD for previous/next values. |
| E135_WindowRank | Window functions RANK/DENSE_RANK for ranking with ties. |
| E136_WindowNtile | Window function NTILE for bucket distribution. |
| E137_WindowFirstLast | Window functions FIRST_VALUE/LAST_VALUE. |
| E138_WindowFrame | Window function with custom frame (sliding window). |
| E139_DistinctRedb | DISTINCT ON base fields (without Id) for finding duplicates. |
| E140_DistinctByRedb | DISTINCT ON specific base field. |
| E141_WhereInRedb | Filter by list of base field values. |
| E142_GroupByArray | Groups objects by elements of an array field using GroupByArray. |
| E143_SumRedbAsync | SumRedbAsync - sum of base IRedbObject field WITHOUT JOIN to _values. |
| E144_MinMaxRedbAsync | MinRedbAsync/MaxRedbAsync - min/max of base IRedbObject fields WITHOUT JOIN. |
| E145_AverageRedbAsync | AverageRedbAsync - average of base IRedbObject field WITHOUT JOIN. |
| E146_AggregateRedbAsync | AggregateRedbAsync - batch aggregation of base IRedbObject fields in ONE query. |
| E147_WindowPartitionByRedb | PartitionByRedb in Window Functions - partition by base IRedbObject field. |
| E148_WindowOrderByRedb | OrderByRedb in Window Functions - order by base IRedbObject field. |
| E149_SelectProjection | Select projection - load only specific fields instead of full object. |
| E150_ArrayAggregation | Array aggregation - aggregate all elements of array field or specific index. |
| E151_ArithmeticMultiply | Demonstrates arithmetic multiplication in Where clause. |
| E152_ArithmeticAddFields | Demonstrates arithmetic operations combining multiple fields in Where clause. |
| E153_StringToLower | Demonstrates case-insensitive string search using ToLower() in Where clause. |
| E154_StringTrim | Demonstrates Trim() function in Where clause to filter out empty or whitespace-only values. |
| E155_StringChain | Demonstrates chaining multiple string functions in Where clause. |
| E156_MathAbs | Demonstrates Math.Abs() in Where clause for range filtering around a target value. |
| E157_DateTimeYear | Demonstrates DateTime property extraction in WhereRedb clause. |
| E158_Parentheses | Demonstrates parentheses for operation priority in Where clause. |
| E159_NestedMath | Demonstrates nested Math functions with arithmetic in Where clause. |
| E160_TreeQueryExpressions | Demonstrates arithmetic expressions in TreeQuery Where clause. |
| E161_SqlFunctionCoalesce | Demonstrates Sql.Function for calling custom SQL functions. |
| E162_SqlFunctionPower | Demonstrates Sql.Function for mathematical SQL functions. |
| E163_SqlFunctionNested | Demonstrates nested Sql.Function calls for complex SQL expressions. |
| E164_BaseFieldsSingle | Demonstrates using RedbObject base fields without Props (EAV values). |
| E165_BaseFieldsBatch | Demonstrates batch save/load of non-generic RedbObject with base fields. |
| E166_GenericNullProps | Demonstrates using generic RedbObject<TProps> with Props=null. |
| E167_MixedBatch | Demonstrates mixed batch save with both non-generic RedbObject and generic RedbObject<T> with Props=... |
| E168_ArrayContains | Demonstrates filtering by array element using Contains(). |
| E169_ArrayContainsOr | Demonstrates filtering by multiple array elements using Contains with OR. |
| E170_ArrayContainsAnd | Demonstrates filtering by multiple array elements using Contains with AND. |
| E171_ScalarPlusArray | Demonstrates combining scalar field filter with array Contains filter. |
| E172_StringLength | Demonstrates String.Length property in Where clause. |
| E173_TreeQueryGroupBy | Demonstrates GroupBy aggregation on TreeQuery. |
| E174_TreeQueryWindow | Demonstrates Window Functions on TreeQuery. |
| E175_TreeQueryGroupByWindow | Demonstrates GroupBy + Window Functions on TreeQuery. |
| E176_TreeDistinctBy | Demonstrates DistinctBy on TreeQuery to get unique tree nodes by a Props field. |
| E177_TreeDistinctByRedb | Demonstrates DistinctByRedb on TreeQuery to get unique tree nodes by a base field. |
| E178_TreeOrderBy | Demonstrates OrderBy on TreeQuery to sort tree nodes by a Props field. |
| E179_TreeOrderByDescending | Demonstrates OrderByDescending on TreeQuery to sort tree nodes in reverse order. |
| E180_TreeDistinctByOrderBy | Demonstrates combining DistinctBy and OrderByDescending on TreeQuery. |
| E181_DeleteSingle | Demonstrates deleting a single object by ID. |
| E182_DeleteBatch | Demonstrates batch deletion of multiple objects. |
| E183_FirstOrDefaultAsync | Demonstrates FirstOrDefaultAsync to get a single object matching criteria. |
| E184_WhereNullable | Demonstrates filtering by nullable fields. |
| E185_WhereBool | Demonstrates filtering by conditions that can be simplified. |
| E186_ObjectReference | Demonstrates loading objects with RedbObject references. |
| E187_UpdateExisting | Demonstrates updating an existing object by loading, modifying, and saving it. |
| E190_SumAsyncFiltered | SumAsync with Where filter applied before aggregation. |
| E191_WindowFiltered | Window function with Where filter applied before windowing. |
| E192_AggregateFiltered | Multiple aggregations with Where filter applied before aggregation. |
| E193_AverageAsyncFiltered | AverageAsync with Where filter applied before aggregation. |
| E194_MinMaxAsyncFiltered | MinAsync/MaxAsync with Where filter applied before aggregation. |
| E195_GroupByWindowFiltered | GroupBy + Window with Where filter applied before grouping. |
| ExampleBase | Base class for all examples. |
| ExampleMetaAttribute | Attribute to mark example classes with metadata. |