January 23, 2020

Add Oracle provider in VS2017 for Entity Framework.

I tried using Entity Framework model being generated from Oracle database, I faced issues in connecting to the database and generating model from existing objects.

Here is how you can connect to Oracle 12c database for Entity Framework model in Visual Studio 2017.

  • First you have to install Oracle Developer Tools for Visual Studio 2017. On this link you will find multiple packages for oracle providers. For Visual Studio 2017 you need to install ODAC for VS 2017 12.2.0.1.1. If you have already installed some other version, make sure uninstall that version first before installing this.

  • Second you need to install Nuget Package

     Oracle.ManagedDataAccess.EntityFramework 12.2.1100
      

Now you should be able to connect from Entity Framework model to Oracle 12c database and the solution should build successfully.

2 comments:

  1. If you're attempting to lose weight then you certainly have to start following this brand new tailor-made keto diet.

    To produce this keto diet service, certified nutritionists, fitness trainers, and chefs have united to develop keto meal plans that are efficient, painless, price-efficient, and satisfying.

    Since their first launch in early 2019, 1000's of individuals have already completely transformed their figure and well-being with the benefits a proper keto diet can offer.

    Speaking of benefits: clicking this link, you'll discover eight scientifically-proven ones offered by the keto diet.

    ReplyDelete
  2. Nice Blog , This is what I exactly Looking for , Keep sharing more blog .
    Remote Yii Framework Developer in India

    ReplyDelete