DataMagic.MongoDatabase 9.0.0

DataMagic.MongoDatabase

I. Overview

DataMagic.MongoDatabase is an extension package of the DataMagic ecosystem that provides common functions and utilities for MongoDB database queries. This library simplifies working with MongoDB by offering extension methods for filtering, searching, and pagination operations, making it easier to build robust and maintainable data access layers.

The package seamlessly integrates with the DataMagic.Abstractions library to provide type-safe, fluent API for MongoDB operations including numeric filtering, date-time comparisons, text searching, and result pagination.

II. Functions

Extensions

DateTimeFilterExtensions

Extension methods for filtering MongoDB queries based on date-time values.

Methods:

• WithDateTimeSearch<T, TValueType>(IQueryable<T>, Expression<Func<T, TValueType>>, DateTimeFilter)

  • Applies date-time filtering to an IQueryable collection
  • Supports comparison operators: SmallerThan, SmallerThanEqualTo, GreaterThanEqualTo, GreaterThan, Equal
  • Returns: Filtered IQueryable<T>
  • Usage: Filter entities by date fields with specific comparison operators

• WithDateTimeRangeSearch<T, TValueType>(IQueryable<T>, Expression<Func<T, TValueType>>, DateTimeRangeFilter)

  • Applies date-time range filtering (From/To) to an IQueryable collection
  • Combines multiple date filters for range queries
  • Returns: Filtered IQueryable<T>
  • Usage: Filter entities within a specific date range

• WithDateTimeSearch<T, TValueType>(FilterDefinitionBuilder<T>, Expression<Func<T, TValueType>>, DateTimeFilter)

  • Creates a MongoDB FilterDefinition for date-time filtering
  • Supports all date-time comparison operators
  • Returns: FilterDefinition<T>
  • Usage: Build complex filter definitions for MongoDB queries

NumericSearchExtensions

Extension methods for filtering MongoDB queries based on numeric values.

Methods:

• WithNumericSearch<T, TValueType>(IQueryable<T>, Expression<Func<T, TValueType>>, NumericFilter<TValueType>)

  • Applies numeric filtering to an IQueryable collection
  • Supports comparison operators: Equal, SmallerThan, SmallerThanEqualTo, GreaterThanEqualTo, GreaterThan
  • Validates numeric types at runtime
  • Returns: Filtered IQueryable<T>
  • Usage: Filter entities by numeric fields with specific comparison operators

• WithNumericRangeSearch<T, TValueType>(IQueryable<T>, Expression<Func<T, TValueType>>, NumericRangeFilter<TValueType, TValueType>)

  • Applies numeric range filtering (From/To) to an IQueryable collection
  • Combines multiple numeric filters for range queries
  • Returns: Filtered IQueryable<T>
  • Usage: Filter entities within a specific numeric range

TextSearchExtensions

Extension methods for filtering MongoDB queries based on text values.

Methods:

• WithTextSearch<T>(FilterDefinitionBuilder<T>, FieldDefinition<T, string>, TextFilter)

  • Creates a MongoDB FilterDefinition for text filtering using field definition
  • Supports text filter modes: Contains, Equal, EndWith, StartWith, EqualIgnoreCase
  • Uses MongoDB regex patterns for flexible text matching
  • Returns: FilterDefinition<T>
  • Usage: Build text-based filter definitions for MongoDB queries

• WithTextSearch<T>(FilterDefinitionBuilder<T>, Expression<Func<T, object>>, TextFilter)

  • Creates a MongoDB FilterDefinition for text filtering using lambda expression
  • Supports all text filter modes
  • Returns: FilterDefinition<T>
  • Usage: Build text-based filter definitions with type-safe property selectors

SearchResultExtensions

Extension methods for paginating and converting MongoDB queries to search results.

Methods:

• ToSearchResultAsync<T>(IQueryable<T>, IPager, CancellationToken)

  • Converts an IQueryable to a paginated ISearchResult<T>
  • Handles total record counting and pagination
  • Returns: Task<ISearchResult<T>>
  • Usage: Paginate in-memory or LINQ-based queries

• ToSearchResultAsync<T, TProjection>(IFindFluent<T, TProjection>, IPager, CancellationToken)

  • Converts a MongoDB IFindFluent query to a paginated search result with projection
  • Supports asynchronous operations
  • Returns: Task<ISearchResult<TProjection>>
  • Usage: Paginate MongoDB find operations with custom projections

• ToSearchResultAsync<T>(IAggregateFluent<T>, IPager, CancellationToken)

  • Converts a MongoDB aggregation pipeline to a paginated search result
  • Supports complex aggregation queries with pagination
  • Returns: Task<ISearchResult<T>>
  • Usage: Paginate MongoDB aggregation pipeline results

Models

EntityUpdateBuilder<T>

A builder class for constructing MongoDB update definitions in a fluent manner.

Methods:

• Update<TField>(FieldDefinition<T, TField>, IUpdatableProperty<TField>)

  • Adds an update operation using a field definition
  • Only updates if the property has been modified
  • Returns: EntityUpdateBuilder<T> (for method chaining)
  • Usage: Build update operations for specific fields

• Update<TField>(Expression<Func<T, TField>>, IUpdatableProperty<TField>)

  • Adds an update operation using a lambda expression
  • Type-safe property selection with modification tracking
  • Returns: EntityUpdateBuilder<T> (for method chaining)
  • Usage: Build update operations with strongly-typed property selectors

• Build()

  • Combines all update operations into a single UpdateDefinition<T>
  • Returns: UpdateDefinition<T> or null if no updates were added
  • Usage: Generate the final update definition for MongoDB update operations

• CountUpdatedFields()

  • Returns the number of fields that will be updated
  • Returns: int
  • Usage: Validate or log the number of fields being updated

III. Requirements

Dependencies

The DataMagic.MongoDatabase package requires the following dependencies:

• DataMagic.Abstractions (Version 1.2.0)

  • Provides core abstractions, interfaces, and models
  • Includes filter models, operators, and pagination interfaces

• MongoDB.Driver (Version 3.13.0)

  • Official MongoDB driver for .NET
  • Provides MongoDB client, query builders, and LINQ support

Target Framework

• .NET 9.0 (net9.0)

Installation

To install the package, add it to your project using:

dotnet add package DataMagic.MongoDatabase

Or add the following to your .csproj file:

<PackageReference Include="DataMagic.MongoDatabase" Version="9.0.0" />

Usage Examples

Numeric Filtering

var query = collection.AsQueryable();
var numericFilter = new NumericFilter<int> 
{ 
    Value = 100, 
    Operator = NumericComparisonOperators.GreaterThan 
};
var filtered = query.WithNumericSearch(x => x.Age, numericFilter);

Date-Time Range Filtering

var dateRangeFilter = new DateTimeRangeFilter 
{
    From = new DateTimeFilter 
    { 
        Value = DateTime.Now.AddDays(-30), 
        Operator = DateTimeComparisonOperators.GreaterThanEqualTo 
    },
    To = new DateTimeFilter 
    { 
        Value = DateTime.Now, 
        Operator = DateTimeComparisonOperators.SmallerThanEqualTo 
    }
};
var filtered = query.WithDateTimeRangeSearch(x => x.CreatedDate, dateRangeFilter);

Text Search with Filter Builder

var filter = Builders<User>.Filter
    .WithTextSearch(x => x.Name, new TextFilter 
    { 
        Value = "John", 
        Mode = TextFilterModes.Contains 
    });
var results = await collection.Find(filter).ToListAsync();

Pagination

var pager = new Pager { Page = 1, PageSize = 20 };
var result = await query.ToSearchResultAsync(pager);
// result.Items contains the paginated items
// result.Total contains the total count

Update Builder

var updateBuilder = new EntityUpdateBuilder<User>();
updateBuilder
    .Update(x => x.Name, updatableNameProperty)
    .Update(x => x.Email, updatableEmailProperty);

var updateDefinition = updateBuilder.Build();
if (updateDefinition != null)
{
    await collection.UpdateOneAsync(filter, updateDefinition);
}

License

Please refer to the repository license file for licensing information.

Contributing

Contributions are welcome! Please ensure all code follows the existing patterns and includes appropriate documentation.