title: need another connection string to use simple membership provider
body: <p>I am new to ASP.net MVC.
  In my MVC application I wanted to have default login functions.
   Already I have connection string like this for my entity framework connection to application,</p>
  
  <pre><code>&lt;add name="TestDB2Entities" connectionString="metadata=res://*/EntittyModel.SchoolDBModel.csdl|res://*/EntittyModel.SchoolDBModel.ssdl|res://*/EntittyModel.SchoolDBModel.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=PRAGEETH-PC;initial catalog=TestDB2;user id=sa;password=sa123;MultipleActiveResultSets=True;App=EntityFramework&amp;quot;" providerName="System.Data.EntityClient" /&gt;
  </code></pre>
  
  <p>Using that connection string I try to use the available function of default pre implemented login functions. I could not use that and show me following error.</p>
  
  <blockquote>
    <p>“Unable to find the requested .Net Framework Data Provider.  It may
    not be installed.”</p>
  </blockquote>
  
  <p>Then I try to create a new connection string as follow and then it worked fine,</p>
  
  <pre><code>&lt;add name="TestDB2Entities1"    connectionString="data source=PRAGEETH-PC;initial catalog=TestDB2;uid=sa;pwd=sa123;integrated security=sspi" providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p>But I need to have only one connection string to suit for both scenarios. Is it possible to have one connection string instead of having two connection strings?Or is it ok to have multiple connection string in my application?</p>