Hi,Can anybody tell me how to write query to fetch one column value from a table comparing other two column values in that table with other two tables in an MVC Controller?
In my MVC view I need to show 5 column values from one table say POCList and the sixth value(localstock) to be displayed should be fetched from second table say StockMaster which is having matching values in 3rd table Inventorymaster.
public ActionResult GeneratePOC()
{
var generatepoc = db.POCLists.Include(p => p.EmployeeMaster).Include(p => p.POCMaster).Include(p => p.QuoteMaster).Include(p=>p.SKUMaster);
return View(generatepoc.ToList());
}
Any help will be appreciated..Its urget...Thanks in advance.