title: Get data from remote sql server in a .NET web service
body: <p>I have created a simple web service in visual studio 2015 with C#. I have set up an sql server database with a table and i want to simply return any value from that table.</p>
  
  <p>By searching i haven't found a very explanatory tutorial.</p>
  
  <p>Should i add a server connection in VS and then use linq or use SqlConnection?</p>
  
  <p>I also included an ADO Entity data model in the project but i don't know how to use it in the webMethod.</p>
  
  <p>Does any good tutorial exist about all options that i have to connect to the db and provide some examples, too?</p>