ASP.NET Core Entity Framework- InvalidOperationException in dbModel context

Question

I got the error when initialize the dbModel context as follows:

This is my dbContext class:

public class DbModel : DbContext
{
    public DbModel()
    {
    }

    public DbModel(DbContextOptions<DbModel> options)
        : base(options)
    { }

    public DbSet<UserModel> User {get;set;}
}

I added the following code in the ConfigureServices method in Startup.cs according to some answers in stackoverflow, but I'm still getting an error.

services.AddSingleton<IHttpContextAccessor, HttpContextAccessor>();
services.AddSingleton<IActionContextAccessor, ActionContextAccessor>();

This is my ConfigureServices method:

public void ConfigureServices(IServiceCollection services)
{
        services.AddMvc();
        var connection = @"Server=(localdb)\mssqllocaldb;Database=EFGetStarted.AspNetCore.Restaurant;Trusted_Connection=True;ConnectRetryCount=0";
        services.AddDbContext<DbModel>(options => options.UseSqlServer(connection));
        services.AddSwaggerGen(c =>
        {
            c.SwaggerDoc("v1", new Info { Title = "Restaurant APIs", Description = "Swagger Core API" });
        });
        services.AddSingleton<IHttpContextAccessor, HttpContextAccessor>();
        services.AddSingleton<IActionContextAccessor, ActionContextAccessor>();
    }

What could be the reason?

Brad · Accepted Answer · 2018-04-10 01:47:51Z

1

You're manually initializing DbModel instead of using DI to inject it into your controller.

public ValuesController : Controller
{
    private readonly DbModel _db;

    public ValuesController(DbModel db)
    {
        _db = db;
    }
}

answered Apr 10, 2018 at 1:47

Brad

4,5632 gold badges19 silver badges24 bronze badges

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

Comments

Zhiqiang Li · Accepted Answer · 2018-04-10 06:04:21Z

0

The above answer is correct.DbContext initialization needs to inject dependencies from the container.So you can't directly use new.

answered Apr 10, 2018 at 6:04

Zhiqiang Li

213 bronze badges

Collectives™ on Stack Overflow

ASP.NET Core Entity Framework- InvalidOperationException in dbModel context

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related