title: Newbie: How to execute MyData.edmx.sql
body: <p>I've created a simple Entity Framework model-first app in VS 2012 by creating an MVC 4 project and adding a single data entity using the designer.</p>
  
  <p>The first time I right-click the designer surface and select Generate Database it prompts me for the particulars of my database connection.  I tell it to use a local database file in my App_data folder.  When it's done, it has created my (empty) database file, and it presents me with a shiny new MyData.edmx.sql file.</p>
  
  <p>Ok, so I assume that I need to execute this sql file against my new database file.  But I can't figure out the magic to do so.  When I right-click the sql file and select Execute, it tells me that I'm using a server type of Database Engine, and it asks me for a Server Name.  The only available option seems to be MyPC\SQLEXPRESS.  But when I select that and click on the Connect button, it complains that the the [MyData] database doesn't exist (because I've  told it to use SQL Express and not LocalDb with my database file).</p>
  
  <p>HELP.  How do I wire up VS to my new database file?</p>
  
  <p>Bob</p>