THE SQL Server Blog Spot on the Web

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

StreamInsight Team

SQL Adapter Samples

We have added a new StreamInsight sample in the form of a Visual Studio solution called SqlApplication. The sample contains input and output adapter implementations that interface with Microsoft SQL Server. These are “generic” or un-typed adapters in that they can work with any given event type specified during query binding time, as long as the corresponding SQL query that provides the events has a matching schema. The adapters also demonstrate the use of the new Stop() method introduced in StreamInsight 1.1, with particular attention given to demonstrate correct handling of exceptions. Given this focus, the access and update of rows from/to SQL Server is row-by-row and synchronous. You can build on these samples to implement more advanced access mechanisms from/to SQL. The sample packages are in their familiar location on CodePlex. The added solution resides in the Applications folder of the samples package; the SQL adapter project includes a Readme file that describes the prerequisites, assumptions behind the samples, and the contained components. As always, your feedback is welcome!

The StreamInsight Team

Published Tuesday, November 16, 2010 10:02 AM by Roman Schindlauer
Filed under:



Min Teck said:

Any example of SQL input adapter using the event based mechanism like

SqlNotificationRequest than the normal SQL query pull?

June 26, 2011 5:06 AM
New Comments to this post are disabled

About Roman Schindlauer

Program Manager in the StreamInsight team.
Privacy Statement