Description
A hybrid ORM library for .NET.
Package: https://www.nuget.org/packages/RepoDb
Documentation: https://repodb.readthedocs.io/en/latest/
Follow @mike_pendon at Twitter.
RepoDb alternatives and similar packages
Based on the "ORM" category
-
TypeORM
Data-Mapper ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, WebSQL databases. Works in Node.js and Browser. -
Entity Framework
Object-relational mapper that enables .NET developers to work with relational data using domain-specific objects -
Fluent NHibernate
Fluent, XML-less, compile safe, automated, convention-based mappings for NHibernate. -
freesql
FreeSql is the ORM in .NetCore, .NetFramework, And Xamarin. It supports Mysql, Postgresql, SqlServer, Oracle, Sqlite, Odbc, 达梦, And MsAccess. -
LINQ to DB
The fastest LINQ database access library offering a simple, light, fast, and type-safe layer between your POCO objects and your database. -
Dapper Extensions
Small library that complements Dapper by adding basic CRUD operations (Get, Insert, Update, Delete) for your POCOs -
Entity Framework 6
Object-relational mapper that enables .NET developers to work with relational data using domain-specific objects -
NPoco
Simple microORM that maps the results of a query onto a POCO object. Based on Schotime's branch of PetaPoco -
SmartSql
SmartSql = MyBatis + Cache（Memory | Redis）+ ZooKeeper + R / W Splitting + Dynamic Repository .... -
SQLProvider
A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides. -
MongoDB Repository pattern implementation
Repository abstraction layer on top of Official MongoDB C# driver -
DbExtensions
Data-access framework with a strong focus on query composition, granularity and code aesthetics. -
NReco.Data
Lightweight provider-independent DAL for .NET Core: abstract query, SQL command builder, CRUD operations, object mapping.. -
MicroLite ORM
MicroLite ORM is a micro Object Relational Mapper for the .NET framework. It is designed to be easy to use, extensible and testable. -
Linq.Expression.Optimizer
System.Linq.Expression expressions optimizer. -
EntityFramework.DatabaseMigrator
EntityFramework.DatabaseMigrator is a WinForms utility to help manage Entity Framework 6.0+ migrations. -
Entity Framework Core
Object-relational mapper that enables .NET developers to work with relational data using domain-specific objects -
LLBLGen Pro
Entity Modeling solution for Entity Framework, NHibernate, Linq to SQL and its own ORM framework: LLBLGen Pro Runtime Framework. [$][Free Lite version]
* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest. Visit our partner's website for more details.
Do you think we are missing an alternative of RepoDb or a related project?
Popular Comparisons
-
RepoDbvsDapper
-
RepoDbvsLINQ to DB
-
RepoDbvsNPoco
-
RepoDbvsServiceStack.OrmLite
-
RepoDbvsNReco.Data
|
SaaSHub - Software Alternatives and Reviews
View more from us
|
README
RepoDb - a hybrid ORM Library for .NET.
RepoDb is an open-source .NET ORM that bridge the gaps between micro-ORMs and full-ORMs. It helps the developer to simplify the switch-over of when to use the BASIC and ADVANCE operations during the development.
It is the best alternative ORM to both Dapper and EntityFramework.
The benefits of using this library
- The development experience is like Dapper but the feature is almost like EntityFramework.
- The installation is easy and fast, it can then be used right-away.
- The layer of like DbContext has been eliminated, those give the developers more control on the implementation.
- The calls to fluent and raw-SQL methods is just a dot away.
- The implementation of repository is becoming more simple by leveraging the built-in repositories.
- The control to query optimizations is easy via hints.
- The processes to handle the large datasets is very-simple with batch and bulk operations.
- The round-trips to the database is being minimized with 2nd-Layer cache.
- The column transformation can be customized with property handlers.
- The auditing and tracing is much more simpler using the trace capability.
- The support to dynamics is rich and can even work without the models.
- The transmission of the data from different RDBMS data providers only take few lines of codes.
It is easy-to-use
RepoDb operations were implemented as extended methods of the IDbConnection object. For as long the connection is open, the developers can do all the activities towards the database.
It is high-performant
RepoDb has its own compiler and pre-caches the already-generated compiled expressions for future reusabilities. It understands your schema to create the most optimal compiled expression AOT.
It is efficient
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.
It is high-quality
RepoDb is a high-quality micro-ORM supported by 8K+ real-life Unit and Integration Tests. It is highly tested by various critical systems that is running in production environment.
Get Started
Please click any of the link below to fast-track your learnings.
Or, learn the 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.
Supported Databases
The execute methods below supports all RDBMS data providers.
Whereas the fluent methods below only supports the SQL Server, SQLite, MySQL and PostgreSQL RDBMS data providers.
Click here to see all the operations.
Benchmark
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.
This section will always be updated with the latest official result.
Contributions
We would like to make RepoDb the mainstream hybrid-ORM library for .NET technology. Please help us build and realize the solution.
To contribute, please find a for-grabs item and issue a PR. Otherwise, please 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 biggest contribution is to utilize and share this solution to other developers.
- Blog it
- Discuss it
- Document it
- Share it
- Use it
Engagements
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.
Hints
- Building the Solutions - let us build your copies.
- Coding Standards - let us be uniformed.
- Reporting an Issue - let us organize for easy tracking and fixing.
Credits
- 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, Npgsql - for being the extended DB provider drivers.
License
Apache-2.0 - Copyright © 2019 - Michael Camara Pendon
*Note that all licence references and agreements mentioned in the RepoDb README section above
are relevant to that project's source code only.