If you have ever used SQL Server Management Studio, you would have noticed how query results begin to show in the viewer before the query is finished and all results are received by the client.
I am looking to implement (reuse) that functionality for my own data store / data streaming farm.
- Client sends a query to the server and gets back an IEnumerable (4.0 IObservable?)
- Client iterates over it until a) end of stream or b) Client explicitly cancels the query
- Asynchronously, a separate thread on the client continues to receive data, but no more than some buffer would allow.
- If no new data is available, client should be able to either block / get notified / busy poke.
Are there any libraries like that? Are ADO providers implement something similar? Streaming engines?
Thanks!!!