Filtering data on all columns about entitygraphql

[JTravis76]

Here is my suggestion, Luke may have something different.

Add or replace a field

schema.AddField("movies",
    new { search = "" },
    (db, arg) => MovieSearch(db, arg),
    "search for movies",
    nameof(Movie));

private List<Movie> MovieSearch(DataContext context, dynamic arg)
{
    string search = (string)arg.search;

    //Filters with defaults (could use library like; LinqKit)
    System.Linq.Expressions.Expression<Func<Movie, bool>> predicate = x => x.Id > 0;

    if (!string.IsNullOrEmpty(search)) {
       // optional: bool isNum = Int32.TryParse(search, out int id);

        predicate = x => x.Name.ToLower().Contains(search.ToLower()) 
            || x.Genre.Contains(search) || x.Id.ToString() == search;
    }

    return db.Movie
        .Where(predicate)
        .ToList();
}

[lukemurray]

Above is valid. I typically do something like this

schema("movies",
                new
                {
                    search = (string)null
                },
                (db, p) => Movies
                    .WhereWhen(m => m.Name.ToLower().Contains(p.search.ToLower()) ||
                       m => m.Description.ToLower().Contains(p.search.ToLower()) ||
                       ... all the fields you want to search on ..., !string.IsNullOrEmpty(p.search)),
                "Return list of movies matching the search",
                isNullable: false);