Linqpad and StreamInsight
Posted
on SQLIS
See other posts from SQLIS
Published on Thu, 25 Nov 2010 00:00:56 +0100
Indexed on
2010/12/06
16:59 UTC
Read the original article
Hit count: 324
Slightly before the announcement of StreamInsight being available for Linqpad I downloaded it from here. I had seen Roman Schindlauer demonstrate it at Teched and it looked a really good tool to do some StreamInsight dev. You will need .Net 4.0 and StreamInsight installed.
Here’s what you need to do after downloading and installing Linqpad.
Add a new connection
The next thing we need to do is install and enable the StreamInsight driver. Choose to view more drivers.
Choose StreamInsight
Select the driver after install
I have chosen the Default Context.
And after all that I can finally get to writing my query. This is a very simple query where I turn a collection (IEnumerable) into a PointStream. After doing that I create 30 minute windows over the stream before outputting the count of events in each of those windows to the result window.
I have played with Linqpad only a little but I think it is going to be a really good tool to get ideas developed and quickly. I have also enabled Autcompletion (paid £25) and I recommend it.
© SQLIS or respective owner