Entity Framework Core 2 - Code first not creating tables

Question

Entity Framework Core 2.0 has been recently released and i am using it.

I have added the following line in method ConfigurationServices() in file Startup.cs (My connectionstring is fine).

services.AddDbContext<AutoPartsContext>(options => 
options.UseSqlServer(Configuration.GetConnectionString("NetCore")));

and in Configure method,

using (var serviceScope = 
app.ApplicationServices.GetService<IServiceScopeFactory>().CreateScope())
{
var context = 
serviceScope.ServiceProvider.GetRequiredService<MyConntectionStringName>();
context.Database.Migrate();
context.Database.EnsureCreated();
}

This is creating the database but not tables. When i call a simple count on my tables,

var a = _context.Users.Count();

It throws following exception

Invalid object name 'Users'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

However, if i create table manually, everything works perfectly. I need all tables to be auto created.

EF Core version: 2.0, Database Provider: Microsoft.EntityFrameworkCore.SqlServer, Operating system: Windows 10, IDE: Visual Studio 2017 Preview 2

Patrick · Accepted Answer · 2017-08-24 11:06:22Z

7

You need to use migrations for this, as database initializers that used to exist in pre-Core EF are no longer available.

Please refer to Migrations - EF Core with ASP.NET Core MVC tutorial.

edited Aug 24, 2017 at 11:06

Patrick

6,00417 gold badges69 silver badges110 bronze badges

answered Aug 24, 2017 at 11:04

Ricardo Peres

14.8k5 gold badges64 silver badges78 bronze badges

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

2 Comments

Mohsin Over a year ago

Thanks, that helped

flashsplat Over a year ago

sigh Why do they insist on taking away things that made our lives easier. Thanks for this.

Collectives™ on Stack Overflow

Entity Framework Core 2 - Code first not creating tables

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related