title: C# SQL Server Coonnectivity - Constant Connection (client - server
body: <p>I have written many desktop applications and all have gone great using a mysql connection to a database and used sql to query the database. I now want to start a larger project and it feels "wrong" to make many many database connections when I could connect to the server as client - server relationship and just query without having to keep opening and closing connections.</p>
  
  <p>I have done a fair bit of digging around on google but to o avail. I think it's a case of I know what want to search, but not what to search for.</p>
  
  <p>Any gentle nudge in the right direction would be greatly appreciated!</p>