Dapper.SimpleCRUD
DapperQueryBuilder
Dapper.SimpleCRUD | DapperQueryBuilder | |
---|---|---|
2 | 12 | |
1,125 | 480 | |
- | - | |
0.0 | 5.4 | |
4 months ago | about 2 months ago | |
C# | C# | |
GNU General Public License v3.0 or later | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Dapper.SimpleCRUD
-
100 stars in Github - Dapper Query Builder using String Interpolation
Regarding CUD (inserts/updates/deletes), I think Dommel works similarly to Dapper.FastCRUD and Dapper.SimpleCRUD, and those two look a little more mature in my opinion (not sure, but I really have the impression that Dommel is targeted at people who like this LINQ intellisense).
-
Objection to ORM Hatred
I use dapper with a plugin called dapper.simplecrud (https://github.com/ericdc1/Dapper.SimpleCRUD). This already helps to reduce the need to write simple but error-prone SQL code quite a lot. When doing SQL operations more complicated than a simple crud, I resort to raw SQL or stored procedure.
DapperQueryBuilder
-
Interpolated String Builder: like a StringBuilder but for Interpolated Strings
When I first drafted this idea of concatenating FormattableStrings to build SQL, I didn't have any ambition to inherit from FormattableString, then in this new project (aimed at writing something more flexible/reusable and less coupled with Dapper) I realized that I was basically writing what you said - a mutable FormattableString. But yeah, when I rely on this new structure for SQL-Building I should pay extra attention to those risks.
-
Dapper Simple SQL Builder (A simple SQL builder for Dapper using string interpolation)
How does this compare to Dapper Query Builder?
- DapperQueryBuilder using string interpolation
-
Dapper Query Builder using String Interpolation - making Dapper easier, and on my way to reach 250 stars :-)
Yo! Love this library, makes it real easy to put together params for procs. Any headway on Issue #27? I've got a workaround but would love to be able to use multiple result sets natively.
-
What patterns, libraries do you use to enable robust search APIs?
My ideal vision is some higher level library that provides the DSL and parsing, and provides a way to either output Expressions for use with IQueryables or some other implementation to inject it into hand-written SQL queries. I have no clue if such a thing is even possible. I've found Sieve and DapperQueryBuilder. It seems like DapperQueryBuilder would support such a use case, using the Fluent API and conditionally adding Selects, Order By, Where, etc. Have you explored something similar? What did you find?
-
Entity Framework RawQueryBuilder (Replaces FromSqlRaw with StringBuilder-like query builder)
This project is just a fork of another QueryBuilder that I made for Dapper where manually building queries is much more important (as compared to EF where most queries will be made using LINQ expressions - I know).
-
InterpolatedLogging - ILogger extensions to accept Interpolated Strings in Structured Logging
LOL. Just a bored developer who saw an opportunity. :-) When I posted a few days ago about DapperQueryBuilder someone suggested that this same FormattableString-hacking could be used for Logging libraries. Since the major parts of processing FormattableString are identical (same regex, same loops, etc) and since I was a little bored this weekend I decided to try out this idea :-)
- 100 stars in Github - Dapper Query Builder using String Interpolation
What are some alternatives?
Dapper.FastCRUD - fast & light .NET ORM for strongly typed people
Dapper - Dapper - a simple object mapper for .Net
Dapper Extensions - Dapper Extensions is a small library that complements Dapper by adding basic CRUD operations (Get, Insert, Update, Delete) for your POCOs. For more advanced querying scenarios, Dapper Extensions provides a predicate system. The goal of this library is to keep your POCOs pure by not requiring any attributes or base class inheritance.
csharplang - The official repo for the design of the C# programming language
Norm.net - Norm.net is an innovative and high-performance Database Access for .NET Standard 2.1 and higher
sql-template-tag - ES2015 tagged template string for preparing SQL statements, works with `pg`, `mysql`, and `sqlite`
Slick - Slick (Scala Language Integrated Connection Kit) is a modern database query and access library for Scala
EntityFrameworkCore.RawQueryBuilder - Entity Framework Core Query Builder (allows to dynamically add conditions) using Raw SQL statements and string interpolation
TypeORM - ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
Sieve - ⚗️ Clean & extensible Sorting, Filtering, and Pagination for ASP.NET Core