Adding assmbly reference SqlServerCe, using Visual studio 2010

Question

0.00/5 (No votes)

See more:

I am trying to connect a database using C# . in a visual studio 2010.

this is the code To set up a SqlServerCe connection variable

C#

System.Data.SqlServerCe.SqlCeConnection con; // outside the form load
con = new System .Data .SqlServerCe.sqlCeConnection(); //inside the form load

I get an error saying:

HTML

sqlServerCe does not exist in the namespace.

What I know is that i need to add an assembly reference. How do i do that?

please help.

NB:
this assembly (SqlServerCe) is part of SQL Server Compact Edition and not part of Microsoft .net Framework. so i have to add it manually in VS 2010 professional. how do i add it manually?

Posted 2-Apr-13 22:48pm

Levy Mpyana

Updated 2-Apr-13 23:53pm

v6

Add a Solution

2 solutions

Solution 2

i have found an alternative solution.

To connect to the sql database using C# in Microsoft Visual studio,you have to amanually add the sqlSeverCe name reference manually.
that is you click on Project>>>Add Reference

a window pops up, click on the browse tab.

browse to C:\Program Files\Microsoft SQL server Compact edition\v3.5\Desktop

then double click on the System .Data .SqlServerCe file,
press OK.

Posted 3-Apr-13 1:01am

Levy Mpyana

Comments

Richard MacCutchan 3-Apr-13 7:03am

This is not an alternative solution, it is the standard method of adding references to a project; one of the basics of building in Visual Studio.

Zoltán Zörgő 3-Apr-13 7:06am

Richard is right. You have not read the second link I have given. This is also described there.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Accepted Answer · 2013-04-02T23:11:00

Solution 1

See here: http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlceconnection(v=vs.80).aspx[^]

Quote:
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

Here described is how you can add a reference: http://msdn.microsoft.com/en-us/library/wkze6zky(v=vs.80).aspx[^] to an assambly. This one should be in the first category.

Posted 2-Apr-13 23:11pm

Zoltán Zörgő

Updated 2-Apr-13 23:13pm

v2

Comments

Levy Mpyana 3-Apr-13 5:52am

this assembly (SqlServerCe) is part of SQL Server Compact Edition and not part of Microsoft .net Framework. so i have to add it manually in VS 2010 professional. how do i add it manually?

Zoltán Zörgő 3-Apr-13 6:01am

What about: http://www.microsoft.com/en-us/download/details.aspx?id=17876