Search code examples
viewmodelframeworksentitymaterialized

Oracle materialized view with Entity Framework model

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

Solution

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