CODEWITHSUNDEEP
c#asp.netasp.net-mvcoracle-databaseentity-framework
Mohan
Mohan

Reputation: 248

Trying to use Entity Framework with Oracle DB

Hi I am trying to use Entity-Framework in asp.net MVC , for that I have installed Oracle.Managed.DataAccess version 19.6.0 and Oracle.Managed.DataAccess.EntityFramework version 19.6.0 and oracle version 11.2.0 I am able to connect Oracle DB in server explorer but while adding new item in solution not getting any option to connect Oracle DB what is the issue I am not able to identify ,Any idea would be appreciated. Imageenter image description here

Upvotes: 1

Views: 688

Answers (2)

BlackSD
BlackSD

Reputation: 346

You need to install a Oracle Client and TNSNAMES.ORA

Oracle Client 11.2 Example

The installation has a component list, if you insall that components (like Oracle developer Tools for visualStudio) it you can add your EF. and then when you finish you only need to add your TNSNAMES in order to create the Entities in VS.

Upvotes: 0

WolvenOne27
WolvenOne27

Reputation: 31

Those are just the Nuget packages to allow your project to connect to Oracle.

I believe you need to add Oracle Developer Tools for Visual Studio to have the options available in the Visual Studio dialogs.

https://www.oracle.com/database/technologies/developer-tools/visual-studio/

Upvotes: 1

Related Questions