Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Scaffolding views with EF Core 3.x

Ivan SamuelsonJun 3 2020 — edited Jun 5 2020

First off, thank you for releasing the beta of the Oracle EF Core provider for 3.1.

What I would like to know is, does the oracle EF Core 3.x scaffold views, that is, create them in the OnModelCreating method in the DbContext object as keyless entities? When I scaffold my existing schema, I only get the tables and I do not see the views that exist in the schema being registered. These views select from tables in a different schema within the same database, and the schema that owns the views has select access to the tables in the other schema.

I know that Microsoft specifies in the EF Core 3.0 New Features section of their documentation that reverse engineering of database views is allowed and EF Core will automatically create keyless entity types for them. But they show it for SQL Server. Is this feature not available with the Oracle EF 3.x provider?

Thanks!

Comments
Post Details
Added on Jun 3 2020
4 comments
1,381 views