DataSet and WebService

[Magne Ryholt]

I have a big typed DataSet (dataset.GetXml().Length approx 5,000,000).
I want to expose this dataset as a webservice, but it is too big.

Then I want to filter this dataset to reduce it and expose it as webservice,
filter criteria given by WS consumer.
Someone knows a good way of doing this ?

I could imagine some sort of clone method on DataSet which clones all
tables, but filtered (and perhaps sorted) as described in a ViewManager as a
parameter to the "clone" method, but I have not found anything like that in
the framework (1.1)

 

[Sahil Malik]

You can -

a) Binary Serialize the dataset using Datasetsurrogate (search knowledgebase
for it).
b) Use a combination of Dataset.GetChanges and Dataset.merge to reduce the
actual amount of data being sent over the wire.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

 

[Magne Ryholt]

Thanks Sahil

I can understand the binary serialization by DataSetSurrogate (event if I
have some problems using it on WS, and it cannot handle typed datasets),
but could you please describe a little further what you mean by a
combination of GetChanges and Merge methods,
should I first change some data in the dataset ?? and what will Merge
contribute with ?

 

[Sahil Malik]

Hmm .. I've used DSS on Typed Datasets - there are a few minor issues, like
float default values/accept changes on deleted rows (owing to XML
serialization by default) - but they are not insurmountable.

Other than that - GetChanges fetches the subset of the dataset that has
changed. And Merge has the ability to merge two datasets. If the two being
merged datasets are the same structure - as they would be in the case of
dataset and dataset.getchanges, you could effectively send only changed
rows - and not have to transmit huge amounts of data -- and be able to
recreate the picture AS IF the entire dataset had been sent.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/