title: How do you work with SQL Server CE and SQL Server 2008 Express?
body: <p>I have installed:</p>
  
  <ul>
  <li>Visual C# 2008 Express</li>
  <li>Visual Web Developer 2008 Express</li>
  <li>Visual Studio 2008 </li>
  <li>SQL Server 2008 Express</li>
  <li>SQL Server Management Studio</li>
  </ul>
  
  <p>In Visual C# 2008 Express, I can "Add Item" and create a "Local Database" (.sdf file) or a "Service Based Database" (.mdf file).</p>
  
  <p>Visual Studio 2008 is the same as Visual C# 2008 for applications but in Websites, the only way I can create .sdf or .mdf files is via the Database Explorer.</p>
  
  <p>In Visual Web Developer 2008 Express, however, I can "Add Item" and ONLY create a "SQL Server Database" (.mdf file). Even the Database Explorer doesn't offer to create a SQL CE database.</p>
  
  <p>Questions:</p>
  
  <ul>
  <li>why the discrepency between the applications, is this normal or did something go wrong with my installations?</li>
  <li>I never "installed SQL CE", where did it come from and how is it that I am able to create .sdf file?</li>
  <li>How do you work with these in projects on a day to day basis, do you use Visual Studio to edit the databases or do you use SQL Server Management Studio?</li>
  </ul>