none
Oracle support in Entity Framework

    Question

  • Any idea which CTP or Beta might include support for an ADO.NET Data Provider other than SqlClient?

    While we all admit *GRIN* that SQL 2005 is the ultimate database server, many of us must contend with the fact that Oracle is still a very pervasive database and we need to support it.
    Tuesday, October 31, 2006 2:45 PM

Answers

  • Kevin,

    First, I wholeheartedly agree with your statement about the ultimate database server.

    We're committed to working with various .NET Data Provider writers to get early feedback from them and make sure we have a provider model that allows provider writers to leverage the great new features in the next version of ADO.NET.  You may have seen the announcement about a provider writer event that we held on campus in early August.  One of the provider writers there was able to make an early build of their Oracle provider connect to and query an Oracle database using the features of the August CTP.

    Here's a link to a summary of the event, which includes links to blog posts from two provider writers:

    http://blogs.msdn.com/adonet/archive/2006/08/25/724491.aspx

     

    Tuesday, October 31, 2006 11:32 PM

All replies

  • Kevin,

    First, I wholeheartedly agree with your statement about the ultimate database server.

    We're committed to working with various .NET Data Provider writers to get early feedback from them and make sure we have a provider model that allows provider writers to leverage the great new features in the next version of ADO.NET.  You may have seen the announcement about a provider writer event that we held on campus in early August.  One of the provider writers there was able to make an early build of their Oracle provider connect to and query an Oracle database using the features of the August CTP.

    Here's a link to a summary of the event, which includes links to blog posts from two provider writers:

    http://blogs.msdn.com/adonet/archive/2006/08/25/724491.aspx

     

    Tuesday, October 31, 2006 11:32 PM
  • Now that the RTM of Entity Framework has been released, is there built in support for Oracle now just by changing the connection string?

     

    I understand that Oracle Corp. has not released Entity Framework Designers but since Entity Framework is supposedly built on top of ADO.Net, shouldn't it simply work to just change my Connection String in my App.Config or web.config file to point to an Oracle provider instead?

     

    Please let me know if this is not the case.  We are planning on implementing Entity Framework for a software release in March and we need to be able to ensure to our customers that Entity Framework has existing support for Oracle in addition to SQL Server.

     

    Thanks.

     

    Thursday, September 25, 2008 2:54 AM
  • there is any plan for oracle to support the new entity framework version that will be avaliable in the .net 4.0
    Saturday, June 27, 2009 3:52 PM
  • If you wanted to get started with it right away, try out devart's dotconnect for Oracle (http://devart.com/dotconnect/oracle/).  It's pretty reasonable for a site license, and gets you EF, Linq, etc.
    • Proposed as answer by vs2010junkie Wednesday, March 31, 2010 11:04 PM
    Monday, June 29, 2009 12:03 PM
  • DataDirect also has a solution for this which additional includes Microsoft Enterprise Library support.  http://www.datadirect.com/products/net/net_for_oracle/index.ssp

    Microsoft's official stance on Oracle support seems to be that it will not provide support and will leave this up to individual 3rd party vendors.

    • Proposed as answer by vs2010junkie Wednesday, March 31, 2010 11:04 PM
    Wednesday, March 31, 2010 11:04 PM
  • Hi,

    Oracle has released a beta version of ODAC to support Entity Framework.  Download it from http://www.oracle.com/technetwork/topics/dotnet/downloads/oracleefbeta-302521.html

    Regards

    Venkat


    Raja Venkatesh
    Sunday, February 13, 2011 5:24 PM