Windows Vista Forums
Vista Forums Home Join Vista Forums Donate Vista Tutorials Tags

Welcome to Vista Forums we are your forum to discuss Windows Vista x64 and x86 systems. Whether you need help or just want to post an idea you have on Vista, this is the forum for you.
Register at Vista forums...the world biggest Windows Vista resource Join Vista Forums Now

Go Back   Vista Forums > Microsoft Technical Newsgroups > Indigo

Streaming SQL Data

 
 
Thread Tools Display Modes
Old 04-20-2006   #1 (permalink)
ewellnitz@solarc.com
Guest


 

Streaming SQL Data

I have a large SQL result set that I am returning to a client from a
WCF Service. The client and the service both are configured to use
TransferMode.Streamed, and the operation signiture is:

System.IO.Stream GetData();

Within the service, I am reading all the data using a SqlDataReader and
writing the data out to the return stream, and then returning the
stream.

The problem with the above solution is that the service reads the
entire result set into the stream, and then returns the stream.

What I would like to be able to do is return the underlying stream the
SqlDataReader uses to the client, or return the stream to the client
while the sqldatareader is still pumping data into it within the
service.

The behavior I would like to have is similar to the behavior you get
when you return a FileStream from a WCF Service. On the client, you
are immediately able to start accessing lines within the file
regardless of file size.

Any suggestions?

-Eric Wellnitz (ewellnitz@solarc.com)

 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
KHz sample rate data and other key data fields missing from audio/media file properties view tophy Vista file management 4 04-14-2008 08:35 AM
appdata-local-Application Data-Application Data-Application Data infinitum ad nauseum. WHY keepout Vista General 15 09-15-2007 07:50 PM
Parental Controls are preventing streaming data, such as radio chunnel Vista security 7 08-24-2007 07:34 PM








Vistax64.com is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media 2005-2008

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50