title: How to make a WPF Desktop application accessible over a network
body: <p>I am designing a WPF application that connects to a MS SQL Server database using Entity Framework. </p>
  
  <p>The application reads data from a Excel file and saves the records to the database. Now the next requirement has come that this application should be accessible to multiple users at the same time (company network) so that all users can see the data in database and query/update it whenever required.</p>
  
  <p>What I am thinking is, all I need to do is just put the database on a central machine which should be on the company's internal network and my application should connect to that database and allow users to perform the operations.</p>
  
  <p>What changes do I require to this current connection string?</p>
  
  <pre><code>&lt;connectionStrings&gt;
      &lt;add name="TPMSContext" connectionString="metadata=res://*/TPMSModel.csdl|res://*/TPMSModel.ssdl|res://*/TPMSModel.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=Test-DELL;initial catalog=TPMS;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&amp;quot;" providerName="System.Data.EntityClient" /&gt;
    &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>And what are other changes that I need to implement/keep in mind for my application to work for multiple users simultaneously?</p>
  
  <p>P.S: My application is "ANY CPU" with targeted framework as 4.5. Right now its Desktop based but in future we might make it web based, but for now we just want it to be Desktop based as it is.</p>
  
  <h2>Update</h2>
  
  <p>This is the view of my solution explorer. TMPS is my Main application. TPMS.Data contains my business logic and methods that provides interaction with the database though Entity Framework. TPMS.Entities has the database tables as entity classes:</p>
  
  <p><img src="https://i.stack.imgur.com/NSOCH.png" alt="Image"></p>