Using Contains within Where for a list

c# dynamic-linq entity-framework-core linq sql

Question

So I am trying to retrieve results from a collection based on a property. I wanna get any results that hold that value within the list.

This is my code

I have tried with dynamic linq. It's not working

This is dynamic linq. Not working 

var list = new List<string>(2) { "11111", "22222" };


accounts = accounts.Where("@0.Contains(outerIt.PartnerCompanyId)", list);

This is not working as well

accounts = accounts .Where(a =>
               a.PartnerCompanyId.Contains(list.Any().ToString()));

Also I want the SQL to generate something like this

WHERE PartnerCompanyId IN (@gp1, @gp2, @gp3, …)

I have been getting this even there are more than 1 value in the list. I want the same number of elements in the list in the parameters.

…WHERE PartnerCompanyId IN (@gp1)

Is thre any way to accomplish this?

1
0
7/18/2019 5:35:47 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

If I have understood your question correctly, you have a list of accounts and you want to check whether the accounts contain 'list[0] OR list[1] OR list[2] ...'.

I have managed to get a similar implementation working using Dynamic Linq.

Using your code as a base, here is what I did to get the query to work:

List<string> list = new List<string>(2) { "11111", "22222" };

string argumentString = "";

for (int i = 0; i < list.Length; i++)
{
    argumentString = argumentString + "@" + i;
    argumentString = argumentString + ".Contains(outerIt.PartnerCompanyId)";

    if (i != (list.Length - 1))
    {
        argumentString = argumentString + " or ";
    }
}

var accounts = accounts.Where(argumentString, list.ToArray());

The loop will create the string: "@0.Contains(outerIt.PartnerCompanyId) or @1.Contains(outerIt.PartnerCompanyId)"

Once this string is created all you need is a simple Linq query to check all of the items in the list.

Note: you can refer to arguments in order via and array but not a list. As shown here https://stackoverflow.com/a/40885380/10253157.

I hope this helps, I had a similar project and it took me quite a while to figure it out.

1
7/19/2019 1:14:36 PM

Related Questions

How do I conduct a DLINQ Contains() on a list of items?

Try the following. You can use a combination of Where and Any to search for substring matches....var results = (from l in db.Sites where list.Where(x => 0 != x.IndexOf(l)).Any() select l.ToBusiness(l.SiteReviews)).ToList();
c# dynamic-linq
asked by JaredPar

Generic method for constructing a string Dynamic Linq query. includes strings that have been tokenized

Here's what I use to do this:...using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Linq.Expressions; using System.Collections.ObjectModel; namespace MyLibrary.Extensions { /// <summary>Defines extension methods for building and working with Expressions.</summary> public static class Expressio...
dynamic-linq linq
asked by Josh M.

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 extend this LINQ List<>.Contains to work with any Property using Reflection?

I think the underlying problem is using "Expression" you need to compile an Expression....For example in your code...Expression<Func<U, bool>> contains = u => ListContainsProperty(u, splitValues, property); ...is data and not a function. In order to use it you need to compile it....Func<U, bool> compiled = contains.Compile(); ..."compiled" variable...
dynamic-linq linq nhibernate reflection
asked by Sandesh

How to Type Cast dynamically to string while using Contains in Dynamic LINQ?

Well, you probably know that's it's not possible to use ...ToString()... in linq to entities. ...So the following question is : how can I convert other types to string....For ...numeric values..., you have ...SqlFunctions.StringConvert..., but it has only overloads for ...double?... and ...decimal?...For ...DateTime..., you may find something using...
c# dynamic-linq entity-framework linq linq-to-entities
asked by Raphaël Althaus

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

Dynamic Linq 'contains' clause without using placeholder

so I got the answer for this after tinkering for sometime. So posting the answer here.... dataContext.Table.Where("new Int[]{1,2,3,4}.Contains(id)"); ...You can use whatever datatype you need. I use reflection to find datatype and use that accordingly.
asp.net asp.net-core-mvc c# dynamic-linq linq
asked by Sujit.Warrier

using dynamic linq to filter a list of objects

I think this is what you are looking for:...var codes=new List<string>{"Code1","Code2"}; // given a list of codes you want those rows that contains all codes var result= rows.Where(r=> codes.All(c=>r.Errors.Any(e=>e.Code==c))); ...To avoid the null checking of the error list, I suggest you initialize the list in an empty constructor:...public Row(...
c# dynamic-linq linq
asked by octavioccl

Create object containing a list using Dynamic Linq Core with Entity Framework 2.0

You'd need to support a subquery on ...Warehouses.... I'll copy the relevant steps listed in ...this answer...:...add the following in ...ParseAggregate...: ...Expression ParseAggregate(Expression instance, Type elementType, string methodName, int errorPos) { // Change starts here var originalIt = it; var originalOuterIt = outerIt; // ...
c# dynamic-linq entity-framework-core list
asked by HeyJude

C#, dynamic linq error No applicable method 'Contains' exists in type 'String'

If your application needs dynamic filter capabilities, I would recommend having the caller pass a predicate. ...This allows for a separation of concerns and easier unit testing. ...Also, no need for a IF/ELSE statement when the caller passes a predicate....var predicate = new Predicate<string>(str => str.Contains("one")); var tmp = test.Select(p =...
c# dynamic-linq linq
asked by rschoenbach

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