@Html.ActionLink(Convert.ToString(itemN), "ifcondi", new { id = item.Id.ToString() })
var data1 = (from c in db.RowItems
join a in db.categories on c.CategoryItemId equals a.category_id
join d in db.DirectItems on c.DirectItemId equals d.Id
where d.ItemName == "PLASMA 60"
1> this query has no proble ,
2> wht i write insted of plazma 60 ...bcz plazma 60 is static query and i required dynamic query