Search code examples
c#visual-studio-2010sql-server-ce

I don't have SqlServerCe assembly?


I'm working on a simple WinForms app that uses an .sdf database to store data. I saw this interesting post on how to handle multithreaded access, which seemed useful. Problem is, I can't find the System.Data.SqlServerCe assembly. I installed the Sql Server Compact 3.5 SDK, but that reference still doesn't show up in my .NET assemblies list when I go to add the reference. What am I missing?

I'm using Visual Studio 2010 Ultimate on Windows 7.


Solution

  • Go to "Tools" and select "Choose Toolbox Items..." and select .Net Framework components and see if any of the SqlServerCe components shows up, then select one of the System.Data.SqlServerCe components, if you then add it to your form it will add the reference to your project.

    enter image description here