DataSet and WebService

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
Fri Feb 18 10:26:10 CST 2005

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" <magne.ryholt@bluezone.no> wrote in message
news:eu05PHdFFHA.1188@tk2msftngp13.phx.gbl...
> 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)
>
>

Magne
Fri Feb 18 15:27:41 CST 2005

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" <contactmethrumyblog@nospam.com> wrote in message
news:eLbrPadFFHA.3272@TK2MSFTNGP10.phx.gbl...
> 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" <magne.ryholt@bluezone.no> wrote in message
> news:eu05PHdFFHA.1188@tk2msftngp13.phx.gbl...
>> 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
Sat Feb 19 02:01:07 CST 2005

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/




"Magne Ryholt" <magne.ryholt@bluezone.no> wrote in message
news:%23MR%23uCgFFHA.2572@tk2msftngp13.phx.gbl...
> 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" <contactmethrumyblog@nospam.com> wrote in message
> news:eLbrPadFFHA.3272@TK2MSFTNGP10.phx.gbl...
>> 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" <magne.ryholt@bluezone.no> wrote in message
>> news:eu05PHdFFHA.1188@tk2msftngp13.phx.gbl...
>>> 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)
>>>
>>>
>>
>>
>
>