QueryDB

QueryDB solution in .NET.

QueryDB is a flexible database query framework designed to simplify querying and executing transactions across multiple database systems.

Supported Databases

• MSSQL
• MySQL
• Oracle
• PostgreSQL

Download

The package is available and can be downloaded using nuget.org package manager.

• Package Name - QueryDB.

.NET Supported Versions

Built on .NET Standard 2.0 - ( Supported Versions )

Features

• Retrieve data from the database.
• Execute scalar queries (returning a single value).
• Execute non-query database commands (e.g. INSERT, UPDATE, DELETE).
• Execute transactions while maintaining atomicity.

Getting Started

• Setup DBContext with the database of your choice

  var dbContext = new DBContext(DB.<Database Type>, <Connection String>);
  

• Execute DBContext commands

  var result = dbContext.FetchData(<Sql Statement>);
  var result = dbContext.FetchData<T>(<Sql Statement>);
  var result = dbContext.ExecuteScalar(<Sql Statement>);
  var result = dbContext.ExecuteScalar<T>(<Sql Statement>);
  var result = dbContext.ExecuteCommand(<Sql Statement>);
  var result = dbContext.ExecuteTransaction(<List of Sql Statements>);