Skip to Main Content

Oracle Developer Tools for Visual Studio

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Error When adding ADONET.Entity Data Model from Oracle DB

ERHAN URUNNov 14 2023

I'am trying to create EF context from Oracle database in .Net framework 4. I installed Oracle Developer Tools for vs extension, I also installed Oracle.ManagedDataAccess,Oracle.ManagedDataAccess.EntityFramework and EntityFramework Nuget packages.

 <package id="EntityFramework" version="6.4.4" targetFramework="net462" />
 <package id="Oracle.ManagedDataAccess" version="21.9.0" targetFramework="net462" />
 <package id="Oracle.ManagedDataAccess.EntityFramework" version="21.9.0" 
  targetFramework="net462"/>

My scanerio like below

Right click project then add new item and choose ADO.NET Entity Data Model

Choose EF Designer From Database Click new Connection (Data Source=Oracle Database and Data Provider=ODP.NET managed driver).

In connection type advance mode I am entering data source, username and password. Test connection is success every thing ok

But when I pressing OK button I'am getting this error. I cant understand why ODT extension using GAC. The extension already includes Oracle.ManagedDataAccess dll. I cant update the GAC because I haven't admin role. Also I don't want to use GAC in design time and run time

Comments

Post Details

Added on Nov 14 2023
4 comments
337 views