The .edmx file is not executed in the project written with EF & SQL Server Compact in C#

I am using SQL Server Compact v4 in the project and I have completed the project with a database-first approach. I am using Entity Framework with the EntityFramework.Sql Server, EntityFramwework.SqlServerCompact, ErikEJ.SqlCE40 libraries, I have also installed SQL Server Compact Toolbox, but when I click on the .edmx file, it does not show me the tables and gives the following error:

Error 175: The ADO.NET provider with invariant name 'System.Data.SqlServerCe.4.0' is either not registered in the machine or application config file, or could not be loaded. See the inner exception for details.

At the same time, the project runs but does not open the desired file.

Even in the toolbox section, the "Add Sql Server Compact 4 Connection..." and "Add Sql Server Compact 3 Connection..." options are disabled.

enter image description here

enter image description here

Upvotes: 0

Views: 56

Answers (0)

Related Questions