title: Using a phpmyadmin database in MVC with api
body: <p>I was asked if it is possible to create an API in asp.net MVC C#, Where the MVC program will use the API to call select data from an existing websites MySQL database and display it, then be able to put this data into a SQL database. My knowledge on APIs is limited and what I am looking for out of this question is:</p>
  
  <ol>
  <li><p>Is it possible?</p></li>
  <li><p>If so is there any good tutorials, videos or other documentation you could link that would help to achieve this?</p></li>
  <li><p>If it is not possible - what other options are there to do this? If any.</p></li>
  </ol>
  
  <p>I have spent a good bit of time searching around to try find something on this but I don't seem to be able to find anything and am not sure where to look.</p>
  
  <p>(Right now, to try to create this I have a MySQL database done in phpMyAdmin and a database done in SQL Server 2012 that are as identical as I could make them, I have no code as I don't know where to start and I am using Visual Studios 2013)</p>