\nThe StreamInsight object model seems fairly complex at first. There's a series of choices as you progress down the development path which make things appear more complex than they are. One thing to keep in mind is, no matter how you populate it, there is only one object model that encapsulates the metadata.\n<\/p>\n
\nOne way to get a handle of the model is to look into the metadata. The easiest way to do this is to use SQL Server CE to register your metadata. If you don't specify SQL Server CE at runtime, the default behavior is to store the information in memory, making it more difficult to see.\n<\/p>\n
\nNote that the included standalone server host application, StreamInsight.exe, can use either SQL Server CE or inprocess metadata based on the presence of a configuration file setting.\n<\/p>\n
\nTo use SQL Server CE, use the Explicit Server Development Model (StreamInsight Books Online has nice information comparing and contrasting the development models), but instead of using:\n<\/p>\n
\nServer s = Server.Create();\n<\/p>\n
\nthese additional lines will use SQL Server CE.\n<\/p>\n
\nSqlCeMetadataProviderConfiguration config = new SqlCeMetadataProviderConfiguration();
\nconfig.DataSource = "MyMetabase.sdf"; \/\/ these should be in a config file
\nconfig.CreateDataSourceIfMissing = true;
\nServer s = Server.Create(config);\n<\/p>\n
\nWhen you register the rest of the StreamInsight objects (Application, EventTypes, Adapters, etc), the metadata will be written into the CE database. Because the database information does not disappear when the application completes (unless you specifically delete it), you can browse the StreamInsight metadata afterwards.\n<\/p>\n
\nYou can also go a step further than that. Because the metadata is stored in the database, its possible to pre-provision the database with the registration information by running the program once. With a pre-provisioned database your program would consist of creating the Server (as in the code above) and pulling out the configuration like this:\n<\/p>\n
\nApplication a = s.Applications["TheApplication"]; \/\/ the Application name from original run
\nif (a == null)
\n throw new Exception("Application Metadata Not Found");\n<\/p>\n
\nIt's possible to run your entire application this way, because all of the metadata you provided has been stored with full fidelity in the CE database. If you run, say, the sample ExplicitServer app this way, you need only fetch the Application and Query objects and start your Query. The other objects (Adapters, EventTypes, Bindings, Streams, and QueryTemplate) are already in place from the database where you populated the metadata originally.<\/p>\n","protected":false},"excerpt":{"rendered":"
The StreamInsight object model seems fairly complex at first. There's a series of choices as you progress down the development path which make things appear more complex than they are. One thing to keep in mind is, no matter how you populate it, there is only one object model that encapsulates the metadata. One way […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30,39],"tags":[],"class_list":["post-615","post","type-post","status-publish","format-standard","hentry","category-sql-server-2008-r2","category-streaminsight"],"yoast_head":"\n