Tip Com.RickSeven.FormulaEngine.Core - A powerful .NET library for formula evaluation

[rickseven]

A powerful and flexible formula evaluation engine using Roslyn Scripting with dynamic runtime context. Ideal for scenarios where business logic needs to be defined at runtime through C# expressions or formulas.

Features

• Evaluate C# expressions dynamically at runtime
• Support for nested objects and complex data structures
• JSON context support for easy integration
• Rich set of operations:
  • Numeric operations (arithmetic, Math functions)
  • String manipulation and formatting
  • DateTime operations
  • Logical operations and conditionals
  • Collection handling with indexing
• Culture-specific formatting support
• Comprehensive error handling
• No external dependencies other than Roslyn and BCL

Installation

Install via NuGet:

dotnet add package Com.RickSeven.FormulaEngine.Core --version 1.0.0

Usage Examples

Basic Operations

var context = new Dictionary<string, object>
{
    { "revenue", 10000 },
    { "cost", 7000 },
    { "margin", 0.3 },
    { "desc", "Result is: " }
};

string formula = "desc + ((revenue - cost) * margin).ToString()";

var engine = new FormulaEngine();
var result = engine.Evaluate(formula, context);

// Output: "Result is: 900"
Console.WriteLine(result);

Math Functions

var context = new Dictionary<string, object>
{
    { "baseValue", 2.0 },
    { "exponent", 3.0 }
};

string formula = "Math.Pow(baseValue, exponent)";

var engine = new FormulaEngine();
var result = engine.Evaluate(formula, context);

// Output: 8.0
Console.WriteLine(result);

Culture-Specific Formatting

var jsonContext = @"{
    ""revenue"": 1000.50,
    ""cost"": 750.25,
    ""taxRate"": 0.2,
    ""description"": ""Profit calculation: ""
}";

var formula = @"description + ((revenue - cost) * (1 - taxRate)).ToString(""C2"", new System.Globalization.CultureInfo(""id-ID""))";

var engine = new FormulaEngine();
var result = engine.Evaluate(formula, jsonContext);

// Output: Profit calculation: Rp200,20
Console.WriteLine(result);

Notes

• The engine supports full C# expression syntax
• Nested objects can be accessed using dot notation
• Array elements can be accessed using index notation
• JSON context is automatically parsed and made available to formulas
• Culture-specific formatting is supported through standard .NET formatting
• Error handling is provided through FormulaEvaluationException
  

 

[Skydiver]

Nuget Package doesn't give a reference to source code or where to report issues. Caveat emptor.

Doesn't seem to be related to rickseven - Overview

 

[rickseven]

Nuget Package doesn't give a reference to source code or where to report issues. Caveat emptor.

Doesn't seem to be related to rickseven - Overview

Thank you for your feedback.

I appreciate you pointing that out. I'll be adding a contact email in the package metadata so users can report issues more easily.

 

[Skydiver]

Out of curiosity, why the Java naming convention for this package?

 

[rickseven]

Out of curiosity, why the Java naming convention for this package?

The naming convention using a reversed domain style (Com.RickSeven.FormulaEngine.Core) is inspired by the common practice in the Java ecosystem to ensure globally unique namespaces and avoid conflicts. While this pattern is not mandatory in .NET or NuGet packages, it’s sometimes adopted for consistency and clarity, especially if the library has roots or influences from cross-platform development or simply to maintain uniqueness across projects.