Unable to create SQL Table using code first approach in Azure via Entity Framework

Question

I am trying to publish my database into azure using EF but am not able to see any tables after migration.

I tried below commands:

Add-Migration MyTables
Update-Database

When I check my Azure DB trough SSMS, I can see logs for all the migration in dbo.__EFMigrationsHistory table, but no table is getting created.

My Context Class:

 public class ApplicationContext : DbContext
{
    public DbSet<Expense> Expenses { get; set; }

    public ApplicationContext(DbContextOptions opts) : base(opts)
    {

    }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
    }
}

ConnectionString:

"ConnectionString": { "ExpenseApplicationDB": "Server=tcp:myserver,1432;Initial Catalog=ExpenseDatabase;Persist Security Info=False;User ID={your_username};Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;" }

Also in publish dialog in database section it showing 'No databases found in the project'.

If I try to achieve same thing using local DB than it's working as expected. Is there anything that am doing wrong?

Joey Cai · Accepted Answer · 2018-05-25 01:37:41Z

0

When you publish with .net EntityFramework, you could click the tab Execute Code First Migration(runs on application start).

However, in EF core, it does not exist it. Additionally, EF does not support Automatic migrations, you may need to manually execute Add-Migration for adding migration files.

Also in publish dialog in database section it showing 'No databases found in the project'.

You also could not exist the database, you could not apply migration on publish.

If you want to apply migration at runtime, you could add the following code int the Configure method of Startup.cs.

 using (var scope = app.ApplicationServices.GetService<IServiceScopeFactory>().CreateScope())
    {
        scope.ServiceProvider.GetRequiredService<ApplicationDbContext>().Database.Migrate();
    }

For more details, you could refer to this thread.

Note, you need to ensure that you could connect to azure database. You could set the connection in azure to the vs local. So that you could also test with azure database in local and debug it.

edited May 25, 2018 at 1:37

answered May 21, 2018 at 9:56

Joey Cai

20.2k1 gold badge25 silver badges34 bronze badges

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

9 Comments

Dishant Over a year ago

"You also could not exist the database, you could not apply migration on publish" - Can you please explain this with some more details, My project type if 'Web API' instead of 'Web Application'.

Joey Cai Over a year ago

According to your description, I only could guess it was an asp.net core application.And I get the same problem with you before like no database shows. So I add the code to achieve automatically migration.

Joey Cai Over a year ago

You also could add the code into Startup.cs to try.

Dishant Over a year ago

Tried myDbContext.Database.Migrate(); this in startup.cs, but still migration didn't work.

Joey Cai Over a year ago

Actually, you need to add the second code fragment I provided in Configure method in Startup.cs

|

Collectives™ on Stack Overflow

Unable to create SQL Table using code first approach in Azure via Entity Framework

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related