Is there any .NET library which can be used to listen to the notifications coming from PostgreSQL?
Npgsql has removed this support.
Npgsql definitely hasn't removed support for LISTEN/NOTIFY (although the API has changed somewhat over recent versions): http://www.npgsql.org/doc/wait.html