Npgsql.ADO.Net.DataEntity is the common library to do the CRUD operations, by using the library you can perform the INSERT, UPDATE, DELETE, SELECT, etc. You can get the data tables from just a 1 line code.
$ dotnet add package ADO.Net.Npgsql.DataEntityNo README available.