1 Reply Latest reply: Dec 4, 2012 6:42 AM by 919764 RSS

    Oracle XE 11g and Entity Framework 4.4

    919764
      I have Windows Server 2008 R2 32bit and Oracle 11g Release 2 Express Edition installed on my server machine.

      I have Windows 7 Pro 64bit, Visual Studio 2010 SP1 32bit, .NET 4.0 and Oracle .NET Data Provider (ODTwithODAC1120320_32bit) installed on my development machine.

      The data provider download mentioned Entity Framework support. Existing tutorials on how to use Oracle with the Entity Framework makes me believe that EF is indeed supported! But when I try to create a new ADO.NET Entity Model, the Oracle data provider nor data source isn't listed!
      Image: http://i.stack.imgur.com/4SnW8.png

      On the other hand, if I want to create a new database connection, via the Server Explorer view, there are no problems connection to Oracle's DB.
      Image: http://i.stack.imgur.com/ipXSV.png

      The reason I need Entity Framework support is because we're migrating from MSSQL to Oracle and are looking for the most painless route to do so.

      Edited by: 916761 on Dec 4, 2012 3:24 AM