Updating database using disconnected architecture

However, if all you need is to fetch some data and then work with it offline, a dataset comes in handy.

So imagine you have huge data to be sent across the network and do not want to put all that into a dataset, then go in for sending the data in chunks. This way, it is more of an on-demand load rather than clogging the n/w with lots of data.

You could pass the Data Set as a return value, in the same way that you can return any serializable class.

Once the Data Set is received by a client app, it might be serialized again and written to a local persistent store, such as isolated storage for Silverlight.

However, you might store it in cache, and even apply updates to it, to avoid having to go to the DB again for later page views.

With a Smart Client or Silverlight application, you could send the Data Set from the server to the client using ASMX or WCF.

Regarding your question about placing some data structure on the client and updating it at day-end: one way would be to serialize the object into a hidden field in a web page, such as in View State.

Is there any approach that we can place this dataset or any data structure on client machine and update it on day end ?

Connected architecture is when you constaintly make trips to the database for any CRUD operation you wish to do.

this creates more traffic to the database but is normally much faster as you should be doing smaller transactions. If you go in for a connected mechanism (like a datareader), you are blocking a connection for that amount of time.

A disconnected architecture also lets you easily send the data around to other machines.

This approach might be used with a seldomly-connected client, for example.

Leave a Reply

  1. Videochat live sex webcams 06-Nov-2019 01:03

    Transcending cultural differences and customs is just a small step to achieve that.

  2. Online xxx videos chat rooms 10-Jan-2020 13:22

    Anal Sex, Huge cocks, Blowjobs, Cumshots, Big tits, Tranny videos, High-res images, Subscribe to receive TSLadies News and promotions in your email address.

  3. Truely free sex chat 03-Dec-2019 10:45

    Patel said that he was "bloody energetic" as a child, and used to get in trouble at school because of it. She ended the relationship in January and began dating her Slumdog Millionaire co-star Dev Patel.

  4. Lanka sex web cam chat 15-Oct-2019 22:24

    Barney introduces Ted to a few single ladies that will be at the wedding, for them to be his weekend date, and winds up getting stuck with Cassie, who winds up irritating Ted.

  5. Free sexting chat rooms 09-Dec-2019 12:27

    But when you move to Berlin, you hear nada about how to get around the city's underbelly of public sex, and diverse turn-ons and orientations... No, everyone is more concerned with telling you where to get the good currywurst and that JFK wasn’t really going on about donuts.