score:1
Accepted answer
i would do something like :
mestlist = context.estimates.groupby(e => e.name).where(g => mdateslist.all(d => g.values.select(e => e.date).contains(d))).selectmany(g => g.values).tolist();
i did not test this, so expect some errors. i hope to give you an idea to solve this problem.
good luck.
Source: stackoverflow.com
Related Query
- Using Linq to find all rows that match these conditions
- Using LINQ to Objects to find items in one collection that do not match another
- Using LINQ to find all keys from one collection that are not in another?
- Match all rows on particular day using LINQ to SQL
- Find All Rows in DataTable Where Column Value is NOT Unique Using Linq Query
- Using Linq to find all records in table that have a specific value in a related table using method syntax
- Using Linq to find only records that have all matching values in list of flags?
- Using LINQ to return a list of entities that match all values in a list passed in as a parameter
- Return list of rows that match a list of values using LINQ
- Find object that meets multiple conditions using LINQ
- Creating a datatable with only the rows that match a specific column name prefix using Linq in c#
- How to find all rows of items that have a part in common using LINQ?
- How to find all the rows that match a list of combinations in Linq/SQL?
- LINQ - Find all items in one list that aren't in another list
- LINQ Lambda - Find all ID's in one list that don't exist in another list
- Find all child controls of specific type using Enumerable.OfType<T>() or LINQ
- Check that all items of IEnumerable<T?> has the same value using LINQ
- Using LINQ to search a byte array for all subarrays that start/stop with certain byte
- Trying to get all elements after first match using linq
- Select all rows with distinct column value using LINQ
- How to find all classes that implements a generic abstract class using reflection in C#?
- Read all rows of a specific column using LINQ
- using linq query to find value that differs from previously found value
- How do I use LINQ to find 5 elements in a row that match one predicate, but where the sixth element doesn't?
- SQL to LINQ to get all records that match all values
- Using LINQ to Entity without putting all rows in memory
- Using LINQ I have a list of lists, how do I select all objects that exist in every list?
- Find an attribute that contains a ceratin string and modifying its Value in c# using LINQ
- Find all articles that contain words with linq
- linq-to-sql .All() or .Any() to find all items that match criteria
More Query from same tag
- Linq ForEach with AddRange and Contains And Select
- Sum for amounts of accounts by linq in mvc c#
- Linq groupby list matching and count
- How do I save a reordered list back to the SQL Server?
- Fill array of objects from ConcurrentDictionary
- Creating a new object in LINQ query
- LINQ query to check same date in the list?
- linq getting datarow and iterating each field based on Column
- When should I use navigation properties to query the database?
- Nhibernate 3.3.1 OpenEdge dialect generates bad like statement from Linq
- Linq paging - how to solve performance problem?
- In what scenarios is LINQ best applicable?
- How to change the path of picture into picture in GridView?
- Select parsed int, if string was parseable to int
- Is there a ODATA query to linq where expression (ODATA to Linq )
- Trimming value and text from SelectItemList using Linq
- How do I build up a LINQ => SQL / entities query (with joins) step-by-step?
- Find closest value in a list in C# with linq?
- Run a method on all objects within a collection
- How to have a where clause on an insert or an update in Linq to Sql?
- Dynamic Lambda Expression call
- Retrieving ids from a LINQ query result
- How to combine Mapping Tables classes into one class using LINQ
- How do I get distinct values on calculated columns using LINQ to SQL?
- C# where and select
- Write LINQ to parse aspx page using HtmlAgilityPack
- LINQ Query Syntax (Count Operation)
- Avoid Duplicate in LINQ
- Have an excel cell value list except when the value is null
- Search Xml file with Linq, get nodes that match to subnodes