Developing using ce

[John]

Hi

I am new to sql server ce and am trying to get my head round how to develop
using sql ce as opposed to sql server 2000. I want to develop for hand held
devices using windows mobile. The vs.net 2003 ibuyspy compact framework
sample runs fine on the handheld when compiled and run. My problem is how to
setup a vb.net project which uses sql server ce as backend and how to
move/install to handheld when needed.

Thanks

Regards

 

[Ercan Turkarslan [MS]]

Hi John,

In order to develop applications using SQL Server CE, you need to use the
following ADO .NET namespaces:

System.Data
This is the most important ADO .NET namespace and it is included to your
WinForms project by default. Contains DataTable, DataColumn, DataRow and
DataView classes.

System.Data.Common
This name space contains DataAdapter object which is used to fill
DataSets with data. you may need to add it by Add Reference menu item under
Project menu.

System.Data.SqlServerCe
This name space contains the classes for Sql Server CE connectivity.

All the assemblies containing above namespaces comes with Visual Studio
.NET and they are deployed to your device automatically when you deploy
your application for debugging and running.

I would recommend Rob Tiffany's "SQL Server CE Database Development with
the .NET Compact Framework" book for further reading.

Thanks

Ercan Turkarslan
Mobile Devices Division
Developer Support Engineer