Here's a working example of using MongoDB with ASP.NET / C# that demonstrates all the basic operations in MongoDB and encapsulates them in Web API. The example application is a simple Todo list. It's pretty simplistic, but it's more or less the pattern I'm using right now for data access against MongoDB.Continue reading »
ASP.NET Core: Logging with Serilog to MongoDB Using Configuration
This is likely a bit esoteric, but I was setting up an ASP.NET Core 2.2 project recently where I wanted to store logs in MongoDB. I wanted to play with Serilog vs. some of the alternatives. I also wanted to use a configuration file, and I wasn't able to find any good examples online, so I figured I'd create a quick example in this post. This example is applicable to ASP.NET Core 2.2, and may work for other versions, but isn't tested with others.Continue reading »
MongoDB C# Aggregating and Grouping By Distinct Fields
This seems to be a difficult solution to search for at the moment. The MongoDB .NET driver documentation links to the unit test files on GitHub for examples on aggregation related items, but the links are broken. Looking at the repos on GitHub is useful to find the actual tests, but for the specific problem I was trying to solve, it wasn't entirely helpful.
Basically what I was trying to do would be relatively easy with SQL -- a
SELECT DISTINCT from a table/collection based on multiple fields. I really just wanted to get the unique combinations of several fields at the database layer without having to retrieve all the documents from the collection, and then figuring out which were distinct.