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!

Reverse engineering in .Net Core 2

21a0bb4a-4519-4130-83c7-0eb3625fa172Mar 27 2019 — edited Mar 28 2019

Hello,

I am trying to do a reverse engineering from a Oracle Database, using the "Entity Framework Core Tool --> Scaffold-DbContext".

I installed the nuget package "Oracle.ManagedDataAccess.Core", and run this in the Package Manager Console:

Scaffold-DbContext "Data Source=TORCL;User Id=hr;Password=hr;" Oracle.ManagedDataAccess -OutputDir DB_Oracle

but I got this error message:

Unable to find expected assembly attribute named DesignTimeProviderServicesAttribute in provider assembly Oracle.ManagedDataAccess. This attribute is required to identify the class which acts

as the design-time service provider factory.

Finally, I realized (in part reading other discussions here) that the "Oracle.ManagedDataAccess.Core" driver is only for ADO.NET, so I need a specific Entify Framework driver to do the mentioned reverse engineering with "Scaffold-DbContext", and that there are only a Beta version.

Is it correct?

Thank you in advance¡

This post has been answered by Alex Keh-Oracle on Mar 27 2019
Jump to Answer

Comments

Alex Keh-Oracle
Answer

You need to use Oracle EF Core assembly to support scaffolding. This sample has instructions for how to conduct reverse engineering.

https://github.com/oracle/dotnet-db-samples/tree/master/samples/dotnet-core/ef-core

Marked as Answer by 21a0bb4a-4519-4130-83c7-0eb3625fa172 · Sep 27 2020

Thank you very much¡

1 - 2

Post Details

Added on Mar 27 2019
2 comments
2,637 views