MongoDB Aggregation with ASP.NET Core

Create an Aggregation Pipeline to Calculate Average Order Amount

Write an aggregation pipeline in ASP.NET Core that calculates the average order amount per customer.

Expected output: A list of customers with their average order amounts.

Hint: Use $group stage with an accumulator like $avg.

Filter and Sort Products by Price

Build an aggregation pipeline that filters products with price greater than 100 and sorts them by price ascending.

Expected output: A sorted list of products priced above 100.

Hint: Use $match and $sort stages.

The aggregation framework processes data records and returns computed results, enabling complex data transformations like grouping, filtering, and sorting within the database.

You start by calling the Aggregate() method on an IMongoCollection, then chain stages like Match(), Group(), and Sort() to build the pipeline.

Aggregation reduces the number of queries and client-side processing by performing data transformations within the database, improving performance and reducing network overhead.