EF multiple constructor with connection string using unity container : "The underlying provider failed on Open"

Question

I'm using ef 6 and unity container. when i don't initialize default dbcontext constructor then unity can't recognize controller injection.but when initialize default dbcontext constructor and i use

Database.SetInitializer<EfDbContext>(null);

that time it throw "The underlying provider failed on Open" and Cannot attach the file Migrations.EfDbContext.mdf Db Migrations error

public EfDbContext() : base()
{
    Database.SetInitializer<EfDbContext>(null);
}

public EfDbContext(string connectionString) : base(connectionString)
{
   Database.SetInitializer<EfDbContext>(null);
}

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
   modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
}

Call from Service

public JsonResult Something()
{
    using (var db = new EfDbContext("con1"))
    {
        db.Database.Connection.Open();
        var data = db.Database.SqlQuery<Something>("SELECT * FROM [dbo].[Table]").ToList();
        db.Database.Connection.Close();
    }
    ..............
}

And UnityConfig

public static void RegisterComponents()
{
    var container = new UnityContainer();

    container.RegisterType(typeof(IService<>), typeof(Service<>));
    ConventionRegistrar.Configure(container);

    GlobalConfiguration.Configuration.DependencyResolver = new UnityDependencyResolver(container);
}

Ashiquzzaman · Accepted Answer · 2020-03-23 05:45:14Z

1

Please Try..

public EfDbContext() : this("Pass Your Default Connection String")
{

}

public EfDbContext(string connectionString) : base(connectionString)
{

}
//DBSet's

protected override void OnModelCreating(DbModelBuilder modelBuilder)  
{

 base.OnModelCreating(modelBuilder);

 Database.SetInitializer<ApplicationDbContext>(null);

 modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();

 //... Fuluent api
}

Hopefully it will be worked.

edited Mar 23, 2020 at 5:45

answered Mar 8, 2020 at 6:51

Ashiquzzaman

5,3144 gold badges30 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

EF multiple constructor with connection string using unity container : "The underlying provider failed on Open"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related