Joining 4 tables in linqToSql

I have 4 tables and need to write a linq query to pull information from all tables!

Here is the table structure:

Printer:

• printerID
• PrinterName

Template:

• TemplateID
• TemplateCategoryID
• TemplateName

TemplateCategory:

• TemplatecategoryID
• TemplatecategoryName

Data:

• DataID
• PrinterID
• TemplateID
• CreatedDate
• IsProcessedDate

The information I want is:

PrinterName, TemplateCategory, TemplateName, Data-CreatedDate, Data-Isprocessed开发者_如何转开发Date.

I'm all new to linq and cannot recognize the way to solve this. Much appriciated if anyone has any comment on this.

Thanks alot, Finn.

with some assumptions, add your context reference:

from d in Data
join t in Tempalte on d.TemplateID equals t.TempateID
join tc in TemplateCategory on t.TemplateCategoryID equals tc.TemplateCategoryID
join p in Printer on d.PrinterID equals p.PrinterID
select new
{
    p.PrinterName,
    tc.TemplatecategoryName,
    t.TemplateName,
    d.CreatedDate,
    d.IsProcessedDate
}