AdaptiveSearch 1.0.6

AdaptiveSearch

AdaptiveSearch is a lightweight and powerful library for dynamically building LINQ filtering expressions in C#. It supports dynamic filtering for strings, numbers, and DateTime properties, making it ideal for advanced search features, APIs, and reporting systems.

Features

• String Filtering: Supports Equal, NotEqual, StartsWith, EndsWith, Contains, and their negative counterparts.
• Numeric Filtering: Compare values using Equal, NotEqual, GreaterThan, LessThan, GreaterThanOrEqual, and LessThanOrEqual.
• DateTime Filtering: Dynamically compare dates using Equal, NotEqual, GreaterThan, LessThan, and similar conditions.
• TimeSpan Filtering: Dynamically compare dates using Equal, NotEqual, GreaterThan, LessThan, and similar conditions.
• IntegerFilter Filtering: Dynamically compare dates using Equal, NotEqual, GreaterThan, LessThan, and similar conditions.
• DoubleFilter Filtering: Dynamically compare dates using Equal, NotEqual, GreaterThan, LessThan, and similar conditions.
• FloatFilter Filtering: Dynamically compare dates using Equal, NotEqual, GreaterThan, LessThan, and similar conditions.
• DecimalFilter Filtering: Dynamically compare dates using Equal, NotEqual, GreaterThan, LessThan, and similar conditions.
• LongFilter Filtering: Dynamically compare dates using Equal, NotEqual, GreaterThan, LessThan, and similar conditions.
• ShortFilter Filtering: Dynamically compare dates using Equal, NotEqual, GreaterThan, LessThan, and similar conditions.
• Type-Safe: Avoids magic strings with lambda expressions for property selection.
• Dynamic and Extensible: Easily integrate and combine filters for complex queries.
• LINQ Compatible: Seamlessly integrates with LINQ-to-Objects, Entity Framework, and other query providers.

Installation

Install AdaptiveSearch via NuGet:

dotnet add package AdaptiveSearch

Usage

1. Single Filter

var stringFilter = new StringFilter
{
    StartsWith = "John",
    NotContains = "Doe"
};

var data = new List<Person>
{
    new Person { Name = "John Smith" },
    new Person { Name = "Johnny Doe" },
    new Person { Name = "Jane Doe" }
}.AsQueryable();

var result = data.AdaptiveSearch(x => x.Name, filter).ToList();

foreach (var person in result)
{
    Console.WriteLine(person.Name);
}

Output:

John Smith

1. Apply filter to multi property

var filter = new StringFilter { NotStartsWith = "S" };

var data = new List<Person>
{
  new() { Name = "John Doe",CreatedAt=new DateTime(2023,1,1),IsActive=true,Age=20 ,JobTitle="Software Engineer",Specialty="IT" },
  new() { Name = "Johnny",CreatedAt=new DateTime(2025,1,1),IsActive=true,Age=25,JobTitle="Software Tester",Specialty="IT" },
  new() { Name = "Jane",CreatedAt=new DateTime(2024,1,1),IsActive=false,Age=30,JobTitle="HR Manager",Specialty="HR" },
  new() {Name ="John",CreatedAt=new DateTime(2023,1,1),IsActive=true,Age=21,JobTitle="Software Qc",Specialty="IT" },
  new(){ Name="Tom",CreatedAt=new DateTime(2023,1,1),IsActive=true,Age=20,JobTitle="Software Engineer",Specialty="IT" },
  new() { Name = "Sally", CreatedAt = new DateTime(2024, 1, 1), IsActive = false, Age = 30, JobTitle = "HR Manager", Specialty = "HR" }
}.AsQueryable();

var result1 = data.AdaptiveSearch(filter, ApplyType.And)
          .ApplyTo(c => c.Name)
          .ApplyTo(y => y.JobTitle)
          .ApplyTo(t => t.Specialty)
          .ToList(); // result is only Jane

var result1 = data.AdaptiveSearch(filter, ApplyType.Or)
          .ApplyTo(c => c.Name)
          .ApplyTo(y => y.JobTitle)
          .ApplyTo(t => t.Specialty)
          .ToList(); // Return all data as all of them passed

2. Multi Filter

public class Filters 
{
    public StringFilter? Name { get; set; }
    public IntegerFilter? Age { get; set; }
    public DateTimeFilter? CreatedAt { get; set; }
    public BooleanFilter? IsActive { get; set; }
    }

/// generate filters instance
var filter = new Filters
{
    Name = new() { StartsWith = "John" },
    Age = new() { Equal = 20 },
    IsActive = new() { Equal = true },
    CreatedAt = new()
    {
        Equal = new DateTime(2023, 1, 1)
    }
};

var data = new List<Person>
{
     new() { Name = "John Doe",CreatedAt=new DateTime(2023,1,1),IsActive=true,Age=20 },
     new() { Name = "Johnny",CreatedAt=new DateTime(2025,1,1),IsActive=true,Age=25 },
     new() { Name = "Jane",CreatedAt=new DateTime(2024,1,1),IsActive=false,Age=30 },
     new() {Name ="John",CreatedAt=new DateTime(2023,1,1),IsActive=true,Age=21 },
     new(){ Name="Tom",CreatedAt=new DateTime(2023,1,1),IsActive=true,Age=20 }
}.AsQueryable();

var result = data.AdaptiveSearch(filter).ToList();

foreach (var person in result)
{
    Console.WriteLine(person.Name);
}

Output:

John Doe

2. Apply all filters

By default calling AdaptiveSearch apply only properties that implement IAdaptiveFilter if you need equal operator to be applied to other types you need to pass applyAllProperties parameter as true

public class Filters 
{
    public string? Name { get; set; }
    }

/// generate filters instance
var filter = new Filters
{
    Name = "John",
};

var data = new List<Person>
{
     new() { Name = "John Doe",CreatedAt=new DateTime(2023,1,1),IsActive=true,Age=20 },
     new() { Name = "Johnny",CreatedAt=new DateTime(2025,1,1),IsActive=true,Age=25 },
     new() { Name = "Jane",CreatedAt=new DateTime(2024,1,1),IsActive=false,Age=30 },
     new() {Name ="John",CreatedAt=new DateTime(2023,1,1),IsActive=true,Age=21 },
     new(){ Name="Tom",CreatedAt=new DateTime(2023,1,1),IsActive=true,Age=20 }
}.AsQueryable();

var result = data.AdaptiveSearch(filter,true).ToList();

foreach (var person in result)
{
    Console.WriteLine(person.Name);
}

Output:

John

Skip and take

you can also add skip and take properties:

[Skip]
public int Skip { get; set; }
[Take]
public int Take { get; set; } = 20;
/// Paging is not applied by default
/// You can apply paging either by calling ApplyPaging() or pass ApplyPaging as and argument to adaptive search

Currently we apply skip then take at the end of query

API Documentation

StringFilter

ComparableFilter<T>

note you can use this with any type delivered from IComparable

BooleanFilter

EnumFilter

ListFilter

Benefits

• Flexible: Supports dynamic queries for strings, numbers, and dates.
• Type-Safe: Leverages lambda expressions for strong typing.
• Extensible: Easily combine filters for complex search scenarios.
• Framework-Compatible: Works with LINQ and Entity Framework.

Contributing

Contributions are welcome! If you find an issue or want to add a feature, please open an issue or submit a pull request.

License

This project is licensed under the MIT License.