How to create Indexed Views with entity framework code-first approach

Question

I have a 3 tables which need to be joined for doing some queries. The tables are relatively read-only for specific duration of time. Only if there is need, we need to write them.

I want to avoid join on demand for these tables. So I was planning to use Indexed views. However, I didn't find a way to define a view from entity framework (EF 6.1).

Can someone please guide on this?

Regards, Amit Rangari

Shiraz Bhaiji · Accepted Answer · 2015-06-23 18:46:45Z

4

There is no direct method for creating views from EF 6.

You need to write raw SQL to create the view, then execute it from a dbMigration. For details see: https://msdn.microsoft.com/en-us/magazine/dn519921.aspx

answered Jun 23, 2015 at 18:46

Shiraz Bhaiji

65.7k37 gold badges149 silver badges260 bronze badges

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

Comments

bubi · Accepted Answer · 2015-06-24 08:22:15Z

0

You need to create the view via standard SQL statement (migration or the connection of the context). The view should have a key. After that you can map the view with EF like it was a table.

answered Jun 24, 2015 at 8:22

bubi

6,5013 gold badges32 silver badges50 bronze badges

Collectives™ on Stack Overflow

How to create Indexed Views with entity framework code-first approach

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related