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 AND condition

Norman Reedus 1995 15 Mar 2016

We want to Inner Join with AND condition. How to write Inner Join with AND condition in linq query.Please Help me.

Norman Reedus

Other

1 Answers

Anonymous User 15 Mar 2016

Wen we need to apply inner join with and condition. To write query for inner join with and condition we need to make two anonymous types (one for left table and one for right table) by using new keyword and compare both the anonymous types 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
                    join ord in context.ProductOrder
                    on new { a = prd.ProductName,prd.ManufacturedBy } equals new { a = ord.ProductName,ord.ManufacturedBy }
                    select new
                    {
                        ord.OrderId,
                        prd.ProductId,
                        prd.ProductName,
                        prd.ManufacturedBy,
                        ord.OrderDate,
                        ord.OrderQty
                    }).ToList();
            return View();
        }
    }
}

advertising