title: View data of .mdf file within visual studio
body: <p>I have a simple problem but have searched all across google and SO to no avail.</p>
  
  <p>I have a <code>.mdf</code> file that has 3 tables, I am working with this file in ASP.NET WebForms e.g updating, adding data etc... I want to be able to view the contents of the <code>.mdf</code> file in Visual Studio to make sure that the queries (written in C#) are working correctly. </p>
  
  <p>At the moment I am doing this by opening the file in SQL Server 2014 but that way I have to close visual studio as the file can only be used on instance.</p>
  
  <p>I know this can be achieved by connecting to a server but this is and <code>.mdf</code> file.</p>
  
  <p>Any suggestions?</p>