Entity Framework (EF) 4.3 Migrations with SQL Compact Edition

By default, EF 4.3 Migrations will use SQL Express as underlying database. To use SQL Compact Edition instead of SQL Express, we need to change default connection factory to SqlCeConnectionFactory which is already included in EF by adding this configuration segment to web.config/app.config

References:

• EF 4.3 Configuration File Settings