score:2
Accepted answer
Try this query, just this query.
var results2 = this.ACCOUNT_TRANS
.Include(at => at.ACCOUNT_TABLE1)
.Include(at => at.ACCOUNT_TABLE2)
.Include(at => at.ACCOUNT_TABLE3)
.Include(at => at.ACCOUNT_TABLE4)
.Where(at => this.ACCOUNT_TRANS
.Where(a => at.COMPLETION_DATE.Value.Day == date.Day &&
a.COMPLETION_DATE.Value.Month == date.Month &&
a.COMPLETION_DATE.Value.Year == date.Year)
.Select(a => a.FK_ACCOUNT).Contains(at.FK_ACCOUNT))
.ToList();
Source: stackoverflow.com
Related Articles
- C# Linq to find a record that matches a condition, if that record is found return all related records
- Finding first index of element that matches a condition using LINQ
- LINQ return items in a List that matches any Names (string) in another list
- How to insert a record with LINQ and C# and return the Primary Key of that record
- Linq to return records that don't have a follow up record
- using linq query to find value that differs from previously found value
- How to find the next greater available record in SQL if the one that I entered is not found
- How do I do a linq query to find fields in a dataset that are present in every record of a set?
- Linq code doesn't return correct record
- Linq XML query - How do I return a node that meets a condition within its own nested nodes?
- How to see a record that has a key that matches the previous records key in XML using LinQ to XML?
- Using Linq to find the line that matches an entry
- Linq statement return error when no record found
- C#: Return any item that matches the condition
- How can I find that a record successfully deleted from Db using LINQ
- LINQ - Find all items in one list that aren't in another list
- How are people unit testing code that uses Linq to SQL
- How to return anonymous type from c# method that uses LINQ to SQL
- How to count the number of elements that match a condition with LINQ
- Using LINQ to Objects to find items in one collection that do not match another
- LINQ Lambda - Find all ID's in one list that don't exist in another list
- Find next record in a set: LINQ
- LINQ to find the closest number that is greater / less than an input
- select object which matches with my condition using linq
- linq deferred execution when using locks in methods that return IEnumerable
- Using Linq to find duplicates but get the whole record
- Is there a good source that gives an overview of linq optimizations?
- How to understand the following C# linq code of implementing the algorithm to return all combinations of k elements from n
- Using LINQ to find all keys from one collection that are not in another?
- Linq cannot find inserted record before submitchanges
- creating DynamicDataContextDriver for linqpad with c#
- From SQL database to model using linq
- Use LINQ instead of foreach
- Is there way to use extension methods to achieve below implementation in C#?
- must retrieve the list from the database
- How to convert a Dynamics Advanced Find query to LINQ?
- Creating XName.Get In For Each Loop
- Linq query to group by field1, count field2 and filter by count between values of joined collection
- Group and count items
- Fastest way Calculating Sum of Customers' Orders using Linq
- Dynamic Expression doesn't support Like
- Getting the right results from a LINQ statement
- Filtering LINQ results based on "deleted" flag
- Use linq in the where clause
- Cleanest syntax to delete a record in linqtosql
- How to execute query to select multiple attributes subject to several where clauses across two tables
- Getting a random stack overflow when calling .SubmitChanges() linq
- .Net 4.0 Unable to cast object of type 'System.Collections.Generic.List`1[ClassName]' to type 'ClassName'
- C# Linq XML pull out nodes from document
- How do I keep the lastest entry of an item from a database