SQL Server CE 4 DataProvider not available in server explorer

c# visual-studio-2010 dataprovider sql-server-ce
v00d00 picture v00d00 · Mar 20, 2011 · Viewed 7.4k times · Source

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. Change data source dialog

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

Answer

ErikEJ picture ErikEJ · Mar 21, 2011

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

Related questions

The type or namespace name could not be found

I have a C# solution with several projects in Visual Studio 2010. One is a test project (I'll call it "PrjTest"), the other is a Windows Forms Application project (I'll call it "PrjForm"). There is also a third project referenced by …

Read More
Writing to output window of Visual Studio

I am trying to write a message to the output window for debugging purposes. I searched for a function like Java's system.out.println(""). I tried Debug.Write, Console.Write, and Trace.Write. It does not give an error, but …

Read More
Is there a format code shortcut for Visual Studio?

In Eclipse there is a shortcut, Ctrl+Shift+F, that re-indents code and fixes comments and blank lines. Is there an equivalent for Visual Studio 2010?

Read More