Can't connect to an SQL Server CE 4 database file


I have an SQL Server CE 4 database file, and want to connect to it using LinqPad. I created a new connection, chose Linq to SQL as the data context, then clicked the "SQL CE 4.0" radiobutton, choose the file and clicked Test, but got a message "Unable to find the requested .Net Framework Data provider. It may not be installed."

Given that I have both SQL Server 2014 and Visual Studio 2019 installed, it seems unlikely that I don't have the data provider installed. The MSDN docs say that it is installed with the .NET framework, and I have the following versions installed...

2.0.50727.5420 Service Pack 2
3.0.30729.5420 Service Pack 2
3.5.30729.5420 Service Pack 1

Any ideas? Thanks


Sign In or Register to comment.