locked
In which situations can promoted properties of an instance can be used. RRS feed

  • Question

  • Hi,

    In which situations can promoted properties of an  instance can be used.

    I have created a workflow for leave approval. when a person applies for leave a new workflow instance is created. The instance then waits for approval hence persists in database. The workflow is defined through a workflow service(XAMLX). How can my application benefit from promoted properties of an instance in this scenario.

    Are promoted properties meant to avoid custom database to store business data.

    Thanks,

    Neha

    Tuesday, March 1, 2011 12:04 PM

Answers

  • Hi, Neha

    Usually, we promote properties for easy querying when workflow instance is persisted and unloaded.
    If there are many properties or object need be promoted, we'd better create a persistence participant to store these business data into another database/table.

    For more about persistence participant, see:
    http://msdn.microsoft.com/en-us/library/ee473464.aspx

    Hope this helps.
    Regards
    MSDN Community Support
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    This posting is provided "AS IS" with no warranties, and confers no rights. My Blog: http://xhinker.com
    Microsoft Windows Workflow Foundation 4.0 Cookbook
    • Marked as answer by NehaGupta Monday, March 7, 2011 4:54 AM
    Monday, March 7, 2011 2:03 AM

All replies

  • Hi! I think that Promoted Properties are meant to query the state of an unloaded (persisted) workflow.. 

    you could use it, but i think that the business data should be uncoupled from the workflow..

    another downside of using Promoted Properties is that default schema is using Sql Variant for the promoted properties..

    good luck!


    Pablo Rotondo http://www.datapayasadas.com.ar
    Tuesday, March 1, 2011 5:41 PM
  • Hi,

    From design prospective, i agree that business data should be uncoupled from the workflow.

    But in which situations can an application benefit from promoted properties.

    Thanks

    Neha

    Wednesday, March 2, 2011 5:17 AM
  • Hi,

    Has somebody tried using promoted properties in real enterprise application scenario. What was the scenario. What advantage did promoted properties provided.

     

    Thanks

    Suchi

    Wednesday, March 2, 2011 5:19 AM
  • Hi, Neha

    Usually, we promote properties for easy querying when workflow instance is persisted and unloaded.
    If there are many properties or object need be promoted, we'd better create a persistence participant to store these business data into another database/table.

    For more about persistence participant, see:
    http://msdn.microsoft.com/en-us/library/ee473464.aspx

    Hope this helps.
    Regards
    MSDN Community Support
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    This posting is provided "AS IS" with no warranties, and confers no rights. My Blog: http://xhinker.com
    Microsoft Windows Workflow Foundation 4.0 Cookbook
    • Marked as answer by NehaGupta Monday, March 7, 2011 4:54 AM
    Monday, March 7, 2011 2:03 AM