score:3
how about this:
from t1 in table1
from t2 in table2
where (t1.TB1Key1 == t2.TB2Key1 || t1.TB1Key2 == t2.TB2Key2)
select new { t1, t2 }
Source: stackoverflow.com
Related Query
- Entity Framework - How do I join with an OR condition on several keys
- How to query many-to-many relationship with 'AND' condition using LINQ and Entity Framework
- how to use "not equal to" in where condition using linq with entity framework
- IQueryable<T> Join with Where Condition Entity Framework 6.0
- In Entity Framework Core, how can I query data on joined tables with a condition at DB level (not local LINQ)?
- How to convert a SQL with multiple left joins to an Entity Framework LINQ statement using Include methods (No Join methods)?
- How to Lazy Load child object with string primary key in Entity Framework Code First?
- How can I perform this type of JOIN in Entity framework with LINQ
- How to do join with objects in Entity Framework
- How can I do a JOIN with Entity Framework
- How sum a column in Entity Framework using linq and join it with another table
- How to achieve multiple tables left join in Entity Framework with proper json response
- How can i join Master-Detail-Detail Tables with Linq in Entity Framework
- How to Update multiple tables with foreign keys using LINQ expression ASP.NET MVC Entity Framework
- how to use entity framework to group by date not date with time
- Is an outer join possible with Linq to Entity Framework
- How to avoid memory overflow when querying large datasets with Entity Framework and LINQ
- How can I extract a list of Tuple from a specific table with Entity Framework / LINQ?
- LINQ table join with entity Framework
- How can i write SQL update query with where clause in Entity Framework in C#
- How can I use Entity Framework on an object graph past a depth of 2 with MySQL Connector / NET?
- How to do a left outer join in Entity Framework without using the query syntax?
- How to include sorted navigation properties with Entity Framework
- Entity Framework Linq SelectMany with condition
- How do I extend ADO.NET Entity Framework objects with partial classes?
- Entity Framework gets progressively slow with extra join added even though SQL generated is fast
- How to solve the greatest-n-per-group problem with Entity Framework (Core)?
- How can I implement a LEFT OUTER JOIN in LINQ using lambda syntax on Entity Framework Core 2.0?
- How to use DbGeography.Filter in Linq with Entity Framework 5?
- Why is Entity Framework .ToList() with .Include very slow and how can I speed it up?
More Query from same tag
- Switching from LinqToXYZ to LinqToObjects
- Fetching data from 50+ tables using Linq-to-Nhibernate
- Linq Query to group Parent and respective child rentities
- custom icomparer error - The type arguments cannot be inferred from the usage
- Calling the property names of a dynamic property "ints": can't call property
- Showing LINQ Results on the page
- How to Filter a 2-dimensional List?
- select multiple objects from list based on values from another list
- Unique ID Validation Query
- Linq filter List<string> where it contains a string value from another List<string>
- how can i order multiple digit string integers numerically and by shortest first? C#
- Is Dynamic LINQ still in use and suitable for narrowing-down search results?
- Execute method within linq
- Convert Dictionary<String,Int> to Dictionary<String,SomeEnum> using LINQ?
- C# LINQ accessing another property within a LINQ SELECT statement (method)
- C# linq Perform join with default value if join returns null
- Cosmos Db linq query for child item not working
- How to align a list of objects according to their string properties?
- How do I return a new object from a mocked repository using a LINQ Expression?
- How to order a nested Linq object via orderBy
- Split list into two lists with single LINQ statement
- How to replace all non-valid characters in string?
- How to convert a list of ints to a string array in Linq?
- Error CS0103 when a variable is actually in the right scope
- LINQ group items into lists in anonymous type, with duplicates
- Turning foreach loops to Linq
- C# Does chaining multiple LINQ method calls enumerate a collection multiple times?
- How to get the sum of multiple columns of a datatable in c#
- LINQ - get total count of values from nested list
- Split CSV files with header c#
