How to set a password?

Question

C++ / C#

Can you please tell me how to set the password for the database in EF? Only not in the config, but from the c# code! In a sense, it will be entered in my textbox and transferred to EF.

Answer 1

There was such a problem at one time. I even left it for myself.

var originalConnectionString = ConfigurationManager.ConnectionStrings["коннекшенстрингнейм"].ConnectionString;
var entityBuilder = new EntityConnectionStringBuilder(originalConnectionString);
var factory = DbProviderFactories.GetFactory(entityBuilder.Provider);
var providerBuilder = factory.CreateConnectionStringBuilder();

providerBuilder.ConnectionString = entityBuilder.ProviderConnectionString;

providerBuilder.Add("Password", "Password123");

entityBuilder.ProviderConnectionString = providerBuilder.ToString();

using (var context = new YourContext(entityBuilder.ToString()))
{
    // TODO
}

Sorry if it doesn't work. I don’t know for sure whether I pulled it out of the working code. But I think the direction for Google gave)

Answer 2

Pass the connection string with the required settings to the constructor of your DbContext.