Publish application Windows Form C #

The ideal thing is that you already publish the version with the Production Connection, or, give an alternative for the user to change.

But if you want to change the Connction String after the publication, this must be done after installing the program ... From what I saw you are using ClickOnce to publish .. Then you should look for the following folder after the installation. .. c: \ user \ $ UserName $ \ AppData \ Local \ Apps \ 2.0 \ $ Estername $ \ $ OtherExternalName $ \ and fetch the application folder. Finding the folder will see the .config file with your connection ..

I hope I have helped;

Abs. Augusto Cordeiro

There are several ways to do it. The simplest way is to map the connectionString tags to a class and index them from Windows Forms to create the connection string.

You can make a mask using String.Format and encapsulate the assembly of the new string. (It's up to you how you go about setting it up)

Note: Make sure the context is pointing to string with the name of the connection in .config in this case RHContext, because it is through it that the context works.

ConfigurationManager.ConnectionStrings["RHContext"].ConnectionString

Enter this string in your DbContext and it will respond even if it is changed.

To edit the app.config you can use the Configuration class, here is a very trivial example:

public class AppConfigManager {

    //Objeto para manipular o App.config
    private static Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);

    #region Singleton

    private static AppConfigManager instance;

    public static AppConfigManager Configuration
    {
        get
        {
            if (instance == null)
                instance = new AppConfigManager();
            return instance;
        }
    }

    private AppConfigManager()
    {
        this.ConnectionString = GetConnectionString("RHContext");
    }
    #endregion

    /// <summary>
    /// Retorna a string do App.config.
    /// </summary>
    public string ConnectionString { get; private set; }


    /// <summary>
    /// O path do arquivo de configuração de conexão
    /// </summary>
    public string ConnectionConfigPath
    {
        get
        {
            return Application.ExecutablePath + ".config";
        }
    }


    /// <summary>
    /// A string de conexão
    /// </summary>
    /// <param name="key"></param>
    /// <returns></returns>
    public string GetConnectionString(string key)
    {
        try
        {
            return ConfigurationManager.ConnectionStrings[key].ConnectionString;
        }
        catch (Exception)
        {

            throw new Exception("Não foi possivel obter a conexão do nome" + key);
        }

    }      

    /// <summary>
    /// Altera a string de conexão do nome informado.
    /// </summary>
    /// <param name="connectionString">String a ser utilizada</param>
    public void ChangeConnectionString(string connectionString, string name)
    {
        //setando a string a ser alterada
        var cfg = config.ConnectionStrings.ConnectionStrings[name];

        //altera a string de conexão
        cfg.ConnectionString = connectionString;

        // Salva o que foi modificado
        config.Save(ConfigurationSaveMode.Modified);

        // Atualiza no app o bloco connectionStrings
        ConfigurationManager.RefreshSection("connectionStrings");

        // Recarrega os dados de conexão
        Properties.Settings.Default.Reload();
    }

     /// <summary>
    /// Add uma string de conexão.
    /// MeuAppConfig é a classe onde será mapeados os atributos da connectionString
    /// </summary>
    public static void AddConnectionString(MeuAppConfig app)
    {
        try
        {
            if (string.IsNullOrWhiteSpace(app.User))
                app.User = "";
            if (string.IsNullOrWhiteSpace(app.Password))
                app.Password = "";

            SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder
            {
                DataSource = app.ServerName,
                InitialCatalog = app.Database,
                UserID = app.User,
                Password = app.Password,
                IntegratedSecurity = "False"
            };

            // add a conexão
            config.ConnectionStrings.ConnectionStrings.Add(
                new ConnectionStringSettings
                {
                    Name = app.ConnectionName,
                    ConnectionString = scsb.ConnectionString,
                    ProviderName = "System.Data.SqlClient"
                });

            // salva conexão
            config.Save(ConfigurationSaveMode.Modified);
        }
        catch (Exception ex)
        {
            //Entrada já existe ou outro ...
        }
    }

    #endregion

}

You can also read and edit .config directly through Windows Forms. Just map the connection tag of the connectionString.