Improving my linq syntax
I have a table called  SCode that stores all the ids of the names using in my database and only the ids of these names are stored in the different tables. 

This mean, i have to write some pretty redundant(in my opinion) linq code most of the time. Below an example.

    var cars_subset = from c in Cars join 
    head in Headers on c.HeaderId equals head.HeaderId join CodeCountry in SCodes
    on  head.Country equals CodeCountry.TblCodeID
    join CodeModelYear in SCodes on head.ModelYear equals CodeModelYear.TblCodeID
    join CodeFleetName in SCodes on head.FleetName equals CodeFleetName.TblCodeID
    join CodeCarName in SCodes on c.Name equals CodCarName.TblCodeID
    join CodedCQualityFlag in SCodes on c.QualityFlag equals CodedCQualityFlag.TblCodeID
	
    where .........
    select new { Car_Country=CodedCountry.Code ,Car_name=CodCarName.Code, ....}

in short table Cars contain my cars. Header is the parent of the Cars table and these 2 tables only store numbers (ids).

The names (strings ) are stored in SCODES table .
		  
My question is, can the code belwo be improved with some of the clever featuires of C# such as generics or expression?
I have no idea if this makes sense but i hope someone with the right expertise may suggest something w=even if i can save one line or 2 in case i need.

Thanks in advance
M
Improving my linq syntax
===

I have a table called  SCode that stores all the ids of the names using in my database and only the ids of these names are stored in the different tables. 

This mean, i have to write some pretty redundant(in my opinion) linq code most of the time. Below an example.

    var cars_subset = from c in Cars join 
    head in Headers on c.HeaderId equals head.HeaderId join CodeCountry in SCodes
    on  head.Country equals CodeCountry.TblCodeID
    join CodeModelYear in SCodes on head.ModelYear equals CodeModelYear.TblCodeID
    join CodeFleetName in SCodes on head.FleetName equals CodeFleetName.TblCodeID
    join CodeCarName in SCodes on c.Name equals CodCarName.TblCodeID
    join CodedCQualityFlag in SCodes on c.QualityFlag equals CodedCQualityFlag.TblCodeID
	
    where .........
    select new { Car_Country=CodedCountry.Code ,Car_name=CodCarName.Code, ....}

in short table Cars contain my cars. Header is the parent of the Cars table and these 2 tables only store numbers (ids).

The names (strings ) are stored in SCODES table .
		  
My question is, can the code belwo be improved with some of the clever featuires of C# such as generics or expression?
I have no idea if this makes sense but i hope someone with the right expertise may suggest something w=even if i can save one line or 2 in case i need.

Thanks in advance
M