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

how LINQ with databases can be used?

1 Answers  


What is the basic syntax of a linq query in visual basic as well as in c#?

1 Answers  


What is the use of firstordefault in linq?

1 Answers  


What is difference between linq and sql query?

1 Answers  


What is difference between ADO.NET and LINQ to SQL?

1 Answers  


What is first in linq?

1 Answers  


What is anonymous method?

1 Answers  


What is the difference between First() and Single() extension methods in LINQ?

1 Answers   TryTechnicals Pvt Ltd,


What are important features linq?

1 Answers  


What are aggregate operators?

1 Answers  


What is meant by linq in c#?

1 Answers  


Which classs extension methods are used in linq to sql?

1 Answers  


Categories