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

10 votes188 views3 answers
Unity C# instantiate prefab
C#Unity
1 vote127 views1 answer
How to get text from textbox in windows form c#
C#
6 votes139 views1 answer
The hidden dungeon only i could enter season 2
C#
0 vote143 views1 answer
How to convert float to int in c# unity
C#
2 votes148 views2 answers
Unity don't destroy on load
C#
41 votes131 views6 answers
Prime Numbers
C#
25 votes131 views3 answers
If get key down unity
C#
1 vote150 views1 answer
Filedialog get folder path c#
C#
0 vote137 views1 answer
Large blank file C#
C#
1 vote132 views3 answers
Byte[] to base 65 string in C#
C#