title: SQL Server Compact Edition with Entity Framework
body: <p>I try to use SQL Server Compact Edition with Entity Framework in Visual Studio 2008 SP1. Here's what I do:</p>
  
  <p>1) I create a new project, of type Console Application.</p>
  
  <p>2) I right-click on the project, select Add->New Item.</p>
  
  <p>3) I choose to add a Local Database called Something.sdf</p>
  
  <p>4) In the next page of the "Add New Item" wizard, I choose the default dataset name (SomethingDataSet)</p>
  
  <p>Now, in the Server Explorer, the new database Something.sdf is shown under Data Connections.
  5) I right click on the project again, and select Add->New Item.</p>
  
  <p>6) I choose to add a ADO.NET Entity Data Model with the default name, Model1.edmx</p>
  
  <p>7) In the next page of the wizard, I choose to generate model from database.</p>
  
  <p>Now it asks me "Which data connection should your application use to connect to the database?". In this dialog, I can choose between using a pre-created Data connection, or to create a new connection.</p>
  
  <p>The drop down with pre-created data connections is empty (I would have expected to see my Something.sdf here?). When I press New Connection, I can only choose among Microsoft SQL Server, Microsoft SQL Server Database File, and  - I can't choose Microsoft SQL Server CE. If i choose Other, the data source ".NET Framework Data Provider for SQL Server" is shown, which is not what I want.</p>
  
  <p>What am I missing here? Why can't I select my SQL Server CE database in the Add Entity Data Model Wizard?</p>