Connection to the database in ASP.NET with Entityframework

Question

I need to migrate a system from one server to another. The system is in ASP.NET and the connection to the database is a little strange. I need to know how to connect to the database.

The only thing I found pertaining to Connection in the Web.Config was: http://prntscr.com/brnfqs.

What I do?

Answer 1

Dude, on the Web.Config is gonna have something like this:

  <connectionStrings>
    <add name="ProjetoContext" providerName="System.Data.SqlClient" connectionString="Server=IP/ENDEREÇO_DO_SERVER;Database=NOME_DO_BD;Trusted_Connection=false;Persist Security Info=True;User ID=NOME_USUARIO;Password=SENHA;MultipleActiveResultSets=True" />
    </connectionStrings>

Only modify according to your new server and database settings(IP, database name, user, password).

Answer 2

In the Entity Framework you need to tell the context what the database connection is, this is done by moving to the base class : base("DataContext") your connection name as shown below.

public class ProjetoModeloContext : DbContext
{
    public ProjetoModeloContext()
        : base("DataContext")
    {

    }
    public DbSet<Categories> Categories { get; set; }
}

Configuration of connectionStrings on the web config, just below the </appSettings>

</appSettings>
<connectionStrings>
<add name="DataContext" connectionString="Server=SEU_SERVIDOR; database=NORTHWND;User ID=SEU_USUARIO;Password=SUA_SENHA" providerName="System.Data.SqlClient" />
</connectionStrings>