C# - Entity Framework Core - Automated database generation

Question

When I run my desktop application for the first time, I want the database and table structure to be created automatically.

I can't find any examples or documentation on the equivalent method in EFCore.

I did everything as described in this document: https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core-example.html

But I still have the problem: Exception: 'Microsoft.Data.SqlClient.SqlException' thrown in Microsoft.Data.SqlClient.dll and the database is empty :( If you can help me please let me know.

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {

            try
            {
                optionsBuilder.UseMySQL("server=localhost;userid=root;password=topSecret;database=kartoteka-pracownicza");
            }
            catch (MySqlException ex)
            {
                switch(ex.Number)
                {
                    case 0:
                        MessageBox.Show("Unable to connect to the server, please contact the administrator");
                        break;

                    case 1045:
                        MessageBox.Show("Invalid username/password, please try again");
                        break;
                }
            };
        }

Answer 1

Hello, if you use migrations, you can add something similar to the following in your Startup.cs:

public void Configure(IApplicationBuilder app)
    {
         using (var serviceScope = 
         app.ApplicationServices.GetService<IServiceScopeFactory>().CreateScope())
         {
               var context = serviceScope.ServiceProvider.GetRequiredService<ApplicationDbContext>();
               context.Database.Migrate();
         }
    }

If you are not using migrations, you can replace Migrate(); with EnsureCreated(); to use your database context.