AsyncPoco is a fork of the popular PetaPoco micro-ORM for .NET, with a fully asynchronous API and support for the async/await keywords in C# 5.0 and VB 11. It does not supercede PetaPoco; the two can peacefully co-exist in the same project. When making the decision to go asynchronous, it's generally best to go "all in", but keeping both around can be helpful while making a gradual transition.
This project is forked from https://github.com/tmenier/AsyncPoco in 2016
.NET Framework 4.8
Perhaps, you can spawn multiple thread and use async Task queue.
Instead of using "DBContext.query," it now allows the alternative "entity.Save(DB context)" syntax for snap-in transaction. DB contexts are created and shared across threads via ".GetInstance()". If a transaction is needed, you should create a non-shared context using "new DBContext()" and manage its lifespan.
- /AsyncPocoCore is at work
- Don't use combo primary-keys. (support is complex and weak)
- Each thread manage its own shared context. Read/write may happen at shared context. If you need transaction, create a dedicated new context for it.