Add API Controller with Actions using Entity Framework

This blog article shows you how to add Api Controller with Actions using Entity Framework. You have seen how to create .NET Core Web Api. Create the following table in SQL Server Database. My database is named B2CDatabase,

Right the Controllers, choose Add, choose Controller…

Also: Generate a Model for an Existing Database in Entity Framework Core

Select API. Choose API Controller with actions, using Entity Framework.

Select the Model class, in my case is Incident. Select Dbcontect class, for example, B2CdatabaseContext.

The IncidentsController is created but you need to comment out the constructor. Then change the following declaration from

private readonly B2cdatabaseContext _context;

to

private readonly B2cdatabaseContext _context = new B2cdatabaseContext();

Click Run, Click Try it out. Click Execute. You will see the result return from the web Api.

Video: https://youtu.be/vNKHMD1MwJI/?WT.mc_id=DP-MVP-36769

Source code download: https://github.com/chanmmn/WebApi/tree/master/WebApiCore/?WT.mc_id=DP-MVP-36769

Reference: https://learn.microsoft.com/en-us/aspnet/core/tutorials/first-web-api?view=aspnetcore-7.0&tabs=visual-studio/?WT.mc_id=DP-MVP-36769

https://learn.microsoft.com/en-us/aspnet/core/tutorials/first-web-api?view=aspnetcore-7.0&tabs=visual-studio/?WT.mc_id=DP-MVP-36769

https://learn.microsoft.com/en-us/aspnet/web-api/overview/data/using-web-api-with-entity-framework/part-2/?WT.mc_id=DP-MVP-36769