How to use SQL Server Compact 3.5 with Entity Framework

Question

I have a SQL Server Compact 3.5 database in my Visual Studio project. When I try to create a Entity Framework model (from database) it only shows SQL Server Compact 4.0. I tried to reinstall 3.5 but that did nothing.

I need to to keep my version at 3.5 because SSIS can only write to a 3.5 file which is where my data is comming from.

Any ideas on how to get Visual Studio to use the 3.5 file?

Answer 1

Create the EDMX in a non web project, or use my SQL Server Toolbox add-in.