Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

Linq Inner Join with OR condition.

Norman Reedus 2284 15 Mar 2016

We want to Inner Join with OR condition in linq. How to Write this query please help me.

Norman Reedus

Other

1 Answers

Anonymous User 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();
        }
    }
}

MindStick Training