Dbcontext finds Connection String in Web Project, but not in Console App project

Question

I have a project Class Library which contains the context, configuration files and access classes to the database. His reference in an Asp.Net MVC project works normally, he accesses the data and so on, but in a project of the type Console Applicationthe context does not "load" the Connection Stringwho is in App.config, which is the same as Web.config.

Context class:

 public class SiteContext : DbContext
 {
     public SiteContext () : base("SiteBanco")
     {
         Configuration.LazyLoadingEnabled = false;
         Configuration.AutoDetectChangesEnabled = false;
     }
  }

Web.config and App.config

<connectionStrings> <add name="SiteBanco" connectionString="Data Source=SERVER-TEST\SQLSERVER;Initial Catalog=BaseTeste;Integrated Security=False;User ID=***;Password=*****;Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False" providerName="System.Data.SqlClient" /> </connectionStrings>

Answer 1

Force him to search for a particular name in your ConnectionStrings thus: name=SiteBanco, this will serve so much to app.config and web.config:

Final code:

public class SiteContext : DbContext
{
     public SiteContext () : base("name=SiteBanco")
     {
         Configuration.LazyLoadingEnabled = false;
         Configuration.AutoDetectChangesEnabled = false;
     }
}

References:

• Entity Framework Connections and Models
• Database/Model First with Connection string in app.config/web.config file

Answer 2

Try that one:

    public SiteContext ()
        : base("SiteBanco", throwIfV1Schema: false)
    {
     Configuration.LazyLoadingEnabled = false;
     Configuration.AutoDetectChangesEnabled = false;
    }