title: Connection String Conversion for Deployment on IIS
body: <p>I am new to WCF and I have created a wcf service and a Database to write to by using LINQ. In my web.config file it is still using the standard connection string (I don't really understand the content of the connection string)</p>
  
  <p>connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\jarvis.mdf;Integrated Security=True"</p>
  
  <p>that is automatically generated when creating a database. My WCF Interface has the following Operation Contract:</p>
  
  <pre><code>[WebGet(UriTemplate = "Add", ResponseFormat = WebMessageFormat.Json)]
      string Add();
  </code></pre>
  
  <p>When I run the WCF on the local machine with <code>"http://localhost:58632/WCFService.svc/Add"</code>, I write to the DB perfectly with no Problem.(Could be because the connection string is meant for local connection)</p>
  
  <p>When I attempt to deploy the application on a server with IP <code>10.0.0.14</code> and run <code>http://10.0.0.14/Service/WCFService/Add</code> it does not allow me to write to the DB. I think this is because of the connection string, but I am not sure.</p>
  
  <p>The Procedure that I follow to deploy on IIS is"</p>
  
  <pre><code>1. Right click on the solution and select Publish...
  2. Select Connection and the publish Method is Web Deploy Package
  3. I go to the Package location and go in to the zip file to get the content.
  4. Place the content in the wwwroot/Service folder, then I attempt to write.
  </code></pre>
  
  <p>How would I go about changing the Connection string so that I can write to the DB when the WCF is deployed on IIS and must SQL Server be installed on the server running the WCF? I don't want to make use of external libraries or applications like <code>SlowCheetah</code>.</p>