Since the announcement of Visual Studio 2010 and the .NET Framework 4.0 Beta 2 we have seen torrent of requests from people looking to use our Oracle EF provider with VS 2010. The good news is that we are planning to support it officially in our upcoming service pack, due early next year. The even better news is that demand is so great we've broken out the manual steps you can take if you want to get started with your Oracle with Visual Studio 2010. You'll be able to enjoy the full spectrum of EF 1.0 features and our EF enterprise extensions. More news on our upcoming EF 4.0 support on this blog soon – stay tuned. Many thanks to Jayakhanna Pasimuthu for the putting this together.
Oracle support for EF in Visual Studio 2010 instructions follow below…
Note: If you're running as in Windows XP, Vista or 7 you must run these as an Administrator.
3. Change to the tools directory (C:Program FilesDataDirectConnect for ADO.NET 3.3tools) and run the *install2010.cmd* from that directory as shown below.
[cc lang="sql" line_numbers="false"] Install2010.cmd "C:Program FilesDataDirectConnect for ADO.NET 3.3DDTek.VisualStudio.DataTools.dll" [/cc]
NOTE: The parameter passed should be the full path, along with the filename of wherever the latest "DDTek.VisualStudio.DataTools.dll" resides
4. Next, go to the folder C:WINDOWSMicrosoft.NETFrameworkv4.0.21006Config and add the below highlighted entries in machine.config file under <DbProviderFactories> tag
[cc lang="xml" line_numbers="false"]
NOTE: The folder v4.0.21006 could be different based on the VS2010 version being installed on a system. So one has to choose the latest folder starting with v4.0
7. You can then easily configure your Oracle connection using either TNSNames.ora file or directly using the connection properties dialog.
View all posts from Jonathan Bruce on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.Learn More
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You can also ask us not to share your Personal Information to third parties here: Do Not Sell or Share My Info
We see that you have already chosen to receive marketing materials from us. If you wish to change this at any time you may do so by clicking here.
Thank you for your continued interest in Progress. Based on either your previous activity on our websites or our ongoing relationship, we will keep you updated on our products, solutions, services, company news and events. If you decide that you want to be removed from our mailing lists at any time, you can change your contact preferences by clicking here.