Skip to Main Content

Oracle Developer Tools for Visual Studio

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Error When adding ADONET.Entity Data Model from Oracle DB

user-9xp0kNov 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
0 comments
93 views