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; } }; }