Activities of "rogerscorporation"

Hi @m.aliozkaya,

I added dbContext refer to this article: https://jasonwatmore.com/post/2019/12/27/aspnet-core-automatic-ef-core-migrations-to-sql-database-on-startup

However, still got error when starting application:

Here are the codes:

public IServiceProvider ConfigureServices(IServiceCollection services)
{
    // DbContext
    services.AddDbContext<TaxonomyDbContext>(options =>
    options.UseSqlServer(
        _appConfiguration.GetConnectionString("Default")));
}


public void Configure(IApplicationBuilder app, IWebHostEnvironment env, ILoggerFactory loggerFactory, TaxonomyDbContext dbContext)
{
    // migrate any database changes on startup (includes initial db creation)
    dbContext.Database.Migrate();
}

Hi @rogerscorporation,

Could you check this class?

https://github.com/aspnetzero/aspnet-zero-core/blob/dev/aspnet-core/src/MyCompanyName.AbpZeroTemplate.EntityFrameworkCore/EntityFrameworkCore/DatabaseCheckHelper.cs

Hi @m.aliozkaya,

Could you please provide an example for this class? I still have no idea for configuring automatic update-database when application running in V14.0.0. It would be better if you have an example with some codes.

Thank you.

Hello,

We have been able to automatic update-database when application running in .NET 5 MVC & jQuery solution. However we have no idea for .NET 9.0 solution in v14.0.0.

Here are codes for reference:

For .NET 5 MVC In Web\Global.asax.cs

// Configure automatic update-database when application running
Database.SetInitializer(new MigrateDatabaseToLatestVersion<MasterDataToolDbContext, Migrations.Configuration>());
MasterDataToolDbContext dbContext = new MasterDataToolDbContext();
dbContext.Database.Initialize(true); // force the initialization

For .NET Core 6 You can call context.Database.Migrate()in your Startup.cs

eg:

using (var context = new MyContext(...))
{
    context.Database.Migrate();
}

e.g.:

public void Configure(IApplicationBuilder app, IWebHostEnvironment env, ILoggerFactory loggerFactory, TaxonomyDbContext dbContext)
{
    // migrate any database changes on startup (includes initial db creation)
    dbContext.Database.Migrate();
}

We got error when running the application, it seems codes cannot work in .NET 9 solution. ERROR: 'Could not resolve a service of type '.EntityFrameworkCore.TaxonomyDbContext' for the parameter 'dbContext' of method 'Configure' on type 'Rogers.Taxonomy.Web.Startup.Startup'.'

Could you please help troubleshoot this and give us some advice?

Thank you.