RepoDB — a production-ready data access platform for .NET applications.

RepoDB is a high-performance data productivity platform for .NET developers. At its core is the popular hybrid-ORM library for .NET.

RepoDB is best for simplifying data layer implementations, processing millions of records, and integrating multiple data sources. It provides the flexibility to work the way you want—all through the IDbConnection interface.

Write raw SQL when you need absolute control, or use the fluent APIs for more productivity. You can switch seamlessly between both approaches without sacrificing performance or maintainability.

Every operation is an extension method of IDbConnection interface. Simply open a connection and you can start working with your database — no need for repositories to scaffold, no context classes, no code generation.

using (var connection = new SqlConnection(ConnectionString))
{
    // Query
    var customer = connection.Query<Customer>(c => c.Id == 10045).FirstOrDefault();

    // Insert
    var id = connection.Insert<Customer>(new Customer { FirstName = "John", LastName = "Doe" });

    // Update
    customer.LastName = "Smith";
    connection.Update<Customer>(customer);

    // Delete
    connection.Delete<Customer>(customer);
}

Moving thousands (or millions) of rows at once? Add the .BulkOperations package for your provider (e.g. RepoDb.SqlServer.BulkOperations) and keep using the same connection:

using (var connection = new SqlConnection(ConnectionString))
{
    var customers = GetCustomers(); // thousands or millions of rows

    connection.BulkInsert<Customer>(customers);
    connection.BulkMerge<Customer>(customers, qualifiers: e => new { e.LastName, e.DateOfBirth });
}

You can do this in all supported DB providers.

Project	Nuget	Downloads	Status
RepoDb.Core
RepoDb.SqlServer
RepoDb.SqlServer.BulkOperations
RepoDb.Oracle 🆕
RepoDb.Oracle.BulkOperations 🆕
RepoDb.PostgreSql
RepoDb.PostgreSql.BulkOperations
RepoDb.MySql
RepoDb.MySql.BulkOperations 🆕
RepoDb.MySqlConnector
RepoDb.MySqlConnector.BulkOperations 🆕
RepoDb.Db2 🆕
RepoDb.Db2.BulkOperations 🆕
RepoDb.Sqlite.Microsoft
RepoDb.Telemetry.Core 🆕
RepoDb.Telemetry.Default 🆕

As a hybrid ORM, RepoDB gives you the raw performance and control of manual data access with the convenience of a full-featured library.

As a productivity platform, RepoDB goes beyond the ORM with enterprise-grade capabilities that help developers build, operate, and scale with confidence.

The RepoDB ORM will always remain the heart of the ecosystem and will continue to be free and open source, just as it has been since the project began.

Our investment is now focused on building additional capabilities around that foundation—expanding RepoDB into a comprehensive suite of enterprise-grade productivity tools for developers, architects, and organizations. Every new capability is designed to complement the ORM, enabling teams to build faster, operate smarter, and prepare their applications for the future without changing the way they work today.

RepoDB is no longer just an ORM in the near future — it is becoming a complete ecosystem for modern data development.

Choose your database and follow the quick-start guide:

• SQL Server
• Oracle
• PostgreSQL
• MySQL
• Db2
• SQLite

Explore individual features in the documentation.

Want visibility into what your operations are doing in production? See Telemetry below to enable opt-in insights with a couple lines of code.

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, Oracle, MySQL, PostgreSQL, IBM DB2 and SQLite.

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

GlobalConfiguration
    .Setup(new Options.GlobalConfigurationOptions()
    {
        ConversionType = ConversionType.Automatic
    })
    .UseSqlServer();

RepoDB sits between a micro-ORM and a full ORM. Each tool below makes different tradeoffs — pick the one that fits your project:

Dapper and Entity Framework are both excellent, mature tools — this reflects design tradeoffs, not a ranking.

RepoDB includes opt-in, drop-in telemetry via RepoDb.Telemetry.Default. Enable it once at startup and every operation (Insert, Query, Update, Delete, etc.) is captured and published to your insights collector automatically — no custom ITrace required.

It comes with great and simple dashboards visualization.

Simply docker compose up -d the docker-compose.yml and .env files and integrate your code.

GlobalConfiguration
    GlobalConfiguration
    .Setup(new GlobalConfigurationOptions { UseRegisteredGlobalTraces = true })
    .UseDefaultTelemetry(new DefaultTelemetryOption("<YOUR_APPLICATION_NAME>")
    {
        Host = "https://your-collector-host",
        ApiKey = "YOUR_API_KEY",
        Group = "<YOUR_APPLICATION_GROUP>",
        Frequency = TimeSpan.FromSeconds(1)
    });

It's intentionally lightweight rather than OTel-based, keeping RepoDB's thin, fast footprint intact. See the package README for configuration options, the full OTel rationale, and the roadmap.

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 ⭐

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

Read our contibuting page for more.

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

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

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

Apache-2.0 — Copyright © 2018 Michael Camara Pendon