DapperQueryBuilder
Dapper.FastCRUD
| DapperQueryBuilder | Dapper.FastCRUD | |
|---|---|---|
| 12 | 1 | |
| 480 | 484 | |
| - | - | |
| 5.4 | 3.8 | |
| about 2 months ago | 4 months ago | |
| C# | C# | |
| MIT License | 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.
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
Dapper.FastCRUD
-
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).
What are some alternatives?
Dapper.SimpleCRUD - Who wants to write basic read/insert/update/delete statements? SimpleCRUD provides simple CRUD helpers for Dapper.
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.
Dapper - Dapper - a simple object mapper for .Net
csharplang - The official repo for the design of the C# programming language
MicroOrm.Dapper.Repositories - CRUD for Dapper
Norm.net - Norm.net is an innovative and high-performance Database Access for .NET Standard 2.1 and higher
LINQ to DB - Linq to database provider.
EntityFrameworkCore.RawQueryBuilder - Entity Framework Core Query Builder (allows to dynamically add conditions) using Raw SQL statements and string interpolation
Sieve - ⚗️ Clean & extensible Sorting, Filtering, and Pagination for ASP.NET Core
Entity Framework - EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.