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: 389
        
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





