title: Using ADO.NET Entity Data Model, how do I pass (or set) the connection string password?
body: <p>I am working with the ADO.NET Entity Data Model for this side project I am working on. Typically I would include the whole connection string (user and password) inside the web.config, but I was feeling frisky this morning so I decided to exclude the password from the connection string. Unfortunately for me, I cannot seem to figure out how to pass or set the password before I manipulate the database, and all the searching I've done so far have not yielded any fruitful results. All I have currently are a couple of lines that add a new record:</p>
  
  <pre><code>_entities.AddToUploadSet(uploadFile);
  _entities.SaveChanges();
  </code></pre>
  
  <p>I see there is a <code>ConnectionString</code> property inside of <code>_entities.Connection</code>, but I failed to find anything useful like a password property.</p>
  
  <p>Can anyone help me out? Thanks!</p>
  
  <h1>edit</h1>
  
  <p>For clarification, this screenshot shows the step where I can choose whether or not to include the password in the web.config file:</p>
  
  <p><img src="https://imgur.com/OV9Gj.png" alt="alt text"></p>
  
  <p>So as you can see, I need to set it in my application code as the prompt suggests.</p>