I am having trouble figuring out how do I connect to a JDBC AWS database via C#. I installed the library Npgsql but does not seem to work if I put the JDBC URL I have as the Host. I know JDBC is Java so not sure how to do this with C#. In DBeaver I have setup PostgreSQL driver then I have selected Connect By URL. The URL has the address “jdbc:postgresql://ma-aurora-postgres.cluster-dssss.us-east-1.rds.amazonaws.com:5432/mydb” Authentication I have Database Native selected and use a service account username and password.

Tried separating it all so my connection string is:
string conn = @Host=jdbc:postgresql://ma-aurora-postgres.cluster-dssss.us-east-1.rds.amazonaws.com;Port=5432;Username=scv_acct_user;Password:password;Database=mydb” but that does not work it shows no known host.

Struggling on how to do this within my C# app to connect. Thanks for any help