Can we "reverse engineer" a SQLCE (SQL Server Compact Edition) database using Entity Framework?
I've followed the MSDN Development Center tutorial Code First to an Existing Database on using the Entity Framework to "reverse engineer" a database so that we can use code-first with it. As per the tutorial I've:
- Installed the Entity Framework Power Tools.
- Generated an application (Empty MVC4) in Visual Studio 2012.
- Added a database (I need to use SQLCE).
- Right-clicked the root project folder and selected
Entity Framework > Reverse Engineer Code First
. - When the Connection Properties window pops up I changed the DataSource type to 'Microsoft SQL Server Compact 4.0.
- Browse to the Project App_Data folder and select the SQLCE database.
- Test the connection (success) and click Ok.
Then the following error is thrown:
System.ArgumentException:
The modelEntityContainerName parameter '...\App_Data\cesdfContext' contains characters that are not valid.