Simple, fast, and secure micro ORM for .NET

TinyORM by Stan Drapkin [sdrapkin at sdprime dot com]

Documentation: wiki

Features:

1. Focused on SQL Server (any SqlClient-based db engine). Azure SQL is supported as well.
2. Intuitive, tiny, simple API. This is usually the hardest part for libraries to get right.
3. Does not obscure or reinvent T-SQL. If you prefer APIs that hide T-SQL incompetence, look elsewhere.
4. Very fast. As fast as competition (Dapper, OrmLite, LLBLGen, EF Core, etc. benchmarks).
5. Seamlessly transactional and safe. Transactions are not merely supported - they are the default.
   • XACT_ABORT=ON (automatic transaction rollback on runtime T-SQL errors).
   • Custom transaction scopes are declared via standard TransactionScope instance (created via TinyORM.DbContext.CreateTransactionScope() factory).
6. Transparent connection management. One less thing to worry about and screw up. Never think about connections again.
7. Task-based async API (ie. the API). All calls are buffered (focus on safety and fast connection release).
8. POCOs or anonymous objects are fine. No inheritance, interface, or attribute requirements.
9. Returns dynamic entities which can be consumed directly, or projected to statically-typed objects (fast!).
   • Either strict (perfect-match) or relaxed (best-effort) projection of dynamic to statically-typed objects.