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)