npgsql/npgsql

@FerrariF70 check out the docs on connection string parameters: https://www.npgsql.org/doc/connection-string-parameters.html
this my connection string, but I get message in log that a valid client certificate is required to connect but I connected with this certificate in past.

@"Server=127.0.0.1; port=5432; database=constructioncore; Username=postgres; 
 TrustServerCertificate=false; PGSSLCERT=d:\certificates\server.crt; SslMode=Require;
PGSSLKEY=d:\certificates\server.key; PGSSLROOTCERT=d:\certificates\root.crt;";

I received this message a valid client certificate is required to connect, when I provided certificate like this form

 services.AddDbContext<CorpDbContext>(options => options.UseNpgsql(connectionString, builder =>
             {
builder.RemoteCertificateValidationCallback((s, c, ch, sslPolicyErrors) =>
               {
                   if (sslPolicyErrors == SslPolicyErrors.None)
                   {
                       return true;
                   }
                   return true;
               });
 builder.ProvideClientCertificatesCallback(clientCerts =>
                 {
                     var clientcertPath = @"d:\certificates\server.crt";
                     var cert = new X509Certificate2(clientcertPath);
                     clientCerts.Add(cert);
                 });
}

But when I changed to this code I was able connect to database

 services.AddDbContext<CorpDbContext>(options => options.UseNpgsql(connectionString, builder =>
             {
 builder.RemoteCertificateValidationCallback((s, c, ch, sslPolicyErrors) =>
               {
                   if (sslPolicyErrors == SslPolicyErrors.None)
                   {
                       return true;
                   }
                   return true;
               });
                 builder.ProvideClientCertificatesCallback(clientCerts =>
                 {
                     var clientcertPath = @"d:\certificates\server.pfx";
                     var cert = new X509Certificate2(clientcertPath,"qwerty");
                     clientCerts.Add(cert);
                 });
}