is there some library for connecting to postgresql database and to have support for TransactionScope
TransactionScope
I tried Npgsql but it doesn't yet support transactionscope
You could try the library from Devart:
http://www.devart.com/dotconnect/postgresql/