how to filter with array/list via dynamic linq

.net dynamic-linq

Question

Hell all!

I tried all known variations to filter with Contains, but so far no luck.

METHOD #1

ret = ret.Where("CaseID.Contains(@0)", {15, 16, 17})

Gets the following error:

System.Linq.Dynamic.ParseException: 'No applicable method 'Contains' exists in type 'Int32?''

METHOD #2

ret.Where("@0.Contains(outerIt.CaseID)", {15, 16, 17})

Bring the following error:

System.Linq.Dynamic.ParseException: 'No 'it' is in scope'

So, how can i filter by a list or array?

I'm using the latest System.Linq.Dynamic library in nuget 1.0.7

1
1
8/28/2017 1:15:03 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

the following will work, but you must to ensure that the CaseID and the array values have the same Type.

ret.Where("@0.Any(outerIt.CaseID=it)", array)

3
8/29/2017 10:15:01 AM

Popular Answer

Not quite sure if I understand your question right. But do you mean something like this? This is solved with a Lambda-Expression.

var listA = new[] {1, 2, 3, 5, 8};
var listB = new[] {1, 3, 5, 7, 11};
var res = listA.Where(itemA => listB.Contains(itemA));
// res = {1,3,5}
CanereCurrere

Related Questions

How can I make Lambda in LINQ filter for dynamic LINQ?

Example-I have a person class ...Public Class Person Private _fname As String Public Property Fname() As String Get Return _fname End Get Set(ByVal value As String) _fname = value End Set End Property Private _lname As String Public Property Lname() As String Get Return _lname End Get Set(ByVal v...
dynamic-linq linq-to-objects vb.net
asked by Eric

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

Using Linq.Dynamic where method with a dynamic list gives error

Dynamic LINQ does not work with ...dynamic... type. LINQ to Objects would work, but since you are receiving the filter as ...string..., it's not applicable....The workaround is to use temporary anonymous projection before applying the dynamic ...Where... and then selecting back the original object:...var filtereddata = result .Select(x => new {...
c# dynamic dynamic-linq linq
asked by Ivan Stoev

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

using dynamic linq to filter a list of objects

I have two class like this ...public class Error{ public string Code{get;set;} public string Description{get;set;} } public class Row{ public List<Error> Errors {get;set;} .... } ...So, for each row, can exists more errors. It's possible using dynamic linq select the row that have an error code(for example Code1)?...So, if the row cont...
c# dynamic-linq linq
asked by user3401335

How to use dynamic Linq with List<dynamic> object

Finally I got a working solution! It may not be the most efficient but it works for my needs and allows me to keep the dynamic nature I was hoping to retain. The solution was to drop Linq entirely and use a good old for-each loop. The Important part was the IDictionary which allowed me to search each row for the key value pair. This is the same fun...
.net c# dynamic-linq linq
asked by Brian S

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