Rule Engine in .net

Posted by user641812 on Programmers See other posts from Programmers or by user641812
Published on 2012-10-07T07:46:43Z Indexed on 2012/10/07 9:50 UTC
Read the original article Hit count: 358

Filed under:

I have to import data from excel to SQL database. Excel data contains various parameters and there value like P1,P1,P4,P5 etc. I have to apply business rules Like if( P1 > 100 and P1 < 200) then insert the record in database. Similarly in some cases string values are also validated. Can I have any open source rule engine that contains UI to change , add , delete the rules. Am using C# to read the excel and and insert the records

One more thing which is best approach:

Read excel first and store every record as an object in a collection, then iterate through the collection, apply business rules on every object and then insert record in the database Or Read one record from excel apply business rule and then insert record in the database. Repeat the process for whole excel.

© Programmers or respective owner

Related posts about business-rules