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();
}
}
}
Join MindStick Community
You need to log in or register to vote on answers or questions.
We use cookies to ensure you have the best browsing experience on our website. By using our site, you
acknowledge that you have read and understood our
Cookie Policy &
Privacy Policy.
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();
}
}
}