LiteX.DbHelper.PostgreSql 4.0.0

.NET 5.0 .NET Core 3.1 .NET Standard 2.0
dotnet add package LiteX.DbHelper.PostgreSql --version 4.0.0
NuGet\Install-Package LiteX.DbHelper.PostgreSql -Version 4.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="LiteX.DbHelper.PostgreSql" Version="4.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add LiteX.DbHelper.PostgreSql --version 4.0.0
#r "nuget: LiteX.DbHelper.PostgreSql, 4.0.0"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install LiteX.DbHelper.PostgreSql as a Cake Addin
#addin nuget:?package=LiteX.DbHelper.PostgreSql&version=4.0.0

// Install LiteX.DbHelper.PostgreSql as a Cake Tool
#tool nuget:?package=LiteX.DbHelper.PostgreSql&version=4.0.0


Basic features
  • ExecuteNonQuery
  • ExecuteScalar
  • GetDataTable
  • GetDataSet
  • ExecuteReder
  • CreateParameters (for each providers)
Advanced features
  • ExecuteScalar<>
  • GetSingle<T>
  • GetList<T>
  • GetArray<T>
  • GetDictionary<TKey, TValue>

Instantiate the DBHelper:

// just use the connection string name
IDBHelper dbHelper = new NpgsqlHelper("MyCN");
// use different provider class based on your database.

Basic ADO.NET methods:

// Create parameters
var paramResultOut = DbHelper.CreateOutParameter("@Result", SqlDbType.NVarChar, 100);
var paramIsActive = DbHelper.CreateParameter("@IsActive", isActive);
var paramId = DbHelper.CreateParameter("@Id", id);

// ExecuteNonQuery
// Stored procedure
var count = _dbHelper.ExecuteNonQuery("DeleteCountry", paramIsActive, paramResultOut);
// OR
// Raw sql commnad
var count = _dbHelper.ExecuteNonQuery("DELETE FROM [dbo].[Country] WHERE Id = @Id", CommandType.Text, paramIsActive);

// ExecuteScalar - returning a object type scalar value 
var name = _dbHelper.ExecuteScalar("SELECT Name FROM COUNTRY");

// DataReader
// Stored procedure
var dataReader = _dbHelper.ExecuteReder("GetCountries", paramIsActive, paramResultOut);
// OR
// Raw sql commnad
var dataReader = _dbHelper.ExecuteReder("SELECT * FROM Country WHERE IsActive = @IsActive", CommandType.Text, paramIsActive);

// DataTable
// Stored procedure
var dataTable = _dbHelper.GetDataTable("GetCountries", paramIsActive, paramResultOut);
// OR
// Raw sql commnad
var dataTable = _dbHelper.GetDataTable("SELECT * FROM Country WHERE IsActive = @IsActive", CommandType.Text, paramIsActive);

// DataSet
// Stored procedure
var dataSet = _dbHelper.GetDataSet("GetCountriesAndStates", paramIsActive, paramResultOut);
Product Versions
.NET net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows
.NET Core netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1
.NET Standard netstandard2.0 netstandard2.1
.NET Framework net461 net462 net463 net47 net471 net472 net48
MonoAndroid monoandroid
MonoMac monomac
MonoTouch monotouch
Tizen tizen40 tizen60
Xamarin.iOS xamarinios
Xamarin.Mac xamarinmac
Xamarin.TVOS xamarintvos
Xamarin.WatchOS xamarinwatchos
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

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
4.0.0 393 1/1/2021
3.0.0 533 4/7/2020
2.0.0 1,197 9/19/2019
1.0.0 629 6/25/2019

Upgrade to .NET 5.x.
     Added multi-framework target support - .NET 5, .NET Core 3.1, .NET Standard 2.1 and .NET Standard 2.0
     Update libraries and SDKs to latest version.

     Last releases notes:
     -> Advanced features (Strongly type result) - ExecuteScalar, GetSingle, GetList, GetArray, GetDictionary
     -> DBConvert methods, DataReader, DataTable and DataTable extensions
     -> 1.0.0 - Basic featured - ExecuteNonQuery, ExecuteScalar, GetDataTable, GetDataSet, ExecuteReder, CreateParameter
     -> Coming soon - Async methods support
     -> Comimg soon - OUT parameter support in stored procedure
     -> Coming soon - Ping (useful in health check and load balancing)
     -> Coming soon - Pagination at DB server side
     -> Coming soon - Batch execution