Community Tutorial: Using NPoco with CockroachDB and C# / .NET Core

Darrien Rushing describes his efforts to develop a distributed, near-real-time "OSINT data reconnaissance" system using CockroachDB, NPoco, and .NET Core, highlighting the challenges and solutions in integrating these technologies. He explains his choice of CockroachDB for its distributed nature and NPoco as a micro-ORM to facilitate data transfer between the .NET Core API and the database. The tutorial covers setting up a .NET Core web API project, preparing the database with CockroachDB, and using NPoco for CRUD operations. Rushing offers insights into data type matching and the benefits of using NPoco, such as improved code readability and ease of data mapping. He shares his experiences with integrating these technologies and expresses an interest in exploring further applications, such as adapting the architecture for IoT hardware like Raspberry Pi.