Found 62 packages
The Dapper SqlBuilder component, for building SQL queries dynamically.
Dapper Query Builder using Fluent API and String Interpolation
A simple and performant SQL builder for Dapper, using string interpolation and a fluent API to build safe, static, and dynamic SQL queries.
Library lets to build sql queries for Dapper in a declarative manner by using criteria classes with attributes applied to thier properties
DBのSelect,Insert,Update,Delete操作を拡張メソッドで提供します。 属性/ラムダ式の指定をもとに内蔵クエリビルダが実行SQLを自動生成します。SQL記述不要でDBを参照更新できます。 This library provides CRUD operations of the database as Extension Methods. By specifying Attribute / Lambda-Expression, You can perform database query/update using Dapper without writing SQL.
Simplifies the use of Qb.Net with Dapper
FluentDbTools provides a fluent SQL abstraction layer for creating database connections, building sql queries and migrating your database.
Dependency injection extension for Dapper.SimpleSqlBuilder.
Provides Adapter For Dapper，SqlRepoEx Provides Lambda Turn to Full SQL statement(Select,Union,Join etc.) ;
A blatant ripoff of Dapper's SqlBuilder. Use me to easily build parameterized dynamic sql. Parameter buildup intended for use with Dapper.
Package Description
Fluent SQL builder for Dapper
Simple and powerful SQL builder
A blatant ripoff of Dapper's SqlBuilder. Use me to easily build parameterized dynamic sql.
To make full use of web APIs, exclude the installation of extra packages by just installing DapperDBHelper. Create an object of DapperDBHelper and pass your connection string through the constructor of the DBHelper class. Here's how you can use DapperDBHelper. Below is an example: public class SetupsController { private readonly DBHelpers _dBHelpers; public SetupsController() { _dBHelpers = new DBHelpers(ConectionString.connectionString); } public async Task<List<YourViewModelClass>> GetSingleListAsync() { var result = await _dBHelpers.QueryAsyncList<YourViewModelClass>("SELECT * FROM table"); return result; } public YourViewModelClass GetSingleRecord() { var result = _dBHelpers.Query<YourViewModelClass>("SELECT TOP 1 * FROM table"); return result; } public async Task<Dictionary<string, IEnumerable<object>>> GetMultipleTablesAsync(int id) { // Make a list of table names that your stored procedure returns List<string> tableNames = new List<string> { "Table1", "Table2", "Table3" }; var result = await _dBHelpers.QueryMultipleAsync("EXEC Store_Procedure @ID", new { ID = id }, tableNames); return result; } // Execute Method is used for CRUD operations // After execution of your stored procedure, returning a single row of current execution is a best practice // ExecuteAsync call depends upon your application nature public async Task<int> InsertDataAsync(Employees model) { var result = await _dBHelpers.ExecuteAsync("EXEC Store_Procedure @FirstName, @LastName, @Address", new { FirstName = model.FirstName, LastName = model.LastName, Address = model.Address }); return result; } } For .NET 8, you can use the following code: // Register your service here builder.Services.AddTransient<DBHelpersForAllDatabases>(); // Register your database connection builder.Services.AddTransient<IDbConnection>(_ => new SqlConnection(Configuration.GetConnectionString("DefaultConnection"))); public class MyController : ControllerBase { private readonly DBHelpersForAllDatabases _dbHelpers; public MyController(DBHelpersForAllDatabases dbHelpers) { _dbHelpers = dbHelpers; } [HttpGet] public async Task<IActionResult> Get() { // Use DBHelpers to execute queries var result = await _dbHelpers.QueryAsyncList<MyModel>("SELECT * FROM MyTable"); return Ok(result); } } In this setup: GetSingleListAsync: Asynchronously retrieves a list of records from a table. GetSingleRecord: Retrieves a single record from a table. GetMultipleTablesAsync: Executes a stored procedure that returns multiple tables and maps them to a dictionary. InsertDataAsync: Executes a stored procedure to insert data into a table. Make sure to adjust the method signatures and implementations to match your specific use case and requirements. This setup allows you to effectively manage database interactions using DapperDBHelper in a streamlined manner.
Extension methods to aid in the execution with Dapper of queries written with Flepper..