RepoDb
A high-performance hybrid ORM library for .NET that bridges micro-ORMs and full-ORMs with advanced features.
What is RepoDb?
RepoDB is a hybrid ORM library for .NET that bridges the gaps between micro-ORMs and full-ORMs. It provides both basic CRUD operations and advanced features like caching, tracing, and bulk operations, allowing developers to switch contexts seamlessly during development. It is designed for high performance and memory efficiency through compiled expression caching and schema optimization.
.NET developers building data-intensive applications who need a balance between the simplicity of micro-ORMs and the advanced capabilities of full-ORMs, especially those working with SQL Server, SQLite, MySQL, or PostgreSQL.
Developers choose RepoDB for its hybrid approach that eliminates the need to switch between different ORMs, its benchmark-leading performance and memory efficiency in .NET 5+, and its rich feature set including bulk operations with identity retrieval, caching, and multi-database support.
Overview
A production-ready data access platform for .NET applications.
Use Cases
Best For
- Building high-performance .NET applications with complex data access patterns
- Applications requiring bulk insert, update, or merge operations with identity column handling
- Projects needing a lightweight ORM with advanced features like caching and tracing
- Developers transitioning from micro-ORMs to more feature-rich solutions without rewriting code
- Multi-database applications supporting SQL Server, SQLite, MySQL, and PostgreSQL
- Scenarios where memory efficiency and AOT compilation performance are critical
Not Ideal For
- Projects relying on databases not supported for fluent operations, such as Oracle or DB2
- Teams preferring ORMs with automatic .NET type coercion enabled by default without configuration
- Environments with strict security policies that prohibit using TrustServerCertificate for SQL Server connections
Pros & Cons
Pros
Combines micro-ORM simplicity with full-ORM features like caching and tracing, allowing seamless switching between basic and advanced operations during development.
Uses compiled expression caching and schema-aware optimizations, making it the fastest ORM in .NET 5+ benchmarks according to RawDataAccessBencher results.
BulkInsert and BulkMerge automatically retrieve and set identity column values into data models, addressing a common edge-case not handled by many ORMs.
Caches object properties, execution contexts, and SQL statements to minimize overhead, contributing to high memory efficiency in performance tests.
Cons
Fluent CRUD operations only work with SQL Server, SQLite, MySQL, and PostgreSQL, excluding other popular databases like Oracle for advanced features.
Requires explicit bootstrapping for providers like System.Data.SqlClient and setting Converter.ConversionType for automatic type coercion, adding setup complexity.
For SQL Server, may need enabling TLS 1.2 or using TrustServerCertificate due to dependencies on Microsoft.Data.SqlClient, which can conflict with secure environments.
Frequently Asked Questions
Related Projects
DapperDapper - a simple object mapper for .Net
DapperDapper - a simple object mapper for .Net
Entity Framework CoreEF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
Entity Framework CoreEF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.