RepoDB — a Hybrid ORM for .NET

RepoDB is a fast, lightweight, and open-source .NET ORM that gives you the best of both worlds: the simplicity of a micro-ORM and the power of a full ORM — without the overhead.

Write raw SQL when you need full control. Use fluent methods when you want productivity. Switch between them freely, in the same codebase.

Packages and Build Status

Project	Nuget	Downloads	Status
RepoDb
RepoDb.SqlServer
RepoDb.MySql
RepoDb.MySqlConnector
RepoDb.PostgreSql
RepoDb.SQLite.System
RepoDb.Sqlite.Microsoft
RepoDb.SqlServer.BulkOperations
RepoDb.PostgreSql.BulkOperations

Why RepoDB?

Expand to learn more

Easy to Use — all operations are extension methods on IDbConnection. Open a connection and you're ready to go.

High Performance — compiled expressions are cached and reused. RepoDB understands your schema to generate the most efficient execution path ahead of time.

Memory Efficient — object properties, execution contexts, mappings, and SQL statements are extracted once and reused throughout the lifetime of your application.

Hybrid by Design — use fluent methods for everyday CRUD, drop down to raw SQL for complex queries, or mix both — all within the same connection.

Battle-Tested — backed by thousands of unit and integration tests, and used in production systems worldwide.

Always Free — Apache 2.0 licensed, forever open source.

Get Started

Choose your database and follow the quick-start guide:

• SQL Server
• MySQL
• PostgreSQL
• SQLite

Explore individual features in the documentation.

Supported Databases

Raw SQL execution methods work with any ADO.NET-compatible provider:

• ExecuteQuery
• ExecuteNonQuery
• ExecuteScalar
• ExecuteReader
• ExecuteQueryMultiple

Fluent operations (Query, Insert, Merge, Delete, Update, and more) are supported for SQL Server, MySQL, PostgreSQL, and SQLite.

Type Coercion

RepoDB uses ADO.NET's native coercion by default, keeping type mismatches visible and explicit. To enable automatic conversion:

RepoDb.Converter.ConversionType = ConversionType.Automatic;

Contributions

We welcome contributions of all kinds — code, docs, bug reports, and ideas.

• Browse for-grabs issues and submit a PR.
• File a new issue to start a discussion.
• Contribute to the documentation site.
• Blog about it, share it, or simply give us a :star:

Community

• GitHub Issues — bug reports and feature requests.
• StackOverflow — technical questions.
• Microsoft Teams — live Q&A and community chat.
• X / Twitter — news and updates.

Resources

• Building the Solutions
• Coding Standards
• Issuing a Pull Request
• Reporting an Issue
• Support Policy

Contributors

Credits

Thanks to all contributors and to Scott Hanselman for featuring RepoDB.

ATools and projects that make RepoDB possible: GitHub, Microsoft Teams, Moq, NuGet, RawDataAccessBencher, Shields, Microsoft.Data.Sqlite, System.Data.SQLite.Core, MySql.Data, MySqlConnector, Npgsql.

License

Apache-2.0 — Copyright © 2018 Michael Camara Pendon