title: EFCore error:- ORA-00904: "m"."Id": invalid identifier
body: <p>I am working with an application using <code>asp.net core 2.2</code> and <code>efcore database</code> first approach with <code>Oracle database</code>. I am using <code>Oracle.EntityFrameworkCore (2.19.60)</code> <code>nuget</code> package, successfully mapped db model, but when I try to fetch data from <code>DBContext</code> , getting error </p>
  
  <blockquote>
    <p>ORA-00904: "m"."Id": invalid identifier</p>
  </blockquote>
  
  <p>Oracle Database version:  Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production</p>
  
  <p>code:</p>
  
  <pre><code>var fetched = await myDatabaseContext.MyTableVersions.ToListAsync();
  </code></pre>
  
  <p>LinQ is generating following query :</p>
  
  <pre><code>SELECT "m"."Id", "m"."MAJORVERSION" FROM "MyTableVersions" "m"
  </code></pre>
  
  <p>Since It's not a correct syntax for PL/Sql query so getting error ORA-00904: "m"."Id": invalid identifier.</p>
  
  <p>Is there any way to fix this error? Thanks.</p>
  
  <p>I have searched on the web and found</p>
  
  <blockquote>
    <p>Bug 30352492 - EFCORE: ORA-00904: INVALID IDENTIFIER</p>
  </blockquote>
  
  <p>but that issue is related to schema.</p>