UnitOfWork Wrapper

Overview

UnitOfWorkWrapper provides a strongly-typed interface around dynamically-created UnitOfWork instances. It implements both IUnitOfWorkWrapper and IUnitofWork interfaces with:

Safe property access - All property get/set operations are wrapped in try-catch
Event forwarding - Forwards events from underlying UnitOfWork via reflection
Oracle Forms compatibility - Navigation methods (MoveFirst, MoveNext, etc.)
Validation support - Integration with validation framework
Undo/Redo - Full undo/redo capability
Virtual loading - Support for large datasets with paging

Properties

Property	Type	Description
`IsInListMode`	`bool`	Gets/sets whether the UOW is in list mode
`IsDirty`	`bool`	True if there are unsaved changes
`DataSource`	`IDataSource`	The underlying data source
`DatasourceName`	`string`	Name of the data source
`EntityName`	`string`	Name of the entity/table
`EntityType`	`Type`	The entity CLR type
`PrimaryKey`	`string`	Primary key field name
`GuidKey`	`string`	GUID key field name (if applicable)
`Units`	`dynamic`	The collection of entities
`CurrentItem`	`dynamic`	Current record (Oracle Forms compatible)
`CurrentIndex`	`int`	Current position (Oracle Forms compatible)
`Count`	`int`	Total record count
`PageIndex`	`int`	Current page index
`PageSize`	`int`	Records per page (default: 10)
`InsertedKeys`	`Dictionary<int,string>`	Keys of inserted records
`UpdatedKeys`	`Dictionary<int,string>`	Keys of updated records
`DeletedKeys`	`Dictionary<int,string>`	Keys of deleted records
`DeletedUnits`	`List<dynamic>`	Deleted entity instances
`CommitOrder`	`CommitOrder`	Order of operations during commit (DeletesFirst, InsertsFirst, AsTracked)
`IsIdentity`	`bool`	Whether primary key is auto-increment
`IsLogging`	`bool`	Enable operation logging
`UpdateLog`	`Dictionary<DateTime,EntityUpdateInsertLog>`	Audit log of changes

Events

All events are forwarded from the underlying UnitOfWork via reflection:

Event	Args	Description
`CurrentChanged`	`EventHandler`	Current record changed
`ItemChanged`	`ItemChangedEventArgs<Entity>`	Item property changed
`PreDelete`	`UnitofWorkParams`	Before delete
`PreInsert`	`UnitofWorkParams`	Before insert
`PreCreate`	`UnitofWorkParams`	Before create
`PreUpdate`	`UnitofWorkParams`	Before update
`PreQuery`	`UnitofWorkParams`	Before query
`PostQuery`	`UnitofWorkParams`	After query
`PostInsert`	`UnitofWorkParams`	After insert
`PostCreate`	`UnitofWorkParams`	After create
`PostUpdate`	`UnitofWorkParams`	After update
`PostDelete`	`UnitofWorkParams`	After delete
`PreCommit`	`UnitofWorkParams`	Before commit
`PostCommit`	`UnitofWorkParams`	After commit

CRUD Operations

Async Operations (Preferred)

Method	Signature	Description
`UpdateAsync`	`Task<IErrorsInfo>(dynamic doc)`	Update entity asynchronously
`InsertAsync`	`Task<IErrorsInfo>(dynamic doc)`	Insert entity asynchronously
`DeleteAsync`	`Task<IErrorsInfo>(dynamic doc)`	Delete entity asynchronously
`InsertDoc`	`Task<IErrorsInfo>(dynamic doc)`	Insert document
`UpdateDoc`	`Task<IErrorsInfo>(dynamic doc)`	Update document
`DeleteDoc`	`Task<IErrorsInfo>(dynamic doc)`	Delete document

Sync Operations (Legacy)

Method	Signature	Description
`New`	`void()`	Create new empty entity
`Create`	`void(dynamic entity)`	Create entity
`Add`	`void(dynamic entity)`	Add entity to collection
`Update`	`ErrorsInfo(dynamic entity)`	Update entity
`Update`	`ErrorsInfo(string id, dynamic entity)`	Update by ID
`Delete`	`ErrorsInfo()`	Delete current
`Delete`	`ErrorsInfo(string id)`	Delete by ID
`Delete`	`ErrorsInfo(dynamic doc)`	Delete entity
`Delete`	`ErrorsInfo(Func<dynamic,bool>)`	Delete by predicate
`Update`	`ErrorsInfo(Func<dynamic,bool>, dynamic)`	Update by predicate

Batch Operations

Method	Signature	Description
`AddRange`	`Task<IErrorsInfo>(IEnumerable<dynamic>)`	Add multiple entities
`UpdateRange`	`Task<IErrorsInfo>(IEnumerable<dynamic>)`	Update multiple entities
`DeleteRange`	`Task<IErrorsInfo>(IEnumerable<dynamic>)`	Delete multiple entities

Navigation (Oracle Forms Compatible)

Method	Description
`MoveFirst()`	Move to first record
`MoveNext()`	Move to next record
`MovePrevious()`	Move to previous record
`MoveLast()`	Move to last record
`MoveTo(int index)`	Move to specific index
`TryMoveNext()`	Safe move next (returns bool)
`TryMovePrevious()`	Safe move previous (returns bool)

Navigation State

Property	Description
`IsAtFirst`	At first record
`IsAtLast`	At last record
`IsAtBOF`	At beginning of file
`IsAtEOF`	At end of file
`IsEmpty`	No records

Transaction Operations

Method	Signature	Description
`Commit`	`Task<IErrorsInfo>()`	Commit all changes
`Commit`	`Task<IErrorsInfo>(IProgress<PassedArgs>, CancellationToken)`	Commit with progress
`CommitBatchAsync`	`Task<CommitBatchResult>(int, IProgress, CancellationToken)`	Batch commit
`Rollback`	`Task<IErrorsInfo>()`	Rollback all changes

Validation

Method/Property	Description
`IsAutoValidateEnabled`	Enable automatic validation
`BlockCommitOnValidationError`	Prevent commit if validation fails
`ValidateItem(dynamic)`	Validate single item
`ValidateAll()`	Validate all items
`GetErrors(dynamic)`	Get validation errors for item
`GetInvalidItems()`	Get all invalid items

Undo/Redo

Method/Property	Description
`IsUndoEnabled`	Enable undo system
`MaxUndoDepth`	Maximum undo history (default: 100)
`CanUndo`	Can undo
`CanRedo`	Can redo
`Undo()`	Undo last operation
`Redo()`	Redo last undone operation
`ClearUndoHistory()`	Clear undo history

Virtual/Lazy Loading

Method/Property	Description
`IsVirtualMode`	Virtual mode enabled
`PageCacheSize`	Pages to cache (default: 3)
`VirtualTotalPages`	Total page count
`EnableVirtualMode(int)`	Enable with total count
`DisableVirtualMode()`	Disable virtual mode
`GoToPageAsync(int)`	Navigate to page
`PrefetchAdjacentPagesAsync()`	Preload adjacent pages
`InvalidatePageCache()`	Clear page cache

Aggregates

Method	Signature	Description
`Sum`	`decimal(string propertyName)`	Sum of property values
`SumWhere`	`decimal(string, Func<dynamic,bool>)`	Conditional sum
`Average`	`decimal(string)`	Average of property values
`AverageWhere`	`decimal(string, Func<dynamic,bool>)`	Conditional average
`Min`	`object(string)`	Minimum value
`Max`	`object(string)`	Maximum value
`CountWhere`	`int(Func<dynamic,bool>)`	Count matching records
`DistinctValues`	`List<object>(string)`	Distinct values
`GroupBy`	`Dictionary<object,List<dynamic>>(string)`	Group by property

Batch Operations

// Batch update with progress
var result = await wrapper.CommitBatchAsync(
    batchSize: 100,
    progress: new Progress<CommitBatchProgress>(p => 
        Console.WriteLine($"Batch {p.CurrentBatch}/{p.TotalBatches}")),
    ct: cancellationToken);

Error Handling

All operations are wrapped in safe execution helpers:

GetPropertySafely - Returns default value on error
SetPropertySafely - Throws on error (setter failures are critical)
ExecuteSafely - Returns default value on error
ExecuteSafelyAsync - Returns default value on async error

ObjectDisposedException is thrown if wrapper is used after Dispose().

Usage Examples

Basic CRUD

var wrapper = UnitOfWorkFactory.CreateUnitOfWork(
    typeof(Customer), editor, "MyDb", "Customers", "Id");

// Add
wrapper.New();
wrapper.CurrentItem.Name = "John";
await wrapper.InsertAsync(wrapper.CurrentItem);

// Update
wrapper.MoveFirst();
wrapper.CurrentItem.Name = "Jane";
await wrapper.UpdateAsync(wrapper.CurrentItem);

// Commit
var result = await wrapper.Commit();
if (result.Flag == Errors.Ok)
    Console.WriteLine("Success");

Navigation with Events

wrapper.CurrentChanged += (s, e) => 
    Console.WriteLine($"Current: {wrapper.CurrentIndex}");

wrapper.PreCommit += (s, e) =>
{
    if (wrapper.GetInvalidItems().Any())
        e.Cancel = true;
};

wrapper.MoveFirst();
while (!wrapper.IsAtLast)
{
    Console.WriteLine(wrapper.CurrentItem.Name);
    wrapper.MoveNext();
}

Validation

wrapper.IsAutoValidateEnabled = true;
wrapper.BlockCommitOnValidationError = true;

var validation = wrapper.ValidateAll();
if (!validation.IsValid)
{
    foreach (var error in validation.Errors)
        Console.WriteLine(error.Message);
}

Table of Contents

Overview

Properties

Events

CRUD Operations

Async Operations (Preferred)

Sync Operations (Legacy)

Batch Operations

Navigation (Oracle Forms Compatible)

Navigation State

Transaction Operations

Validation

Undo/Redo

Virtual/Lazy Loading

Aggregates

Batch Operations

Error Handling

Usage Examples

Basic CRUD

Navigation with Events

Validation