i'm using SQL server CE for my windows phone development,
now i'm trying to use
using System.Data.SqlServerCe; but i cant having the following error
Error 1 The type or namespace name 'SqlServerCe' does not exist in the namespace 'System.Data' (are
you missing an assembly reference?) G:\Projects\UtillApp\BalanceIT\BalanceIT\MainPage.xaml.cs 13 19 BalanceIT
if you cant find System.Data.SqlServerCe.dll on you .NET assemblies tab you need to install Compacy CE SDK and its libraries.
this assembly is part of SQL Server Compact Edition and not part of Microsoft .net Framework. In order to see it in Object Browser, we have to add it manually. Please see the steps below:
1.In Visual Studio, please press CTRL+J to display Object Browser
2.From the dropdown list, please choose “Edit Custom Component Set…”
3.In Edit Custom Component Set window, please switch to Browse tab
4.Locate to the location of this assembly
we could found it in the following folder:
c:\Program Files (x86)\Microsoft SQL Server Compact Edition\v3.5\Desktop\System.Data.SqlServerCe.dll
c:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Desktop\System.Data.SqlServerCe.dll
Hi,.
i have tried the above steps but i'm getting the below error msg
"Reference cannot be added C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Desktop\System.Data.SqlServerCe.dll
because it was not built using the windows phone runtime. windowsphone projects will work oly wtih windows phone assemblies
thava
Member
53 Points
24 Posts
phone and SQL server CE connection
Dec 08, 2012 01:31 AM|LINK
Hi,
i'm using SQL server CE for my windows phone development,
now i'm trying to use
using System.Data.SqlServerCe; but i cant having the following error
Error 1 The type or namespace name 'SqlServerCe' does not exist in the namespace 'System.Data' (are you missing an assembly reference?) G:\Projects\UtillApp\BalanceIT\BalanceIT\MainPage.xaml.cs 13 19 BalanceIT
JangZ
Member
207 Points
74 Posts
Re: phone and SQL server CE connection
Dec 08, 2012 01:59 AM|LINK
Add reffrence to "System.Data.SqlServerCe.dll" in Solution >> refferences.
thava
Member
53 Points
24 Posts
Re: phone and SQL server CE connection
Dec 08, 2012 02:13 AM|LINK
i'm not able to include System.Data.SqlServerCe.dll
JangZ
Member
207 Points
74 Posts
Re: phone and SQL server CE connection
Dec 08, 2012 02:37 AM|LINK
if you cant find System.Data.SqlServerCe.dll on you .NET assemblies tab you need to install Compacy CE SDK and its libraries.
this assembly is part of SQL Server Compact Edition and not part of Microsoft .net Framework. In order to see it in Object Browser, we have to add it manually. Please see the steps below:
1. In Visual Studio, please press CTRL+J to display Object Browser
2. From the dropdown list, please choose “Edit Custom Component Set…”
3. In Edit Custom Component Set window, please switch to Browse tab
4. Locate to the location of this assembly
we could found it in the following folder:
c:\Program Files (x86)\Microsoft SQL Server Compact Edition\v3.5\Desktop\System.Data.SqlServerCe.dll
c:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Desktop\System.Data.SqlServerCe.dll
5. Double click it to select it
6. Click OK
thava
Member
53 Points
24 Posts
Re: phone and SQL server CE connection
Dec 08, 2012 04:51 AM|LINK
roopeshreddy
All-Star
20155 Points
3328 Posts
Re: phone and SQL server CE connection
Dec 09, 2012 05:18 PM|LINK
Hi,
Try installing SQL Server CE in Windows Mobile - http://www.microsoft.com/en-in/download/details.aspx?id=12264
Hope it helps u...
Roopesh Reddy C
Roopesh's Space