A lightweight extension for Dapper that simplifies CRUD operations by generating SQL queries from POCO entities.
Dommel is a lightweight extension library for Dapper that simplifies CRUD (Create, Read, Update, Delete) database operations in .NET applications. It automatically generates SQL queries from POCO entities, reducing the need for repetitive boilerplate code while leveraging Dapper's high-performance data mapping. It solves the problem of writing manual SQL for common data access patterns, making database interactions more intuitive and maintainable.
.NET developers using Dapper who want to reduce SQL boilerplate for CRUD operations without adopting a full-fledged ORM like Entity Framework. It's ideal for projects where performance is critical but convenience is also desired.
Developers choose Dommel because it combines the simplicity of automatic SQL generation with the raw performance and control of Dapper. Unlike heavier ORMs, it stays lightweight and focused, offering extensibility points to customize behavior without introducing unnecessary complexity.
CRUD operations with Dapper made simple.
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Generates INSERT, SELECT, UPDATE, and DELETE queries from POCO entities automatically, reducing manual SQL boilerplate as highlighted in the key features.
Translates LINQ expressions to SQL WHERE clauses for type-safe querying, enhancing code maintainability without raw SQL strings.
Leverages Dapper for query execution and object mapping, ensuring high performance and maintaining low-level control over database interactions.
Offers extensibility points to override table/column name resolution and property mapping, providing flexibility beyond default behaviors as noted in the README.
Only supports basic LINQ expressions; complex queries like joins or aggregates require falling back to manual SQL, reducing convenience for advanced use cases.
Documentation is hosted externally on Learn Dapper, which may be less integrated, potentially outdated, or harder to navigate compared to inline docs.
Lacks ORM features like change tracking, migrations, or stored procedure support out-of-the-box, necessitating additional work or dependencies for full functionality.
Dommel is an open-source alternative to the following products:
NHibernate is an object-relational mapping (ORM) solution for the .NET platform, providing a framework for mapping an object-oriented domain model to a traditional relational database.
Entity Framework Core is a lightweight, extensible, open-source version of Entity Framework for .NET Core and .NET 5+ applications.