I have a project where I need to loop through over 500,000 records in a database from one table and make decisions based upon what I find.

Obviously I think I need a sequential workflow but the question is where to begin What kind of activities would you recommend I use in this case

Thanks for all your help.

Re: Windows Workflow Foundation Data Processing

Pravin Indurkar - MSFT


Can you give some more information about what you wan to achieve. As such there are no data base activities so Custom Activity will be a way to go. What are you considerations Is performance a big concern Do you want to open a Database Cusrosr and do a forward only read Is this a long running workflow or do you want to process all 500,000 in a batch at once


Pravin Indurkar