How to join three tables using join in entity framework?

How to join three tables in entity framework, i have two different models. My logic is as follows i am bit stuck.

public class ExtractionViewModel
{
public DateTime Year { get; set; }
public int Week { get; set; }
public DateTime Day { get; set; }
public string Model { get; set; }
}
public partial class WeekDetail: IEntity
{
public System.Guid WeekId { get; set; }
public int WeekNum { get; set; }
public string Year { get; set; }
public Nullable<int> ScheduleTotal { get; set; }
public System.DateTime CreatedDate { get; set; }
public string CreatedBy { get; set; }
public System.DateTime ModifiedDate { get; set; }
public string ModifiedBy { get; set; }
public bool InActive { get; set; }
public IList GetExtractionViewModels()
{
ProductionManagementEntities db = new ProductionManagementEntities();
var scheduleList = (from s in db.Schedules
join w in db.WeekDetails on
select new ExtractionViewModel
{
Year = s.ModifiedDate,
Week = s.
}).ToList();
return scheduleList;
}
public ActionResult ExportToExcel()
{
var v = new GridView();
// v.DataSource = this.GetExtractionViewModels();
v.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=ExtractionRecords.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter objStringWriter = new StringWriter();
HtmlTextWriter htmlTextWriter = new HtmlTextWriter(objStringWriter);
v.RenderControl(htmlTextWriter);
Response.Output.Write(objStringWriter.ToString());
Response.Flush();
Response.End();
return View("List");
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
There is apperently no difference between join 2 tables and 3 tables, only there must be a common column betweeb 1,2 and 3 or 1,2 and 2,3 or 1,2 and 1,3. where 1,2,3 are tables.
Jignesh Kumar5y ago
Hi,

I think you want join two table shedules and weekdetails and want to create response as ExtractionViewModel model.

Can you please share your all table? Could you please share what is relation between this two shedules and weekdetails table ?

For EF Linq reference here,
https://www.c-sharpcorner.com/article/sql-join-query-with-linq/