title: SQL Server Compact 4.0 Provider is not in list for EF
body: <p>My WPF application uses Entity Framework 4.0 with a SQL Server CE database. And I need to have SQL Server CE 4.0 to allow the <code>@@IDENTITY</code> columns to be server generated.</p>
  
  <p>So I just installed SQL Server Compact 4.0 on my system, but I cannot create a SQL Server CE 4.0 database since its not in the list when I choose a data source from VS2010.</p>
  
  <p><img src="https://i.stack.imgur.com/RbyLv.jpg" alt="enter image description here"></p>
  
  <p>I wonder why because in the Windows programs list SQL Server CE 4.0 is there :</p>
  
  <p><img src="https://i.stack.imgur.com/nnXV5.jpg" alt="enter image description here"></p>
  
  <p>Any idea?</p>