How to Scaffold Controllers with database views to EF Core 2.1

How to Scaffold Controllers with database views to EF Core 2.1

1. Create a view in the database.

2. Create a POCO with the same structure as the view.

3. 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.

4. A new property with DbSet<T> should have gotten added where T is the class created in step#2. Change DbSet to DbQuery.

5. In OnModelCreating method of DbContext, add the following code:

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