title: Entity Framework ORA-00932: inconsistent datatypes: “'expected CLOB got CHAR”
body: <p>Oracle.ManagedDataAccess.EntityFramework 6.122.1.0 library is used to access to an Oracle Database from MVC ASP.Net application. It is the latest library version from the NuGet as of November, 14th 2017</p>
  
  <pre><code>protected override Expression&lt;Func&lt;MyEntity, object&gt;&gt; getSelector()
  {   
      return m =&gt; new
      {
          ID = m.ID,
          NAME = m.Name,
          LONGSTRING = "Blah-blah-blah-blah...some thousands characters..." + 
                        m.ID + "blah-blah...blah" 
      };
  }
  
  protected override ProblemMethod()
  {
      var result = db.MyEntity.Select(getSelector()).ToList();
  }
  </code></pre>
  
  <p>There is the problem. That happens, because very long string (some thousands characters) is concatinated into  <code>LONGSTRING</code> , and execution of <code>Select</code> throw the next exception.</p>
  
  <blockquote>
    <p>ORA-00932: inconsistent datatypes: "'expected CLOB got CHAR"</p>
  </blockquote>
  
  <p>My class need to get <code>Expression</code> with the <code>GetSelector()</code> overriding. 
  How to overcome the error or get round it? One way to get round is force EF to execute <code>Select</code> on the client. How to do it?</p>
  
  <p>PS: <a href="https://ru.stackoverflow.com/q/741479/22836">Same question in Russian.</a></p>
  
  <h1>UPDATE</h1>
  
  <p>I should have to present MyEntity</p>
  
  <pre><code> CREATE TABLE MyEntity (ID NUMBER(10), Name VARCHAR2(100));
  </code></pre>