title: How to get the ASP.NET MVC 4 model to link to an Oracle database
body: <p>This is my first MVC application so please be patient and kind. I have created an ASP.NET MVC 4 Web Application in Visual Studio 2012. I created the database code first, so all I did was create the model and a data context and a SQL server database was created for me. Every time I changed the model I could just update the database. I also connected to an Oracle database get other data that I needed. These are the connection strings that were used:</p>
  
  <pre><code>&lt;connectionStrings&gt;
    &lt;add name="ApplicationDBContext" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=something;Integrated Security=True" providerName="System.Data.SqlClient" /&gt;
    &lt;add name="ConnectionString" connectionString="Data Source=something;Persist Security Info=True;" providerName="Oracle.DataAccess.Client" /&gt;
  &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>However, the database related to the model needs to be in Oracle (and I need a script for it but that is next weeks question) not SQL.</p>
  
  <p>I was hoping that I could just change the data context provider name in the web config like so:</p>
  
  <pre><code>&lt;connectionStrings&gt;
    &lt;add name="ApplicationDBContext" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=something;Integrated Security=True" providerName="System.Data.OracleClient" /&gt;
    &lt;add name="ConnectionString" connectionString="Data Source=something;Persist Security Info=True;" providerName="Oracle.DataAccess.Client" /&gt;
  &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>But that is not working - it gives me errors.</p>
  
  <p>Please note that I am NOT asking about OracleMembershipProvider. This question is unique in that I want the model to relate to an Oracle database. I am not worried about membership and user authentication etc. I have already taken care of that.</p>
  
  <p>It seems like it should be simple enough, but I have googled until every link I find is purple.</p>
  
  <p>I need you to tell me the steps and what to do (hopefully in the web config) to get my model to 'create' an Oracle database. Please.</p>