what could be the best solution ?

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hello all,

I'm very new in the compactframe area....

I want to develop a application on a WinCE.NET(not PPC) device (most likely
in C# Visual Studio 2003).
The connection with the "homewebserver" will be a GPRS connection.
On the "homewebserver" is SQL2000 server installed.
What is the best way to go ?
Should I use SQL CE or use a WebRequest or something else ?
The idea is to have a little as possible kb going over the GPRS connection,
the less the better ! (connection will be very frequently)

Can somebody advice me what's the best way to do this ?

Thanks in advance for any suggestions,

Peter
 
SQL CE and WebRequest aren't really competing, in this case, are they? SQL
CE would be the answer if the data is to be stored locally. WebRequest
would be one way of accessing the data if it's *not* stored locally.

What you need to decide is how reliable is the data connection to the SQL
Server machine. If very reliable and not too expensive, then use RDA and
assume that the data is *always* on that server machine. Any changes that
you make on the CE device are 'immediately' propagated to the server and
everyone shares the same database. If this is the option you choose, I'd
suspect that RDA would cause fewer bytes to pass over the data connection
than some sort of HTML-based scheme, but testing is always a good idea.

If the data connection is particularly expensive or unreliable, you may want
to keep the data locally on the CE device and use merge/replication to
occasionally synchronize with the server database (so, if the CE user adds a
record, then, later, deletes it, it never travels over the network
connection and doesn't cost you any money).

Really, what you do is very application-specific and only you are going to
be able to say which is the best way, because you are the only one who knows
what kind of data is in the database and how the devices will use it, who
will change it, how often, etc.

Paul T.
 
Back
Top