THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

StreamInsight Team

StreamInsight LINQPad Driver

Joseph Albahari's LINQPad has become an indispensable tool for many of us on the StreamInsight team. It allows you to quickly design, test and visualize results for LINQ queries. We've now developed a dedicated LINQPad driver for StreamInsight with Joe's help that you can use to quickly explore temporal data and StreamInsight's temporal LINQ dialect!

To get started, install .NET 4.0LINQPad 4.0 and StreamInsight 1.1. You'll need the full version of StreamInsight (StreamInsight.msi, not StreamInsightClient.msi) and you'll need to create a server instance during setup. This version of the LINQPad driver evaluates stream queries locally with an embedded StreamInsight instance. I strongly recommend activating auto-completion in LINQPad -- requires the purchase of an activation code but well worth the price! 

After launching LINQPad, you'll first need to register the StreamInsight driver:

  1. Click "Add connection"
  2. Click "View more drivers..."
  3. Click "Download & Enable Driver" under the "Microsoft StreamInsight Driver" heading

To create a connection to the embedded StreamInsight instance, click "Add connection" and select the "Microsoft StreamInsight" context option. For now, just select the "Default Context" option from the "Context Kind" list. Drag the newly created "StreamInsight: Default Context" connection to the query pane or select it from the "Database" list to write a query against a blank-slate context with no built-in streams. You can introduce a data source inline as in the following example that uses the "C# Statement(s)" language option in LINQPad:

var source = new[]
{
PointEvent.CreateInsert(new DateTime(2011, 1, 1, 12, 0, 0),
new { ID = "Hello" }),
PointEvent.CreateInsert(new DateTime(2011, 1, 1, 13, 0, 0),
new { ID = "World" }),
};

var input = source.ToStream(Application,
AdvanceTimeSettings.IncreasingStartTime);

input.Dump();

Hit F5 or click "Play" to run!

In addition to the default context, "Performance Counter" and "Hitchhiker'sGuide" contexts are available. The former context allows you to author queries against live performance counter streams. The latter exposes the data explored in A Hitchhiker's Guide to StreamInsight Queries. In addition, we have created a small set of samples -- this set should expand over the next few months! -- that rely on built-in contexts described above. You can add these samples by clicking "Download more samples..." under the "Samples" tab in LINQPad and choosing “Microsoft StreamInsight Samples”. The samples cover:

  1. Queries from the Hitchhiker's Guide
  2. Some simple performance counter queries to get you started
  3. An introduction example using the default context that illustrates various options for displaying StreamInsight query results

In a future blog post, we'll describe how you can author custom StreamInsight query contexts. As always, let us know if you have any questions or comments!

Regards,
The StreamInsight Team

Published Wednesday, November 24, 2010 6:03 PM by Roman Schindlauer
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Gavin said:

The link for 'A Hitchhiker's Guide to StreamInsight Queries' appears to be broken. Any chance of a fix?

November 25, 2010 12:28 AM
 

Roman Schindlauer said:

Gavin, this should be fixed now!

Roman

November 25, 2010 3:00 AM

Leave a Comment

(required) 
(required) 
Submit

About Roman Schindlauer

Program Manager in the StreamInsight team.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement