Linq Inner Join with OR condition.
Ask by Norman Reedus
Updated 15 Mar 2016
when we need to apply inner join with or condition. To write query for inner join with or condition we need to use || operator in where condition 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
from ord in context.ProductOrder
where (prd.ProductName==ord.ProductName || ord.ManufacturedBy==prd.ManufacturedBy)
select new
{
ord.OrderId,
prd.ProductId,
prd.ProductName,
prd.ManufacturedBy,
ord.OrderDate,
ord.OrderQty
}).ToList();
return View();
}
}
}