var result = (from c in ctx.Clients
join cs in ctx.ClientSizeTypes on c.ClientSizeTypeId equals cs.Id
join i in ctx.IndustryTypes on c.IndustryTypeId equals i.Id
join cst in ctx.ClientStatusTypes on c.ClientStatusTypeId equals cst.Id
where c.CompanyId == activeCompanyId
orderby c.Name, c.UpdatedDate descending
select c).ToList();
ctx.Dispose();
result.Insert(0, new Client { Id = "0", Name = "Please Select" });