ASP.NET Core | .NET 8.0 | Data Filtering

NuGet Packages

• https://www.nuget.org/packages/CodeEffects.Rule.Engine
• https://www.nuget.org/packages/CodeEffects.Rule.Editor

Update Code Effects assemblies to the latest versions using NuGet Manager before building and running the project.

npm Package

• https://www.npmjs.com/package/codeeffects

Right-click the /Dependencies/npm folder and select Restore Packages before building and running the project. Files from the npm "codeeffects" package are automatically copied by MSBuild to the /wwwroot folder during the build process. See the .csproj project file for details.

SqlServer Demo Database

This project uses a demo database named CodeEffectsLinqTest. Its SQL script CodeEffectsLinqTestDatabase.sql is included in the root folder of the project. To run it in any version of SqlServer:

• Open this script in your copy of SSMS.
• Replace the {Path} variable with the full path of the folder where you want the demo database files to be created.
• Execute the script in your SQL Server instance. It creates all necessary SQL objects and test data required to run this demo successfully.
• Update the DefaultConnection string in the project's appsettings.json file with your actual connection string.
• Compile and run the project.

EF Core Objects

This demo project uses EF Core for data queries. The demo database is scaffolded into the /Entities folder. The /Services/DataSources.cs class declares all dynamic menu data sources available for filters.

Remarks

The /wwwroot/index.html file declares the filter management and filter search script that uses end-points declared in the /Services/Api.cs file to save, load, update, delete, and apply data filters. Filters are stored in temporary in-memory storage using the Api.Storage dictionary. The Toolbar and HelpString are enabled by default. Default settings are configured in the /Services/Api.cs Settings constructor.

Resources

• Live demo: https://codeeffects.com/business-rules-engine-demo
• Implementation: https://codeeffects.com/decision-automation/business-rule-implementation
• How to obtain Code Effects: https://codeeffects.com/decision-automation/how-to-obtain-business-rules-engine
• Code Effects Editions: https://codeeffects.com/content/business-rules-engine-editions
• Support: https://codeeffects.com/support

© 2009 - 2026 Code Effects Software, LLC