SQL Server Compact 4.0 DbProvider - No

Question

I am using SQL Server Compact / SQLite Toolbox for Visual Studio from ErikEJ. The environment is Windows 7 x64 with Visual Studio 2013.5.

I follow the example on the blog http://erikej.blogspot.dk/2013/11/entity-framework-6-sql-server-compact-4_25.html , but when I get to

"... connect to the database file in the project folder:",

I right-click on “Add SQL Server Compact / SQLite Connection” and the window appears, but below is in red

"Unable to save this connection for use with EF6 Tools, make sure SQL Server Compact DbProvider is installed and possibly restart Visual Studio"

I go back and click on the "About" button and get

SQL Server Compact 4.0 in GAC - Yes - 4.0.8482.1 
SQL Server Conpact 4.0 DbProvider - No

SQL Server Compact 4.0 DDEX provider - No 
SQL Server Compact 4.0 Simple DDEX provider - Yes
SQL Server Compact 4.0 Engine Test: PASS!

SQL Server Compact SQL Server Compact Toolbox , .

, SQL Server Compact 4.0 DbProvider?

machine.config, .

<system.data>
    <DbProviderFactories>
        <add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
        <add name="OleDb Data Provider" invariant="System.Data.OleDb" description=".Net Framework Data Provider for OleDb" type="System.Data.OleDb.OleDbFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
        <add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
        <add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
        <add name="Microsoft SQL Server Compact Data Provider 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/></DbProviderFactories>
</system.data>

https://developer.teradata.com/blog/netfx/2010/12/dbproviderfactories-demystified, .

. . C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config

<system.data>
    <DbProviderFactories><add name="Microsoft SQL Server Compact Data Provider 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/></DbProviderFactories>
</system.data>

hmmm... .

Answer 1

, .

Visual Studio 2013 SQL Server Express. , , https://dba.stackexchange.com/questions/68373/how-to-uninstall-sql-server-2012-not-showing-in-control-panels-programs-and-fe sql, Visual Studio 2010?,

D:\vs_community.exe /uninstall /force

VS2013.5, , . , ,

wmic product where "name like 'microsoft visual studio%'" call uninstall /nointeractive
wmic product where "name like 'microsoft sql server%'" call uninstall /nointeractive

, .

Revo Uninstaller . , .

VS2013.5, SQL Server Compact Tool . , - , .

Answer 2

, , , -.

,

EF6 Tools, , SQL Compact DbProvider , , Visual

DataGrid . DDEX, ErikEJ ( )