I don't have SqlServerCe assembly?

Question

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.

What version of VS are you running? it will not work with the express editions — Mark Hall, Jul 30 '12 at 01:52

score 8 · Accepted Answer · edited Jul 04 '17 at 06:31

8

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

edited Jul 04 '17 at 06:31

Rich

3,928
4
37
66

answered Jul 30 '12 at 02:05

Mark Hall

53,938
9
94
111

For myself, I can only seem to see SqlConnection, SqlCommand, SqlCommandBuilder - so no SqlCe... items. Is there any define with my items not being SqlCe... ? thanks – Sambuxc Dec 21 '14 at 15:23
1

@Samuroid did you install the [SQL Server Compact SDK](http://www.microsoft.com/en-us/download/details.aspx?id=10070)? http://stackoverflow.com/questions/10747518/sql-server-compact-edition-4-0-sdk – Mark Hall Dec 21 '14 at 15:29
@MarkHall Yes I believe I have. I have the Microsoft SQL Server Compact Edition directory under ProgramFiles – Sambuxc Dec 21 '14 at 16:31
@Samuroid you will need to click the browse button and go to the directory and select the proper dll per compentent_tech's answer – Mark Hall Dec 21 '14 at 16:57
@MarkHall thanks, I managed to get it working now :) However upon trying to access the data in my tables I get this error message, "Database file may be corrupt..." – Sambuxc Dec 22 '14 at 08:07
You probably should ask that as a question. – Mark Hall Dec 22 '14 at 08:09

score 1 · Answer 2 · answered Jul 30 '12 at 01:41

1

I believe that you need to browse to the assembly in order to get it included.

answered Jul 30 '12 at 01:41

competent_tech

44,465
11
90
113

Where is it? I looked in the SDK folder and the closest thing is System.Data.SqlServerCe.Entity.dll. MSDN says it should be System.Data.SqlServerCe.dll – Stephen Collins Jul 30 '12 at 01:43
1

On my system, it is in C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v3.5\Private – competent_tech Jul 30 '12 at 01:54

score 0 · Answer 3 · answered Jul 30 '12 at 01:45

0

have a look at this post on MSDN : How to find correct "System.Data.SqlServerCe.dll" in desktop project?

answered Jul 30 '12 at 01:45

BizApps

6,048
9
40
62

I've done all this. And I should note that I'm using VS2010. – Stephen Collins Jul 30 '12 at 01:51

score 0 · Answer 4 · answered Apr 24 '16 at 06:35

0

Adding my database as a Data Source solved the problem for me. (Shift + Alt + D) then Add New Data Source knowing that my .sdf database is already connected with my project via Data Explorer.

answered Apr 24 '16 at 06:35

Rashedkoutayni

41
8

I don't have SqlServerCe assembly?

4 Answers4

Linked