Hi everyone,
I am trying joining multiple tables on multiple checkbox checked.
My tables structure like picture.
I have table name "T_Talepler"
I have different 3 table "T_Klas", "T_Konaklama", "T_IL"
This 3 table foreign key T_Talepler.
How can I join linq to sql.

Code
var ids = new List<int>();
IQueryable<T_Talepler> rows = null;
if (!string.IsNullOrEmpty(klasId))
{
for (int i = 0; i < klasId.Split(',').Length; i++)
{
ids.Add(Convert.ToInt32(klasId.Split(',')[i]));
}
rows = (from v in shy.T_Talepler
join c in shy.T_Klas on v.KlasID equals c.ID
join b in shy.T_Konaklama on v.KonaklamaID equals b.ID
join p in shy.T_IL on v.ILID equals p.ID
where
}
else
{
rows = shy.T_Talepler.Take(5);
}
var talep = rows.Select(a => new
{
Butce = a.Butce,
Donus = a.DonusTarihi,
Gidis = a.GidisTarihi,
Il = a.T_IL.ILAd,
Ilce = a.T_ILCE.ILceAd,
Kisi = a.KisiSayisi,
Klas = a.T_Klas.UcretTipi,
Talep = a.TalepNo,
Konaklama = a.T_Konaklama.KonaklamaGece,
Konfor = a.T_Konaklama.Konfor,
TTarih = a.TalepTarihi,
Sirket = a.T_Sirket.SirketLogo,
YetkiliAd = a.T_Sirket.YetkiliAd,
klasId = a.KlasID
}).ToList();