<h3 id="heading-how-to-scaffold-controllers-with-database-views-to-ef-core-21">How to Scaffold Controllers with database views to EF Core 2.1</h3>
<ol>
<li>Create a view in the database.
</li>
<li>Create a POCO with the same structure as the view.
</li>
<li>Add a new Controller with POCO created in step#2 a. If key related error occurs, add a <code>Key</code> attribute on a column and then remove after scaffolding is completed.
</li>
<li>A new property with <code>DbSet&lt;T&gt;</code> should have gotten added where <code>T</code> is the class created in step#2. Change <code>DbSet</code> to <code>DbQuery</code>.
</li>
<li>In <code>OnModelCreating</code> method of <code>DbContext</code>, add the following code:
</li>
</ol>
<pre><code class="lang-csharp">modelBuilder.Query&lt;POCO from step#2&gt;().ToView("Name of the view");
</code></pre>

### 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:
 

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