Home Services Partners Company
Effective EF for Oracle - Visual Studio 2010

Effective EF for Oracle - Visual Studio 2010

December 18, 2009 0 Comments

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.

1. Grab a copy of our Connect for ADO.NET 3.3 package from here.

2. Grab the tools.zip archive and copy the contents (install2010.cmd, install2010.reg, install2010.vbs files) to the tools directory of DataDirect folder (e.g. C:Program FilesDataDirectConnect for ADO.NET 3.3tools)

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

5. Next go to the Visual Studio 2010 folder where devenv.com resides (e.g. C:Program FilesMicrosoft Visual Studio 10.0Common7IDE)
Next run ... [cc lang="sql" line_numbers="false"] % devenv /setup [/cc] ...and restart Visual Studio 2010 and you should be able to build EF Oracle applications in Visual Studio 2010.

6. Adding a new Entity Model, you should be able to select a new Oracle data source.

7. You can then easily configure your Oracle connection using either TNSNames.ora file or directly using the connection properties dialog.


Jonathan Bruce

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.

Read next JDBC-ODBC Bridge Replacement Yields 310% Performance Boost
Comments are disabled in preview mode.