score:0
Accepted answer
var solutionitems = solutioninforesponse
.items
.where(item => solutioninforesponse
.groups
.where(group => productgroupids.contains(group.groupid))
.selectmany(group => group.items)
.any(groupitem => groupitem.id == item.id))
.tolist();
Source: stackoverflow.com
Related Query
- Compare Two List and return Data from first list based on Ids in Linq C#
- compare two list and return not matching items using linq
- How can I compare two sets of data in linq and return the common data?
- Is a full list returned first and then filtered when using linq to sql to filter data from a database or just the filtered list?
- C# Linq how to compare two strings and report the first different char which is itself different from '?' wildcard
- Compare two list in C# and reject or select the child list based on conditions using LINQ or foreach
- LINQ: Compare two list based on their properties and return items that match certain conditions
- How to compare two list and get the differences from first list?
- Linq query to join two tables and return object from first table - PagedList used
- How to compare two List content data and return mismatch value?
- Combine two list using Linq and add data as needed from different tables
- How to use Linq on IList, to compare first value and second value present on the list based on some conditions.?
- select data from first table based on two forigen key in another table using linq
- Using Linq and C#, trying to get two lists from a list of master items grouped by two inner lists
- Compare id's of objects in two lists and get the list of objects that includes objects with ids occurring in both of them
- C# compare two Lists by one Property and change value of first List
- Combine Two Properties From Entity In List And Flatten It With Linq
- How to return list of items from linq to sql query and call it in a console application
- How to write a generic LINQ query for filtering of data based on first name middle name and last name
- How do I compare two lists where one list starts with the other, and only return the "overhang" elements?
- Compare 2 generic lists and return missing values from list b
- Joining Two list using LINQ Query and displaying only relevant data
- Create a entity framework LINQ group join query to return a subset of properties from DTO and a list of another DTO, ASP.net core
- combine two list and linq query to order by two different fields from different lists
- Compare all items from List and return in new list
- Linq to CSV : Convert data to .CSV file and return file from an action without saving file on the server
- Using Linq how do get a list of users and their last login from two tables
- LINQ - Return data from list 2 occurrences
- Group and Select First From Two Tables Linq
- How to get items from SQL, using linq to sql, where Date is from today to 30 days ahead and return as a list
More Query from same tag
- how to store values in tempdata mvc4?
- Find gap in datetime range with Linq to sql in vb.net
- Selecting specific columns from GroupBy list
- Using LINQ to construct a list C#
- Select last wrong item from the list
- Filter repeated (by integer) items in a List<Tuple<int,Image>> and create a Dictionary<int, List<Image>> C#
- Why is there no compiler warning for LINQ queries that are not assigned to variables
- LINQ To Entities and how to make this simple query work
- Read cdata and html inside a tag by linqToXml
- Cannot implicitly convert type 'System.Linq.IQueryable<int>' to 'int?'
- Calling SubmitChanges on DataContext does not update database
- How could I modify this query to get what I want - Calendar dates
- Linq join query from 2 different entity frameworks
- The server response was: 5.7.0 Authentication Required. Learn more at
- Creating an array then selecting based on it
- Using LINQ, how can I limit rows retrieved depending on a child table property?
- What is the LINQ to XML equivalent for this XPath
- Linq To Entities - how to filter on child entities
- LINQ to SQL: How to check if any item in one entity collection exists in another entity collection?
- Select IEnumerable<object> from IEnumerable<IEnumerable<object>> linq
- LINQ - How to get data from multiple tables
- Getting the element missing in a second list of different type
- Linq using the index from a select many query
- How to use Where (in LINQ) to get a specific information
- How to compare MD5 hashes saved as byte[] with Linq + entity framework?
- EF5 code first migrations navigating inside nested hierarchy
- EF Core 3.0 .Include() chain taking ~5-10x longer than 2.2
- Try-Catch with fluent expressions
- lambda expression for OR condition in Linq to entity
- Select items from two custom lists based on multiple join criteria