Linq from multiple tables

from p in Product
from c in Catalog
from m in Manufacturer
where c.Id == p.CatalogId && m.Id == p.ManufacturerId && p.Active == 1
select new 
    { 
        p.Name,
        p.CatalogId,
        p.ManufacturerId,
        c.Name,
        m.Name 
    };

Similar codes

4 votes102 views3 answers
How to use onmousedown unity
C#
4 votes149 views3 answers
C# clear an array
C#
0 vote143 views1 answer
OVR Headset
C#
10 votes132 views4 answers
Unity array c#
C#
0 vote132 views3 answers
Ddsfsd
C#
1 vote133 views1 answer
C# function return datareader
C#
31 votes142 views4 answers
C# serialize json
C#
41 votes155 views4 answers
Make a list c#
C#
0 vote142 views1 answer
C# datafield change cell background color
C#
0 vote149 views1 answer
C# calculate someone's age
C#