 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / .NET Framework / Compact Framework / August 2007RDA Pull on a Thread?
I use RDA and also a little web service call to pull data from a SQL Server via either an ethernet cradle or via WiFi. Now our installs use an ethernet cradle to dock the Symbol 8800s running Windows Mobile 2003. I'm developing in VS2005 and am now using CF2 and SQLCE 3.1. I really need to have the syncing going on in the background while the user is using the device to scan etc. in the field....so that the updating is seamless in the background and doesn't intefere with the app usage. Is this possible? Especially with RDA pull where you basically have to delete the table before pulling down a new table........ Any advice here - I've been needing a solution to this for years now and wondered if technology might've come up with an answer. TIA Harry If you're constantly in contact with the server, never out of range, it seems like you could avoid pulling everything down and just use remote data access to talk to the server directly from the device for each operation. Paul T. >I use RDA and also a little web service call to pull data from a SQL Server >via either an ethernet cradle or via WiFi. [quoted text clipped - 16 lines] > TIA > Harry So just communicate via the web service then.....this would scale ok? like 40 connections at a time? I've just never tried to do the wireless deal and don't know how it'd scale but I suppose the web service would be about like a web app right? Harry > If you're constantly in contact with the server, never out of range, it > seems like you could avoid pulling everything down and just use remote [quoted text clipped - 23 lines] >> TIA >> Harry I wouldn't imagine much of a problem for 40 connections. I wasn't actually suggesting connecting to the Web service at all, however, but directly to SQL Server. It shouldn't have any problems handling 40 connections... Paul T. > So just communicate via the web service then.....this would scale ok? > like 40 connections at a time? [quoted text clipped - 30 lines] >>> TIA >>> Harry In this architecture there really wouldn't even be a local SDF database at all then. Just direct communication with the SQL Server database via wifi eh? Guess you'd want to make transactional updates? case user interupts the save or something? Thanks Harry >I wouldn't imagine much of a problem for 40 connections. I wasn't actually >suggesting connecting to the Web service at all, however, but directly to [quoted text clipped - 36 lines] >>>> TIA >>>> Harry Yes, that's what I'm talking about. If you have multiple updates that must all be done or none of them be done, yes, you'd need to transact. You'd probably use transactions anyway, for that matter. If you got a cancel indication from the UI while you were in the middle of some long update, you should be able to abort the transaction. Paul T. > In this architecture there really wouldn't even be a local SDF database at > all then. Just direct communication with the SQL Server database via wifi [quoted text clipped - 46 lines] >>>>> TIA >>>>> Harry Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.