ASP.Net Core 2 - Using a DBContext having defaultConnectionString from appsettings

Question

I want to create a basic CRUD in ASP.Net Core 2 with EntityFrameworkCore.

My appsettings.json file is like this-

"DefaultConnection": "server=localhost; port=3306; database=inventory_management; user=root; password=;"

I want to read connection from this file. What I have done is - In Startup.cs - Startup

        //Configuration = configuration;
        var builder = new ConfigurationBuilder()
            .SetBasePath(env.ContentRootPath)
            .AddJsonFile("appsettings.json", optional: false, reloadOnChange: true)
            .AddJsonFile($"appsettings.{env.EnvironmentName}.json", optional: true)
            .AddEnvironmentVariables();
        Configuration = builder.Build();

and then in ConfigureServices-

services.AddDbContext<InventoryManagementDbContext>(options => options.UseMySQL(Configuration.GetConnectionString("DevelopConnection")));

Then in controller, I am trying this-

So, I am getting this error-

What do I need to do to solve this error?

Can anyone please help?

SpruceMoose · Accepted Answer · 2018-01-16 09:25:59Z

1

You need to allow your DbContext to be injected into your controller as follows:

public class YourController
{
    InventoryManagementDbContext _context;

    // Dependency Injection
    public YourController(InventoryManagementDbContext context)
    {
        _context = context;
    }

    public Action Index()
    {
        _context.Employee.Add(...);
        await _context.SaveChangesAsync();
        return View();
    }
}

answered Jan 16, 2018 at 9:25

SpruceMoose

10.4k4 gold badges43 silver badges57 bronze badges

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

3 Comments

IT Eng - BU Over a year ago

how can I call ensureCreated in there? Can you please help?

SpruceMoose Over a year ago

This post might be useful: stackoverflow.com/questions/36958318/…

IT Eng - BU Over a year ago

Thank you very much

Collectives™ on Stack Overflow

ASP.Net Core 2 - Using a DBContext having defaultConnectionString from appsettings

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related