Cannot find namespace ‘System.Data.SqlServerCe’

I did include the System.Data.SqlServerCe dll, put using System.Data.SqlServerCe; in my code, but when I open the .NET page I get:

The type or namespace name ‘SqlServerCe’ does not exist in the
namespace ‘System.Data’ (are you missing an assembly reference?)

I have nave no idea how to fix this. Thanks in advance.

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

This can be solved confirming following 2 points:

  1. Check whether you already have System.Data.SqlServerCe namespace added to
    the References folder of your application. If its not there you
    may right click the References folder and select Add references
    option. From the popup window go to .Net tab and select
    System.Data.SqlServerCe from the list and click OK to add the namespace to the
    project.
  2. If you are OK with step 1, add using System.Data.SqlServerCe; to
    the top of your code behind file which uses the
    System.Data.SqlServerCe namespace.

Method 2

If you have an existing reference to System.Data.SqlServerCe yet you see a yellow symbol next to it then you should:

  • Remove the reference by right-clicking it.
  • Re-Add the reference.

To Re-Add:
Right click the References folder and select Add Reference… option. Go to the Assemblies | Framework option on the left pane, then scroll to System.Data.SqlServerCe in the right pane. If it’s there, click it then be sure to check the checkbox next to it before clicking OK.

If System.Data.SqlServerCe is not in the list then you’re going to have to browse for it on your computer. To do that, click the Add Reference… dialog’s Browse… button and try looking in this folder:

C:Program FilesMicrosoft SQL server Compact editionv3.5Desktop

or
C:Program FilesMicrosoft SQL server Compact editionv4.0Desktop

(The v#.# value in the examples above might be different by the time you read this, so navigate first to C:Program FilesMicrosoft SQL server Compact edition then choose the latest version or a specific version if you know what that should be.)

Once you find it by browsing, select the System.Data.SqlServerCe.dll file and OK your way out then try recompiling.

Method 3

Installing SQL Compact Server and then adding that reverence system.data.SqlServerCe.dll directly from your Microsoft Compact DataBase/ Program folder.

You’re missing the dll.

Im sure you already figured this one out though.

Method 4

Check your web.config file for any reference to that, and correct it. It could be an alias you defined wrong.

This answer might solve your issue.

Method 5

This is pretty late for answer. But I also faced the same kind of problem.
I am using Visual Studio 2012 and Visual Studio 2017 and I found the System.Data.SqlServerCe here.
The same directory for both Versions.

I edited @JesiMov Answer.

Right click the References folder and select Add Reference… option.
Go to the Assemblies | Extensions option on the left pane, then scroll to System.Data.SqlServerCe in the right pane.


All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes
Article Rating
Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x