How to Scaffold Controllers with database views to EF Core 2.1

How to Scaffold Controllers with database views to EF Core 2.1

How to Scaffold Controllers with database views to EF Core 2.1

Create a view in the database.
Create a POCO with the same structure as the view.
Add a new Controller with POCO created in step#2 a. If key related error occurs, add a Key attribute on a column and then remove after scaffolding is completed.
A new property with DbSet<T> should have gotten added where T is the class created in step#2. Change DbSet to DbQuery.
In OnModelCreating method of DbContext, add the following code:

modelBuilder.Query<POCO from step#2>().ToView("Name of the view");