Can't connect to an SQL Server CE 4 database file
Hello,
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
4.0.0.0
4.8.03761
Any ideas? Thanks
Comments
I take it that you're using LINQPad 5? If so, you must install SQL CE from here:
https://www.microsoft.com/en-us/download/details.aspx?id=17876
If you're using LINQPad 6, you shouldn't need to install anything - LINQPad will automatically obtain what it needs from a NuGet package with your permission.
Thanks. I knew I had SQL CE, but didn't realise I only had 3.5, not 4.0.
All working now. Thanks again.