RepoDb is an open-source .NET ORM library that bridges the gaps of micro-ORMs and full-ORMs. It helps you simplify the switch-over of when to use the BASIC and ADVANCE operations during the development.

It is your best alternative ORM to both Dapper and EntityFramework.

👋 Hey Scott, thank you for endorsing RepoDb into the community of .NET.

Like with any other ORMs, RepoDb does provide the preliminary methods needed for the basic operations (i.e.: CRUD). The good thing is, RepoDb also does provide an advance operations to cater the advance use-cases like 2nd-Layer Cache, Tracing, Repositories, Property Handlers and Batch/Bulk Operations.

If you are to use RepoDb, your development experience is as simple as Dapper when opening a connection and is as simple as Entity Framework when executing an operation. It is the reason that makes this library the simpiest ORM to use.

When you do the bulk operations, the generated value of the identity columns will be set back to the data models, just right after the execution. This is a very important advanced use-case that is needed by most, and both the BulkInsert and BulkMerge operations addressed this need.

Lastly, RepoDb does support the different way-of-executions (the atomic, the batch and the bulk). Through this, you can create a very powerful repository that can process the smallest-to-the-largest datasets without even affecting the efficiency and the performance that much.

Below are some of the important attributes that is a part of the package and you will easily leverage being a user of this library.

RepoDb operations were all implemented as extended methods of IDbConnection object. For as long your connection is open, any operations can then be called against your database.

RepoDb caches the already-generated compiled expressions for future reusabilities and executions. It understands your schema to create the most optimal compiled expression AOT.

RepoDb extracts and caches the object properties, execution contexts, object mappings and SQL statements. It is reusing them all throughout the process of transformations and executions.

RepoDb is a high-quality micro-ORM supported by 10K+ real-life Unit and Integration Tests. It is highly tested and used by various critical systems that are running in production environment.

Please click any of the link below to fast-track your learnings.

• SqlServer
• SqLite
• MySql
• PostgreSql

Or, learn a specific feature.

• Batch Operations
• Bulk Operations
• Caching
• Class Mapping
• Dynamics
• Connection Persistency
• Enumeration
• Expression Trees
• Hints
• Implicit Mapping
• Multiple Query
• Property Handlers
• Repositories
• Tracing
• Transaction
• Type Mapping

Otherwise, please visit our documentation page to learn more.

The execute methods below support all the RDBMS data providers.

• ExecuteQuery
• ExecuteNonQuery
• ExecuteScalar
• ExecuteReader
• ExecuteQueryMultiple

Whereas the fluent methods below only support the SQL Server, SQLite, MySQL and PostgreSQL RDBMS data providers.

• Query
• Insert
• Merge
• Delete
• Update

Click here to see all the operations.

The benchmark result to be shown on this page will always be referring to the community-approved ORM bencher tool (the RawDataAccessBencher tool). Results below is the actual recent official execution result.

We would like to make RepoDb the mainstream hybrid-ORM library for .NET technology. Please help us build and realize the solution.

To contribute, you can find a for-grabs item and issue a PR. Otherwise, you may create a new issue for us to look-at and discuss.

If you wish to contribute to the documentation site, it is hosted in the RepoDb.NET repository. Your expertise is needed to correct the forms, if needed.

Your biggest contribution is to utilize and share this library to the other developers.

• Blog it
• Discuss it
• Document it
• Share it
• Use it

Or, show your support by simply giving a ⭐ on this project.

Please get in touch with us via:

• GitHub - for any issues, requests and problems.
• StackOverflow - for any technical questions.
• Twitter - for the latest news.
• Gitter Chat - for direct and live Q&A.

• Building the Solutions - let us build your copies.
• Coding Standards - let us be uniformed.
• Issuing a Pull-Request - let us be aligned and notified.
• Reporting an Issue - let us be organized for easy tracking and fixing.

Thank you to all the contributors of this project, and to Scott Hanselman for Exploring the .NET open source hybrid ORM library RepoDB.

And also, thank you to these awesome OSS projects.

• AppVeyor - for the builds and test-executions.
• GitHub - for hosting this project.
• Gitter - for the community engagements.
• Jekyll - for powering our website.
• Moq - for being the tests mocking framework.
• Nuget - for the package deliveries.
• RawDataAccessBencher - for measuring the performance and efficiency.
• ReadTheDocs - for the library documentations.
• SharpLab - for helping us on our IL coding.
• Shields - for the awesome badges.
• StackEdit - for being the markdown file editor.
• System.Data.SQLite, MySql.Data, MySqlConnector, Npgsql - for being the extended DB provider drivers.

Apache-2.0 - Copyright © 2019 - Michael Camara Pendon