Inv Xaasha Inv Xaasha - 2 months ago 14
C# Question

How to connect to SQL Server Ce database from C#?

How to Connect Sql Server CE Db to C# DotNet 4.0
I've Heard of System.Data.SqlServerCe NameSpace for Connecting local database but i am unable to find it in .Net 4.0

is there any alternate Class?


You need to have included the System.Data.SqlServerCe namespace

Its in the System.Data.SqlServerCe.dll

If that namespace doesn't show up then probably you haven't included refrence to that dll.

Add a reference to that dll and it should be available.

If you are still having problem then check out its in GAC. (On my system its here:

Some answers have already mentioned how to use it.