MD-DbToolLibrary 1.0.0

dotnet add package MD-DbToolLibrary --version 1.0.0                
NuGet\Install-Package MD-DbToolLibrary -Version 1.0.0                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="MD-DbToolLibrary" Version="1.0.0" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add MD-DbToolLibrary --version 1.0.0                
#r "nuget: MD-DbToolLibrary, 1.0.0"                
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install MD-DbToolLibrary as a Cake Addin
#addin nuget:?package=MD-DbToolLibrary&version=1.0.0

// Install MD-DbToolLibrary as a Cake Tool
#tool nuget:?package=MD-DbToolLibrary&version=1.0.0                

MD-DbToolLibrary

The MD-DbToolLibrary is a powerful .NET database utility library that simplifies common database operations and provides a robust set of features to streamline your data-driven application development.

Features

  • Connection Management: Easily manage database connections with the ConnectionString() and ConnectionStringHive() methods, which allow you to retrieve and customize connection strings.
  • Data Retrieval: Retrieve data from the database using various methods like GetDataTable(), GetMonoCodeDataTable(), and ----GetDataTableHive(), which return data in a DataTable format.
  • Data Manipulation: Perform database operations such as inserting, updating, and deleting data using methods like InsertData(), UpdateColumnReturnRows(), and UpdateColumn().
  • Single Value Retrieval: Retrieve single values from the database using the GetSingleData() and GetSingleValueFromTable() methods.
  • Data Validation: Check for the existence of data in the database using the SingleItemSearch() and SingleValueValidityCheck() methods.
  • Asynchronous Support: Leverage the power of asynchronous programming with methods like GetDataTableMultiParameters().
  • Robust Error Handling: The library provides comprehensive error handling to ensure your application remains stable and reliable.

Getting Started

  1. Install the library from the NuGet package manager or by adding the following package to your project:
Install-Package MD-DbToolLibrary
  1. Import the necessary namespace in your C# file:
using MDDbTool;
  1. Create an instance of the MDDbToolLibrary class and utilize the available methods to interact with your database.
var dbTool = new MDDbToolLibrary();
string connectionString = dbTool.ConnectionString();
DataTable data = dbTool.GetDataTable("MyTable", "id, name", "WHERE id = 1");

Documentation

Detailed documentation for the MD-DbToolLibrary, including method descriptions, parameters, and examples, can be found in the repository's wiki.

Contributing

Contributions to the MD-DbToolLibrary are welcome! If you encounter any issues, have feature requests, or would like to contribute code, please feel free to open an issue or submit a pull request on the GitHub repository.

#License The MD-DbToolLibrary is licensed under the MIT License.

Product Compatible and additional computed target framework versions.
.NET Framework net47 is compatible.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.0.0 101 5/31/2024

Version 1.0.0:
     - Initial release of the MD-DbToolLibrary