title: StreamInsight 2.1 against a SQL Database and ... How does it work?
body: <p>I've installed StreamInsight 2.1.  I've been able to turn it on and Server.Create(), expose a WCF endpoint, and connect to it with the Event Flow Debugger.  I've found plenty of examples of creating fake event sources.</p>
  
  <p>I'd like to know how to create what I think to be possible: a standing query against a SQL 2012 database.  I haven't found any sample code for connecting to an RDB - just statements that "This is just for show, for real you'll maybe connect to an RDB".</p>
  
  <p>Can it only use LINQ-to-SQL?  Entity Framework 4?  plainer ADO.NET?  Some MS SQL-specific protocol?</p>
  
  <p>I guess the part that really confuses me is how these standing queries are supposed to work.  It would seem odd to me, these days, for Microsoft to have an exposed capability in SQL Server that is ONLY accessible by a certain independent SKU (StreamInsight).  Therefore, it must be one of these two:</p>
  
  <p>Is SQL aware of the standing-ness of the query or does StreamInsight just modify a LINQ statement to poll efficiently (like by adding <code>AND @LastExecution &lt;= InsertedOn</code> and proper indexes).  </p>
  
  <p>If SQL is aware of it as a special kind of query, what mechanism does StreamInsight use to create such a standing query?  Is it something that a programmer can utilize without StreamInsight Services and so on?</p>