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

0 vote267 views1 answer
Unity mix gradient colors
C#Unity
3 votes215 views1 answer
C# get class name by type
C#
0 vote185 views1 answer
Windows form button image size
C#
6 votes184 views2 answers
Play sound unity
C#
1 vote189 views2 answers
C# memorystream to byte array
C#
1 vote234 views1 answer
Unity change particle system sorting layer via script
C#Unity
0 vote175 views1 answer
Asp.net disabled checkbox style
C#
10 votes221 views4 answers
Unity rotate around point
C#
9 votes200 views1 answer
Unity get layer of gameobject
C#
4 votes188 views3 answers
How to create a singleton in unity
C#