Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to write LINQ query for Inner Join with and condition?



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

Post New Answer

More LINQ Language-Integrated Query Interview Questions

Is not supported in linq to entities?

1 Answers  


Does entity framework use linq?

1 Answers  


How can you create Expression Trees?

1 Answers  


What is where clause and let clause?

1 Answers  


What is the difference between FirstOrDefault() and SingleOrDefault() extension method in LINQ ?

1 Answers  


Explain what is the purpose of linq providers in linq?

1 Answers  


Explain how standard query operators useful in LINQ?

1 Answers  


What is the linq in c#?

1 Answers  


What does linq?

1 Answers  


Explain what is lambda expressions in linq?

1 Answers  


What are the three main components of linq or language integrated query?

1 Answers  


What is difference between LINQ and Stored Procedures?

1 Answers  


Categories