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: 357

Filed under:

business-rules

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.

Related posts about business-rules

BizTalk Business Rules Engine - Repeating Elements Question

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello I'm trying to create what I think should be a relatively simple business rule to operate over repeating elements in an XML schema. Consider the following XML snippet (this is simplified with namespaces removed, for readability): <Root> <AllAccounts> <Account id="1" currentPayment="10… >>> More
Configure EnableTransaction and IsolationLevel property in Business Rules for Dynamic Send Port

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Why do you want to add these properties to the BRE..?? There is a lot of performance issue when using WCF adapters with Dynamic Send Port. Please check the below link for more info. http://blogs.msdn.com/mdoctor/archive/2009/12/18/performance-tip-when-using-wcf-custom-with-dynamic-send-ports-and-custom-bindings-on-biztalk-server-2009… >>> More
Must-Have Business Rules for Today's Economy

as seen on Internet.com - Search for 'Internet.com'
Rules keep the business world moving forward so today we share Michelle LaBrosse's top ten rules for a successful business. >>> More
How do you keep your business rules DRY?

as seen on Stack Overflow - Search for 'Stack Overflow'
I periodically ponder how to best design an application whose every business rule exists in just a single location. (While I know there is no proverbial “best way” and that designs are situational, people must have a leaning toward one practice or another.) I work for a shop where they prefer to… >>> More
TDD - testing business rules/validation in ASP.NET MVC

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am using the sharp architecture so I can easily use mocks etc. in my unit tests and/or during TDD. I have quite complicated business rules and would like to test them at the controller level. I am just wondering how other people do this? For me validation tests business rules at three levels: (1)… >>> More

Developer IT