Linq Inner Join with OR condition.
2208
15-Mar-2016
We want to Inner Join with OR condition in linq. How to Write this query please help me.
Anonymous User
15-Mar-2016when 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();
}
}
}