Monday, March 02, 2015
Oracle Data Provider for .NET now on NuGet
ODP.NET, Managed Driver is now on NuGet, meaning that you can add ODP.NET to your Visual Studio project with just a few clicks in the NuGet Package Manager. We've also published an Oracle By Example walkthrough to take you step by step through the process of using NuGet and ODP.NET.
Here we are in the NuGet Package Manager:
When searching for us in the package manager, make sure to get the official package - look for the word "Official" in the title.
There's actually two NuGet packages available:
ODP.NET, Managed Driver - Official
NuGet id: Oracle.ManagedDataAccess
This adds Oracle.ManagedDataAccess.dll to your project and also makes needed configuration entries in your app.config or web.config.
ODP.NET, Managed Entity Framework Driver - Official
NuGet id: Oracle.ManagedDataAccess.EntityFramework
This adds Oracle.ManagedDataAccess.EntityFramework.dll as well as config file configuration. It also has a dependency on the ODP.NET package above and will pull it into your project as well as EF 6 if needed.
If you want to host this package on your local intranet, it is also available for download on the OTN .NET download page.
Please note that if you want to use Visual Studio integration features, such as browsing your Oracle Schema in Server Explorer, or using Entity Designer or Table Adapter Configuration wizard, you should still install Oracle Developer Tools for Visual Studio, as a NuGet package does not provide any of the Visual Studio integration components needed to do design time work.