Oracle materialized view with Entity Framework model

Question

Is it possible to query Oracle materialized view with Entity Framework model using linq?

Answer 1

Yes. From the Entity Framework's perspective, a materialized view is a table. The only caveat is that to generate the model from the materialized view, the materialized view must have a non-nullable column that could be used as the primary key.