Databases
StackOverflow2013
Postsdbo
PORecommendations on a Client Host application in .Net
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORecommendations on a Client Host application in .Net
    text
    copied!<p>My question is concerning an application that will use a host application where the database server is, and a few clients that will be sending information to the host.</p> <p>Basically the host application receives some data from the clients, makes some calculations and error checking and then (if all goes well) it stores the information in the database. The data received could be easily serialized or get character separated in a string of less than 50 characters.</p> <p>I know my basic option in developing this communication application is WCF and have worked with it before but my concerns for this particular case is the fact that:</p> <ol> <li><p>The host and the clients will at most times be connected to the internet through wireless USB modems which as we all know do not provide the most reliable connection ever.</p></li> <li><p>There will be many clients all sending information to the host at the same time, each having their own identification id since that determines the type of the data received and what it represents.</p></li> <li><p>Due to the not so reliable connections i would like to be able to know if the packet has been sent successfully, and if not to be able to keep trying until the communication is complete.</p></li> <li><p>New data will be sent from each client every couple of minutes and if lets say we have a connection failure for 5 minutes i would like to be able to send all unsent information when the connection is restored.</p></li> <li><p>Lastly i'm kind of trying to figure how i would be able to know where to contact the host as the usb modems do not have a static ip and this could change from time to time.</p></li> </ol> <p>My thought is to either try to establish a communication through WCF services where the clients would send all information to the host directly or maybe consider serializing the data from the clients in XML format, then upload them on a 3rd server that will be available all of the time, and then use the host application every one minute to try and synchronize the available information with the ones one the 3rd server.</p> <p>Hope i made it pretty clear with this lengthy post on what i'm trying to accomplish and would really appreciate your thoughts for a project like this.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload