I have installed the sp1 for visual studio 2010 and installed sql server ce 4 runtime. But still not able to create connection to the sql ce database using standart data provider.
This is how my Select DataProvider Dialog looks like now.
P.S. Does not know if it matters, but I have tested this with console application and winforms application both targeted at .Net 4.0
You must install the SQL Server Compact 4 tools via Web PI, as described here: http://erikej.blogspot.com/2010/12/visual-studio-tools-for-sql-server.html
You can use this project/Tool to open/create sql ce databases:
SQL SERVER CE QUERY TOOL
And have a look at this:
Everything SQL Server Compact
Regards
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With