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.
Alternatively, view RepoDb alternatives based on common mentions on social networks and blogs.
-
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 -
FreeSql
FreeSql is the ORM in .NetCore, .NetFramework, And Xamarin. It supports Mysql, Postgresql, SqlServer, Oracle, Sqlite, Odbc, 达梦, And MsAccess. -
Fluent NHibernate
Fluent, XML-less, compile safe, automated, convention-based mappings for NHibernate. -
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. -
LLBLGen Pro
Entity Modeling solution for Entity Framework, NHibernate, Linq to SQL and its own ORM framework: LLBLGen Pro Runtime Framework. [$][Free Lite version] -
Entity Framework Core
Object-relational mapper that enables .NET developers to work with relational data using domain-specific objects
Pixel-Perfect Multi-Platform Applications with C# and XAML
* 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?
README
RepoDB - a hybrid ORM Library for .NET.
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.
:wave: Hey Scott, thank you for endorsing RepoDB into the community of .NET.
To get the latest updates about this library, follow us on Twitter!
Benefits/Advantages
Like with any other ORMs, RepoDB does provide the preliminary methods needed for your basic operations. The good thing is, it also does provide the operations that is needed to cater your edge-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 simpliest 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 your execution. It is an important use-case that is/may needed by you and/or most developers, and both the BulkInsert and BulkMerge operations addressed this need.
RepoDB also does support the different way-of-executions (the atomic, the batch and the bulk). Through this, it is easy for you to establish your repository that can process the smallest-to-the-largest datasets without even affecting the efficiency and the performance of your application.
Important Attributes
Easy-to-use - the operations were all implemented as extension methods of your IDbConnection object. For as long your connection is open, any operations can then be called against your database.
High performant - it caches the already-generated compiled expressions for future reusabilities and executions. It understands your schema to create the most optimal compiled expression AOT.
Memory efficient - it extracts and caches your object properties, execution contexts, object mappings and SQL statements. It is reusing them all throughout the process of transformations and executions.
High quality - it is a high-quality micro-ORM supported by 10K+ real-life Unit and Integration Tests. It is highly tested and is used by various critical systems that are running in the Production environment.
Get Started
Please click any of the link below to fast-track your learnings.
Or, learn a specific feature.
- Batch Operations
- Bulk Operations
- Caching
- Class Handlers
- Class Mapping
- Dynamics
- Connection Persistency
- Enumeration
- Expression Trees
- Hints
- Implicit Mapping
- Multiple Query
- Property Handlers
- Repositories
- Targeted Operations
- Tracing
- Transaction
- Type Mapping
Otherwise, please visit our documentation page to learn more.
Supported Databases
The execute methods below support all the RDBMS data providers.
Whereas the fluent methods below only support the SQL Server, SQLite, MySQL and PostgreSQL RDBMS data providers.
Click here to see all the operations.
Package Referencing
By default, .NET is auto-resolving the references, however, we strongly recommend that you always explicitly reference the RepoDb core library. The rationale behind this is that, the RepoDb core library is a fast-moving package in which all the alpha/beta releases, hotfixes and/or even the actual releases could happen without affecting the extension libraries.
Please note that we are releasing an actual next released-version if the changes are having minimal impact but is important for the other users.
You can always target the version when installing the library, even it is on a semantic release.
> Install-Package RepoDb -version 1.x.x-betaX
.NET Type Coercion
By default, RepoDB does not do the automatic .NET CLR Type conversion during the serialization and deserialization process. The coercion support is completely dependent to the ADO.NET coercion capability.
It is in purpose to strictly notify you (as a library user) the design and/or the implementation problem of the entity model if being compared to its corresponding database table/view.
If you wish to have an automatic conversion, simply set the Converter.ConversionType property to Automatic.
RepoDb.Converter.ConversionType = ConversionType.Automatic;
Note: The exception that is being thrown is dependent to what the underlying ADO.NET coercion exception. If the Automatic conversion is used, the extracted value will always be evaluated and an additional conversion logic will be used (if needed). The conversion logic is through the AOT compilation of System.Linq.Expressions.Expression.Convert and/or System.Convert.
Exception Handling
As the compiler exception is a bit low-level and is not descriptive for the native language, therefore, when compiling the process of hydration from/to the database and the application, a customized exception is being thrown to provide a detailed exception messages to the callers.
On the other hand, as part of the standard when writing code in RepoDB (i.e.: respect the default exception handling of .NET, ensure an unharmonized exception when bubbling up the exception messages), RepoDB does not contain a single line of code that catches and rethrowing any exception (try-catch statement). Any exception happens within the library whether it is an ADO.NET exception and/or whatever will be bubble up natively back to the callers.
Library Limitations
It is very important for you and to the community of .NET to learn the things the library is capable and is-not capable of doing, so please spend time reading the limitation page before using the library.
Benchmark
The benchmark result shown on this section is the result of the community-approved ORM bencher tool, the RawDataAccessBencher tool.
Below is the actual recent official execution result.
RepoDB shows an impressive performance and memory-efficiency if being compared with other ORMs available in the .NET ecosystem. It has positioned itself just right behind the logic-less hand-coded materializer if being benchmark with .NET Core and .NET Framework. However, RepoDB is the fastest and the most-efficient ORM if being benchmark with .NET 5, even beating the hand-coded materializer.
Important Note
The AOT compilation (IL/Expression) has some degree of performance impact, even just for milliseconds, therefore, if you are to materialize RepoDB, it is highly recommended to always eliminate the first execution.
To avoid the bias, you as well should exclude the first execution of the other ORMs during the benchmarking.
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, 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 :star: on this project.
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.
Ensure to visit our Support Policy to get more details about our policies when handling the operational support for this library.
Hints
- 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.
Credits
Thanks to all the contributors of this project, and to Scott Hanselman for Exploring the .NET open source hybrid ORM library RepoDB.
And also, thanks 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.
- Microsoft.Data.Sqlite, System.Data.SQLite.Core, MySql.Data, MySqlConnector, 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.