Data Provider
Npgsql - .NET Access to PostgreSQL About Npgsql is an open source ADO.NET Data Provider for PostgreSQL, it allows programs written in C#, Visual Basic, F# to access the PostgreSQL database server. It is implemented in 100% C# code, is free and is open source. In addition, providers have been written for Entity Framework Core and for Entity Framework 6.x. TransactionScope https://www.codeproject.com/Articles/690136/All-About-TransactionScope https://codewala.net/2018/02/06/transactionscope-a-simple-way-to-handle-transactions-in-net/ public Transaction() { } /// No Transaction for Database. public const int None = 1; /// Transaction for Connections Separately. public const int Yes = 2; /// One Transaction for All Connections without connection Transaction. public const int TS = 3; /// One Transaction for All Connections with connection Transaction. public const int TSNT = 4;