I'm developing BPM (business process management system) in asp.net C# and workflow foundation 4.5.
bpm systems usually have allot of process and each process has many forms. i made that easy by using JSON data so i will store all forms data in one table, so there is no need to create many tables for each process but this approach will effect the process searching service (advanced search for process business intelligence and business analysis ), so im thinking to use MongoDb to store that Forms' data and search in it. is that will be a good approach and practice?
another question is using windows workflow foundation will be a good idea, i didn't see a lot of systems using it lately