title: How to Add/Activate "Oracle.ManagedDataAccess.Client" in the EF 6 provider config file?
body: <p>I am learning to make ASP.Net MVC Web application using VS2013 following <a href="https://www.youtube.com/watch?v=Lrr66APUwBk&amp;list=PL6n9fhu94yhVm6S8I2xd6nYz2ZORd7X2v&amp;index=8" rel="nofollow noreferrer">these video series</a>. When I got the following error:</p>
  
  <blockquote>
    <p>No Entity Framework provider found for the ADO.NET provider with
    invariant name 'Oracle.ManagedDataAccess.Client'. Make sure the
    provider is registered in the 'entityFramework' section of the
    application config file. See
    <a href="http://go.microsoft.com/fwlink/?LinkId=260882" rel="nofollow noreferrer">http://go.microsoft.com/fwlink/?LinkId=260882</a> for more information.</p>
  </blockquote>
  
  <p>(In the video, the database provider used is the natural <code>System.Data.SqlClient</code> for ASP.Net application, but I need to use <code>Oracle.ManagedDataAccess.Client</code>)</p>
  
  <p>The error itself is <a href="https://stackoverflow.com/questions/20143889/no-entity-framework-provider-found-for-the-ado-net-provider-with-invariant-name">not new</a> in SO. And, as suggested by the error message and by the accepted answer of the SO question, I checked if the ODP.Net provider is supported by EF 6.0 and I found that <a href="https://msdn.microsoft.com/en-us/data/jj730568" rel="nofollow noreferrer">it is</a>. Nevertheless I still cannot make it work.</p>
  
  <p>I am pretty new to MVC and so I seek your understanding if there be any concepts of MVC application/settings which I understand wrongly at this point and I am open to your corrections. </p>
  
  <p>Some additional info which might be useful:</p>
  
  <ul>
  <li>I use ASP.Net Web Application template provided by my VS2013 to start
  the project. I use MVC template for it and only "Add folders and core
  references for" MVC. I neither "Add unit tests" not "Host in the cloud"</li>
  <li>In the template, there isn't <code>app.config</code> file, but there is <code>Web.config</code> file (does this make any difference? It is suggested in the error message to "Make sure the provider is registered in the 'entityFramework' section of the
  application config file".)</li>
  <li>In the Web.config file, I found the following <code>entityFramework</code> portion:</li>
  </ul>
  
  
  
  <pre class="lang-xml prettyprint-override"><code>    &lt;entityFramework&gt;
        &lt;defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework"&gt;
          &lt;parameters&gt;
            &lt;parameter value="mssqllocaldb" /&gt;
          &lt;/parameters&gt;
        &lt;/defaultConnectionFactory&gt;
        &lt;providers&gt;
          &lt;provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" /&gt;
        &lt;/providers&gt;
      &lt;/entityFramework&gt;
  </code></pre>
  
  <ul>
  <li><p>I notice that there is </p>
  
  <pre class="lang-xml prettyprint-override"><code>&lt;provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" /&gt;` 
  </code></pre>
  
  <p>line there. And thus I try to similarly add:</p>
  
  <pre class="lang-xml prettyprint-override"><code>&lt;provider invariantName="Oracle.ManagedDataAccess.Client" type=???, EntityFramework.???" /&gt;
  </code></pre>
  
  <p>But I do not know what to write for the <code>type</code> attribute and the <code>EntityFramework.???</code> and has been stuck for a couple of hours. And if I do not put it, I got the following warning:</p>
  
  <blockquote>
    <p>The required attribute "type" is missing</p>
  </blockquote>
  
  <p>Any help for this will be appreciated. </p></li>
  </ul>
  
  <p>I also am open if you know that there is any additional things which I need to do besides adding the provider to fix this issue. My connections strings in the <code>web.config</code> file are as follow:</p>
  
  <pre class="lang-xml prettyprint-override"><code>&lt;connectionStrings&gt;
    &lt;add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\aspnet-MvcWebApplication1-20160212010850.mdf;Initial Catalog=aspnet-MvcWebApplication1-20160212010850;Integrated Security=True"
      providerName="System.Data.SqlClient" /&gt;
     &lt;add name="EmployeeContext" connectionString="Data source=aaaaa;user id=bbbbbb;password=cccccc;persist security info=True"   providerName="Oracle.ManagedDataAccess.Client"/&gt;
  &lt;/connectionStrings&gt;
  </code></pre>