34 packages tagged with “DbHelper”
轻型ADO.NET操作类
A set of .NET 9/8/7/6/5/Standard 2.1/Standard 2.0 Database Access utilities for SqlServer/MSSQL(support .net framework 4.52/4.6/4.7/4.8). Please visit https://github.com/cuiwenyuan/DotNet.Util for more information
Msbuild task for auto generating CpsDBHelper's data-access code from a Sql dbproject (SSDT), it ONLY works with vs' dbproject
Chain-styled Sql DB Helper
DBHelpers is a simple but powerful helper library for working with plain ADO.NET.
ys DBHelper
公共ADO数据访问DBHelper和Tools工具类, 原Jurassic.Com的.netcore版本
ORM For PostgreSQL
xz DBHelper
Debug!!!DBHelper for Oracle , SQLServer , PostgreSQL with .Net 6. \n Source code: https://github.com/yuguansu/DBHelper
ado.net helper for oracle
MSSQL数据访问层
CpsDbHelper(Chain-styled Sql DB Helper)'s postgres extension, using npgsql as underlying provider
dbhelper auto adapter factory with mssql mysql oracle
Library to to simplify SQL database interactions. You will have tools like dlookup(), dmin(), dmax(), etc. This library is made for those who use Access VBA and use this functions. ExcecuteReader<T>() and ExecuteNonReader() are available in order to fill a strong typed class list from a sql query. It can consume an API.
.NET Common Code Library
This library contains useful database utilitity classes, functions and extension methods. ADO.NET wrapper specifically develop to help make life easy working with relational databases like SQLServer, MySql, PostgreSql, MariaDB, Oracle and stored procedures. LiteXDbHelper is simple and tiny yet powerful and very high-performance library to working with ADO.NET for .NET 5, .NET Core, .NET Standard applications.
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.
该扩展包是虹猫科技提供的数据库帮助类
A set of .NET 9/8/7/6/5/Standard 2.1/Standard 2.0 Database Access utilities for Oracle (support .net framework 4.52/4.6/4.7/4.8). Please visit https://github.com/cuiwenyuan/DotNet.Util for more information
DB Connection for ado.net. Use for .net framework only
A set of .NET 9/8/7/6/5/Standard 2.1/Standard 2.0 Database Access utilities for MySQL(support .net framework 4.52/4.6/4.7/4.8). Please visit https://github.com/cuiwenyuan/DotNet.Util for more information
Library to to simplify SQL database interactions. You will have tools like dlookup(), dmin(), dmax(), etc. This library is made for those who use Access VBA and use this functions. ExcecuteReader and ExecuteNonReader() are available in order to fill a strong typed class list from a sql query. It can consume an API.
A set of .NET 9/8/7/6/5/Standard 2.1/Standard 2.0 Database Access utilities for SQLite(support .net framework 4.52/4.6/4.7/4.8). Please visit https://github.com/cuiwenyuan/DotNet.Util for more information
A robust and extensible library for seamless interaction with SQLite databases. This library provides essential utilities for database connection management, schema initialization, and CRUD operations, offering an efficient and reliable foundation for applications requiring SQLite data persistence.
Provide more abstraction for running sql server queries
This is a tiny library helps write less code, to execute queries and stored procedures against Oracle database as like any normal CLR method. It is just written for the purpose to bring a new level of ease to the developers who deal with ADO.NET for data access. LiteXDbHelper is simple and tiny yet powerful and very high-performance library to working with ADO.NET for .NET 5, .NET Core, .NET Standard applications.
This is a tiny library helps write less code, to execute queries and stored procedures against SQL Server as like any normal CLR method. It is just written for the purpose to bring a new level of ease to the developers who deal with ADO.NET for data access. LiteXDbHelper is simple and tiny yet powerful and very high-performance library to working with ADO.NET for .NET 5, .NET Core, .NET Standard applications.
A set of .NET 9/8/7/6/5/Standard 2.1/Standard 2.0 Database Access utilities for Access/OleDb(support .net framework 4.52/4.6/4.7/4.8). Please visit https://github.com/cuiwenyuan/DotNet.Util for more information
A set of .NET 9/8/7/6/5/Standard 2.1/Standard 2.0 Database Access utilities for PostgreSql(support .net framework 4.52/4.6/4.7/4.8). Please visit https://github.com/cuiwenyuan/DotNet.Util for more information