title: Using DbSet.Find with Oracle and EF CodeFirst
body: <p>I've read in a lot of websites and particulary in oracle forums that Entity Framework Code First or DbContext API is NOT officially supported by Oracle.</p>
  
  <p>That being said, I've also read in a lot of places that people have succesfully deployed projects using EF CodeFirst with Oracle. I've been running through a lot of issues and have been adjusting the code in order to make it work with SQL Server too.</p>
  
  <p>One function that does not seem to work is DbSet.Find where you pass the key as parameter and gets exactly that record.</p>
  
  <p>Using Find (which works just fine if I use sql server on the same codebase) throws an exception with the following error:</p>
  
  <pre><code>ORA-00942: table or view does not exist
  </code></pre>
  
  <p>I read <a href="https://stackoverflow.com/questions/9729750/how-to-configure-dbcontext-to-work-with-oracle-odp-net-and-ef-codefirst">this question</a> about it and they mention casing, which is not my case so no fix for me.</p>
  
  <p>The odd thing is that using <code>DbSet.SingleOrDefault(x =&gt; x.Id == SomeId)</code> works just fine so I'm pretty sure the casing of the schema, table names and columns is fine.</p>
  
  <p>Has anyone successfully used Find when using DbContext?</p>
  
  <p>Please do note: I'm not using an EDMX and can't use it, we must continue using CodeFirst.</p>
  
  <p>Thanks. </p>