How to write LINQ query for Inner Join with and condition?
Answer / Deepak Kumar Shivhare
To perform an inner join with a `AND` condition in LINQ, you can use the `Where` clause. Here is an example: n```csharpnvar result = employees1.Join(employees2, e1 => e1.Id, e2 => e2.Id, (e1, e2) => new { Id = e1.Id, Name = e1.Name }) .Where(row => row.Name == "John" && row.Salary > 50000);n```
| Is This Answer Correct ? | 0 Yes | 0 No |
how LINQ with databases can be used?
What is the basic syntax of a linq query in visual basic as well as in c#?
What is the use of firstordefault in linq?
What is difference between linq and sql query?
What is difference between ADO.NET and LINQ to SQL?
What is first in linq?
What is anonymous method?
What is the difference between First() and Single() extension methods in LINQ?
1 Answers TryTechnicals Pvt Ltd,
What are important features linq?
What are aggregate operators?
What is meant by linq in c#?
Which classs extension methods are used in linq to sql?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)