• mwinkle.blog

    Tracking Gem in SDK Documentation


    I am always amazed when I find something cool in the SDK, it is a great source for all sorts of different details regarding WF.  The gem today originated with a customer question:

    The column 6 and 7 are EventArgTypeId and EventArgTypeId, which seem to be NULL.
    I would like to know if I can use these 2 fields (EventArgTypeId, EventArg) to track information when these events occurred. What is the use of these fields? I did not find much information on the web..

    I had a good guess what the fields were for, but one of our support engineers answered by pointing out this page in the SDK, which describes:

    The SQL tracking service in Windows Workflow Foundation lets you add tracking information about workflows and their associated activities. The SqlTrackingQuery class provides high-level access to the data that is contained in the tracking database. However, you can also use direct queries against the SQL tracking service database views for more detailed information. These views map directly to the underlying SQL tracking service table schemas.

    This then goes on to describe all of the fields inside the many tables of the SQL tracking service.  This is a great way to figure out how to write custom queries against the views and what to expect in what columns.  I've talked previously about the tracking service and databases here.


    The answer to the original email question by the way is that these two fields are written to when the event raised contains event args we want to capture, say an exception.  If we want to track specific pieces of data, my blog post talks about where we can find those.

  • mwinkle.blog

    Recent WF Content Summary


    I've been having some fun playing around with Visual Studio 2008 and the .NET Framework 3.5, and wanted to summarize some of the content I've put up on channel9 and other places.


    • The Conversation Sample remixed -- if there is one sample in the SDK to help you understand what is going on with context passing and duplex messaging, this is the sample that helped me learn it.  I had this sample reworked a little bit so that you don't have 5 console windows open.
    • Pageflow sample 1, live hosted -- watch this as pageflow is hosted "live" in the cloud.  This lets you interact with a pageflow as well as dive into the code using some tools my team has built.
    • Pageflow sample 2, live hosted as above -- this is the sample that shows how we can leverage the navigator workflow type to be in multiple paths at the same time (a parallel state machine almost).


    Channel9 Videos


    In the upcoming months, we've got more samples and content coming out about these features.  If you've got questions, keep 'em coming.

Page 1 of 1 (2 items)