ado.net

  • Thread starter Thread starter nedim
  • Start date Start date
N

nedim

is it possible to use ado.net and use databases in
programs with .net compact framework? i started to write
code, wrote using system, using system.data, and when i
tried to write using system.data.oledb, after typing
using sytem.data., i didn't get any autocomplete options.
 
nedim,

SqlClient and SqlCeClient are the only data providers for the compact
framework.
 
what namespace containts those data providers, how do i
use them, if those are for sql server database, how do i
transfer that database to the win CE device?
 
nedim,

SqlClient and SqlServerCe are part of System.Data on the compact framework.
The SqlClient provider is for directly connecting to a SQL Server database
via TCP/IP, and not for connecting to a database on the CE device. The
SqlServerCe namespace is for use with a SQL Server CE database that is on
the CE device. You can transfer data between a SQL Server database and a SQL
Server CE database using remote data access (RDA) or merge/replication.
 
Ginny,
You can transfer data between a SQL Server database and a SQL
Server CE database using remote data access (RDA) or merge/replication.
Click to expand...

And I think what many forget, is that you can use rapi to copy data to and
fro. You don't have to use Sql on the desktop. Get data to the pda and back
to the desktop with rapi and insert it into Sql Ce on the pda and you have a
solution without Sql on the desktop, if that is a requirement of your app.
In other words rda or replication are not strictly necessary.

Graham
 
Hi Graham,

Yes, that's a good point. A slightly different twist on that is using the
Rapi app to collect data from SQL Server on the desktop, then transferring
that down to the CE device and manipulating it in its native format, then
transferring it back to a Rapi app that inserts it into the SQL Server. The
native format on the CE device could be XML, CSV files or some other ASCII
format.
 
Ginny,

Ok, but why would you do that.

Is that just to avoid the need for IIS.

Graham
 
Graham,

You'd do that if the amount of your data on the device was small (or very
small in the case of XML) and/or if it was impractical to set up RDA or
merge/replication at a lot of sites.
 
Back
Top