Diffrence between using a sqlserverCE and sqlClientCE

[Raman Bhavaraju]

Hi Guys!!

I am stuck on one thing!!.
I am using slqServerCE object to update my sql server 2000
database by using pull and push methods.
but i feel the same can be done with sqlclientCE object
also.Also sqlClientce gives me the additional facility of
using a command , adapter objects also.

Can anyone please let me know what is the diffrence that i
get in using them..the sqlServerCE object and sqlClientCE
object to update my sql server 2000 database.

 

[Ben Albahari [MS]]

I think you may already be doing things correctly. You need RDA (as you're
doing now) or Merge Replication to transfer data directly between SQL
Server CE and SQL Server Databases. The SqlCeDataAdapter class is used to
read and update data between SQL Server CE and a dataset , which is part of
ADO.NET.

Ben Albahari
.NET Compact Framework
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| Content-Class: urn:content-classes:message
| From: "Raman Bhavaraju" <[email protected]>
| Sender: "Raman Bhavaraju" <[email protected]>
| Subject: Diffrence between using a sqlserverCE and sqlClientCE
| Date: Sun, 14 Sep 2003 10:51:44 -0700
| Lines: 13
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| x-mimeole: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcN66Nwv8O4O+Pk6Q063aMjbdi4Sww==
| Newsgroups: microsoft.public.dotnet.framework.compactframework
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:33512
| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework
|
| Hi Guys!!
|
| I am stuck on one thing!!.
| I am using slqServerCE object to update my sql server 2000
| database by using pull and push methods.
| but i feel the same can be done with sqlclientCE object
| also.Also sqlClientce gives me the additional facility of
| using a command , adapter objects also.
|
| Can anyone please let me know what is the diffrence that i
| get in using them..the sqlServerCE object and sqlClientCE
| object to update my sql server 2000 database.
|
|