Define an array in a dynamic linq expression

.net c# dynamic-linq

Question

How can I define an array inside of a dynamic linq expression string, that I can pass into .Where(string) ? I already tried { "val a", "val b", "val c" }, but this does not work.

Here's an example of what I want to achieve:

public class Person
{
    String Name { get; set; }
    int Age { get; set; }
}

Now I want to query an IQueryable<Person> using a completely dynamically created dynamic linq expression string, where e.g. Name is queried against a list of predefined values. The following works, but is cumbersome when there are a lot of values:

myQueryablePersons.Where("Name == \"John Doe\" || Name == \"Mr Smith\" || Name == \"CatWoman\");

What I'd like to do is something like this:

myQueryablePersons.Where("{ \"John Doe\", \"Mr Smith\", \"CatWoman\" }.Contains(Name)");

I know how this can achieved using plain C# or plain Linq, but I want to do it by only using the string passed into Where() . Is this possible at all? I already searched other answers on Stackoverflow and other sites, but could not find any answer that really fits my specific question.

1
0
4/10/2017 7:31:17 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Short answer: no

Long answer:

I got this snippet working

Int32List("40, 6, 27").Contains(40) == True

Using this hack Call function in dynamic linq

public class Int32List : List<int>
{
    public Int32List(string arr) : base(arr.Split(',').Select(a => int.Parse(a.Trim())))
    {
    }
}

(I tried params int[] but the string parser doesn't like that)

public static class ExpressionHelper
{
    //https://stackoverflow.com/questions/18313362/call-function-in-dynamic-linq
    private static bool _utilsAdded = false;
    private static void AddUtilites()
    {
        if (_utilsAdded == true)
            return;

        _utilsAdded = true;
        var type = typeof(DynamicQueryable).Assembly.GetType("System.Linq.Dynamic.ExpressionParser");

        FieldInfo field = type.GetField("predefinedTypes", BindingFlags.Static | BindingFlags.NonPublic);

        Type[] predefinedTypes = (Type[])field.GetValue(null);

        Array.Resize(ref predefinedTypes, predefinedTypes.Length + 1);
        predefinedTypes[predefinedTypes.Length - 1] = typeof(Int32List); // Your type

        field.SetValue(null, predefinedTypes);
    }
}

Just call ExpressionHelper.AddUtilities() before your first Dynamic Linq call because it caches the accessible types.

In your case it would be 

myQueryablePersons.Where("StringList(\"John Doe, Mr Smith, CatWoman\").Contains(Name)")

But your strings cant contain any commas with this setup. This is the only way I was able to make it work without using a fork

Also this page is helpful: https://github.com/kahanu/System.Linq.Dynamic/wiki/Dynamic-Expressions#operators

If you need to access the element in the array use the "it" keyword

StringList(\"John Doe, Mr Smith, CatWoman\").Any(it == "John Doe") == True
0
4/19/2019 5:02:12 PM

Related Questions

Using the System.Linq.Dynamic namespace, how to perform the following in Dynamic Linq

I tried this:...using System; using System.Linq; using System.Linq.Dynamic; using System.Collections.Generic; namespace ConsoleApplication1 { public class Customer { public string FirstName { get; set; } public string LastName { get; set; } public string Tags { get; set; } } class Program { sta...
dynamic-linq linq
asked by MattC

Does dynamic GroupBy in dynamic LINQ work with dynamic Where?

Found it, ...db.Table1.AsQueryable()... fixed it, so ...db.Table1.AsQueryable().Where("it.FieldA>10").GroupBy("it.FieldB", "it").Select("key") ... works without exception....The problem was that Microsoft Dynamic Linq library extends ...IQueryable<Table1>..., so it does not take effect on... ObjectQuery<Table1>... which is the type of ...db.Table1....
.net dynamic dynamic-linq linq linq-to-entities
asked by alpav

LINQ-to-SQL dynamic table name LINQ-to-SQL

Looks like ...this... is the link you need. ...Update.... Some details: you can use the SearchType method from the post to obtain a type using the table name and then use ...Dynamic LINQ... to write queries you like.
dynamic-linq linq-to-sql
asked by Devart

How can I utilize System.Linq.Dynamic for the LIKE operation?

Can any body tell me how can I use a LIKE operator using ...System.Linq.Dynamic...?...I need to add more than one ...LIKE... expression in my dynamic ...where query.../* var query = db.Customers. Where("CityName Like @0 or CityName Like @1", "London", "USA") */ var query = db.Customers. Where("CityName Like @0 or CityName Like @1%", "London", "USA"...
asp.net c# dynamic-linq linq
asked by Kiarash

OrderBy inside a GroupBy using dynamic LINQ?

This is a good question!...I simulated your situation by creating a class called Item....public class Item { public DateTime StartTime { get; set; } public string Name { get; set; } } ...and then created a basic list of items to do the groupby....List<Item> Items = new List<Item>() { new Item() { StartTime = DateTime.Today, Name = "item...
dynamic-linq linq linq-to-objects
asked by Bengel

How to add an AND/OR expression to the following dynamic linq expression

T is a type that may or may not have a specific property, lets say 'City'. For the types that have a property named 'City', I would like to restrict the records such that only residents of the Gotham are returned and they are sorted....public static IQueryable<T> OrderBy<T>(this IQueryable<T> source, string ordering, params object[] values) { ...
.net c# dynamic-linq expression-trees linq
asked by WPFAbsoluteNewBie

Building a Dynamic Linq Query using Equals and an Array

I'm not sure if this works in the standard Dynamic Linq library, but I just tried this is ...my open-source version..., and it works well:...var data = data.Where("GuidPrimaryKey in @0", array); ...This also works:...var data = data.Where("@0.Contains(GuidPrimaryKey)", array); ...Here is a full unit test I wrote to confirm this:...[TestMethod] publ...
c# dynamic-linq linq where
asked by Nathan A

How to use linq extensions with Func parameters in Dynamic Linq expressions?

Extending the dynamic library is certainly an option as already suggested. an alternative given the ...Where... in Dynamic Linq returns an Iqueryable... public static class DynamicQueryable { public static IQueryable<T> Where<T>(this IQueryable<T> source, string predicate, params object[] values) { return (IQueryable<T>) Where((IQueryable) sou...
dynamic-linq extension-methods linq
asked by phil soady

System.Linq.Dynamic.Core vs System.Linq.Dynamic

System.Linq.Dynamic.Core... is more up to date and has more functionality and does also support NET Core / NETStandard (besides net35, net40 and net45 and up)...SelectMany... is indeed supported....For more information see the ...github... page and browse the examples, unit-tests and help page....Note: I'm the maintainer from this project.
dynamic-linq
asked by Stef Heyenrath

System.Linq.Dynamic: How to declare an array for .Contains?

When using ...System.Linq.Dynamic.Core... you can don something like:...var intList = new[] { 2, 3, 4 }; var results = myTable.Where("@0.Contains(outerIt.abc)", intList);
c# dynamic-linq entity-framework-6
asked by Stef Heyenrath

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow