![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
| |
| | #1 (permalink) |
| | 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) |
My System Specs![]() |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| KHz sample rate data and other key data fields missing from audio/media file properties view | Vista file management | |||
| appdata-local-Application Data-Application Data-Application Data infinitum ad nauseum. WHY | Vista General | |||
| Parental Controls are preventing streaming data, such as radio | Vista security | |||