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;