Postgressql connection with Visual Studio

Question

Good evening, I need to connect the database with the visual studio c#, but I don’t understand exactly how to accomplish and the materials I find are a bit confusing, if anyone can help I would be grateful, I’m developing a project for a nutrition-related system and I’m already on a deadline due to this fact and everything. Thank you in advance!

Answer 1

you can create a Class for this:

Only before that we’ll add one ConnectionStrings at the App.config of your project. Once located and opened the App.config before the closing tag <\configuration>, add:

<connectionStrings>
      <add name="CaminhoSqlSever" 
           providerName="System.Data.SqlClient"
           connectionString="Server=Nome do seu Server;
                             Database=Nome do seu Banco;
                             User Id=seu usuário;
                             Password=Seu password;"/>
</connectionStrings>

Done this add the necessary references to the project:

using System.Configuration; //-> Com ele podemos acessar a ConnectionString criada no `App.config`
using System.Data.SqlClient; 

There are several ways to create this class, below follows a simple example.

class ConexaoDB
{
    //-->Variavel que armazena a conexão.
    SqlConnection Con;

    //Propriedade que encapsula e retorna a conexão.
    public SqlConnection Conexao => Con;

    //Propriedade que retorna a string da conexão armazenada no arquivo de configurações.
    public string StrConexao => ConfigurationManager.ConnectionStrings["CaminhoSqlSever"].ConnectionString;

    public ConexaoDB()
    {
        try
        {
            Con = new SqlConnection(StrConexao);
        }
        catch (SqlException erro)
        {
            MessageBox.Show($"Ocorreu um erro: {erro.message}");
        }
    }
}