Here are some more information:
At the moment of this response, the Entity Framework does not work well with Oracle, but you can write your own
Repository with the database operations and make a
override of its context to behave like a native Entity Framework.
I have a project that works like this. If you want to go this way, please ask more questions that I will post examples of code you can work on.
I had said that Oracle does not work with Entity Framework, but this response has become outdated, so I'm updating.
First you need to install the NuGet package Oracle.ManagedDataAccess.EntityFramework . The configuration of
Web.config should look like this:
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
<provider invariantName="Oracle.ManagedDataAccess.Client" type="Oracle.ManagedDataAccess.EntityFramework.EFOracleProviderServices, Oracle.ManagedDataAccess.EntityFramework, Version=188.8.131.52, Culture=neutral, PublicKeyToken=89b483f429c47342" />
You must also define a connection string for Oracle to work correctly.
Once you have done this, just work normally with the Entity Framework that should work.