Linq Inner Join with AND condition

Total Post:45

Points:315
C#  LINQ  Mvc 
 854  View(s)
Ratings:
Rate this:
We want to Inner Join with AND condition. How to write  Inner Join with AND condition in linq query.Please Help me.
  1. Post:279

    Points:1987
    Re: Linq Inner Join with AND condition

    Wen we  need to apply inner join with and condition. To write query for inner join with and condition we need to make two anonymous types (one for left table and one for right table) by using new keyword and compare both the anonymous types as shown below:

     

    using System;

    using System.Collections.Generic;

    using System.Linq;

    using System.Web;

    using System.Web.Mvc;

    namespace ForumMVC.Controllers

    {

    public class HomeController : Controller

    {

    forumEntities context = new forumEntities();

    public ActionResult Index()

    {

    var q = (from prd in context.ProductStock

    join ord in context.ProductOrder

    on new { a = prd.ProductName,prd.ManufacturedBy } equals new { a = ord.ProductName,ord.ManufacturedBy }

    select new

    {

    ord.OrderId,

    prd.ProductId,

    prd.ProductName,

    prd.ManufacturedBy,

    ord.OrderDate,

    ord.OrderQty

    }).ToList();

    return View();

    }

    }

    }

      Modified On Apr-11-2018 02:16:07 AM

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!