Search code examples
c#sql-serversql-server-ce

Master Details with Using SQL Server Compact 4.0(simple by ErikEJ)


I need to create a simple master/details form that collects data from a database, make some changes and save them. I use SQL Server Compact 4.0(simple by ErikEJ). I have try Master Details Demo.

This is my Database:

enter image description here

But when I followed the Entity Data Model Wizard I get the following error:

enter image description here

It seems that it's not supported by Visual Studio 2013. Any suggestion would be appreciated.

Thanks in advance.


Solution

  • I wrote the "Simple" DDEX provider, and it is only meant for running the EDMX Wizard in order to create a EDMX or Code First from Database model. (That is why it is called simple). So it does not support working with DataSets and DataAdapters. In addition you should not be using DataSet with SQL Server Compact due to the memory overhead. Use SqlCeResult set if possible: https://msdn.microsoft.com/library/bb219485.aspx