title: What is the difference between a Local Database in C# and a SQL Server Management Studio created database?
body: <p>I'm creating an application with MS Visual C# 2010 Express that requires a database.</p>
  
  <p>I've learned that there seem to be two ways to create/use a SQL database with this application.  </p>
  
  <p>The first seems to be where from within C#, I can create a "local database" by right-clicking on my application in the Solution Explorer and clicking "Add"->"New Item"->"Local Database". Then it's shown in the Database Explorer and I can use it. </p>
  
  <p>The other way is where I create a database with SQL Server Management Studio and then from within the C# code, I open a connection to it (SQLConnection... yada yada yada) and use it.</p>
  
  <p>I'm having a hard time understanding what technical reasons there are between choosing one way or the other way to do this...</p>
  
  <p>Can someone describe the differences and what criteria would be used to choose one way vs. the other?  (or point to a website reference...)</p>
  
  <p>Thanks!</p>
  
  <p>-Adeena </p>
  
  <p>Additional Info... 
  Right now, this is really a hobby project as I get a few things worked out.</p>
  
  <ol>
  <li>I'm the only developer and working on a single machine  </li>
  <li>The application is intended to be one that runs standalone - not in a
  browser or over the web in any way. I know that that's not the direction
  the universe is heading, but as mentioned above, this is a hobby
  project that I need to complete to work out a few other issues. </li>
  <li>I don't believe I have any need or intent for multiple applications to
  work on this database.</li>
  </ol>