title: Entity Framework 4 and SQL Compact 4: How to generate database?
body: <p>I am developing an app with Entity Framework 4 and SQL Compact 4, using a Model First approach. I have created my EDM, and now I want to generate a SQL Compact 4.0 database to act as a data store for the model. I bring up the <em>Generate Database Wizard</em> and click the <em>New Connection</em> button to create a connection for the generated file. The <em>Choose Data Source</em> dialog appears, but SQL Compact 4.0 is not listed in the list of available data sources:</p>
  
  <p><img src="https://i.stack.imgur.com/LIQ0C.png" alt="enter image description here"></p>
  
  <p>I am running VS 2010 SP1 (beta) and I have installed the VS 2010 Tools for SQL Compact 4.0. I can create a SQL Compact 4.0 data connection from the Server Explorer. It is only in the <em>Generate Database Wizard</em> that the 4.0 option doesn't appear. BTW, my SQL Compact 4.0 installation does include <code>System.Data.SqlServerCe.Entity.dll</code>. So I should have the SQL Compact components I need.</p>
  
  <p>Am I doing something incorrectly, or is this a bug? Does anyone have a fix or a workaround? Thanks for your help. </p>