Home > DeveloperSection > Forums > Linq Inner Join with OR condition.
Norman Reedus
Norman Reedus

Total Post:45

Points:315
Posted on    March-15-2016 11:19 PM

 LINQ C#  LINQ  Mvc 
Ratings:


 1 Reply(s)
 225  View(s)
Rate this:
We want to Inner Join with OR condition in linq. How to Write this query please help me.


aditya kumar Patel

Total Post:242

Points:1722
Posted on    March-15-2016 11:23 PM

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();

}

}

}


Don't want to miss updates? Please click the below button!

Follow MindStick