Transferring Data Between Server and Client (Mobile)

Posted by Byron on Stack Overflow See other posts from Stack Overflow or by Byron
Published on 2009-08-04T19:27:40Z Indexed on 2010/04/27 3:33 UTC
Read the original article Hit count: 253

Filed under:

compact-framework

|

sql-server-ce

|

data-structures

|

windows-mobile

Scenario:

Client (Mobile) - .Net CF 2.0, SQL CE 3.0
Server - .Net 2.0, SQL Server 2005, Web Service
Client and Server database schemas differ. From server - only certain columns from certain tables need to be synced. From client - everything will need to be synced once client has made changes.

Client will continually poll a web service to download and upload data. A framework will be developed to package and unpackage data, used by both client and server.

How would you develop the packaging and unpackaging? Use datasets, serialise strongly typed objects? All suggestions welcome.

Thanks

© Stack Overflow or respective owner

Related posts about compact-framework

Getting State of Modifier Keys Compact Framework

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I get the state of a modifier key using VB.NET on the Compact Framework, in this case Windows Mobile 6.1. I want to be able to determine if the following keys are pressed or locked: Shift CTRL ALT and for the Psion Teklogix machines Orange Blue Although I may be able to work this out, if… >>> More
Windows mobile Compact Framework SqlCeConnection

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm hearing that is better to have one connection open upon app start up and closing it when the app shuts down. What kind of issue can occur having multiple connections ? Any articles out there that it is best practices to have one connection? What are your experience with sql ce? >>> More
C#: How to set AsyncWaitHandle in Compact Framework?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm using a TcpClient in one of my Compact Framework 2.0 applications. I want to receive some information from a TCP server. As the Compact Framework does not support the timeout mechanisms of the "large" framework, I'm trying to implement my own timeout-thing. Basically, I want to do the following: IAsyncResult… >>> More
Has MSDN Dropped Compact Framework already?

as seen on Stack Overflow - Search for 'Stack Overflow'
MSDN Documentation used to indicate if a method was supported on the compact framework. But now I can't find that info anymore. I know that Microsoft has dropped Compact Framework like a hot potato, but I did not know that they had ripped it out of the docs. As examples of what I am talking about… >>> More
Is there compilation symbol to detect compact framework?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a compilation symbol to detect if it's running on a compact framework platform >>> More

Related posts about sql-server-ce

How programically check if SqlServerCe is installer (System.data.sqlserverce exist)

as seen on Stack Overflow - Search for 'Stack Overflow'
How programically check if SqlServerCe is installer (System.data.sqlserverce exist) in c# .Net 3.5. Can I get the version on SqlServerCe? >>> More
How programically check if SQL Server CE is installer (System.data.sqlserverce exist)

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I programmatically check whether SQL Server CE is installed (System.data.sqlserverce exist) in C# .Net 3.5. Can I get the version on SQL Server CE? >>> More
Slow Update/insert into SQL Server CE using LinqToDatasets

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a mobile app that is using LinqToDatasets to update/insert into a SQL Server CE 3.5 File. My Code looks like this: // All the MyClass Updates MyTableAdapter myTableAdapter = new MyTableAdapter(); foreach (MyClassToInsert myClass in updates.MyClassChanges) { // Update the row if it is… >>> More
SQL Server CE, Visual Studio 2008/2010 RC, and Linq-to-Sql

as seen on Stack Overflow - Search for 'Stack Overflow'
I added an .sdf to my project, added a table, added a Linq-to-Sql dmbl, and tried to add the table to the dbml. The result was an error: "The selected object(s) are an unsupported data provider" This happens in both VS 2008 Professional SP1 and 2010 RC Ultimate. I found someone talking about… >>> More
SQL Server 2005 Merge Replication to SQL Server CE 3.5

as seen on Server Fault - Search for 'Server Fault'
Hi, In my organization, we have a SQL Server 2005 database server (DBServer). Users of an application will normally be connected to DBServer, but, occasionally, would like to disconnect and continue their work on a laptop using SQL Server Compact Edition 3.5 (SQLCE). Due to this, we have been looking… >>> More