public IQueryable<RecentlyCreatedAssetViewModel> getRecentlyCreatedAssetsByCompanyID(int companyID) return (from a in db.Assets join b in db.Bundles on ab.BundleID equals b
List<ServicePacksDTO> allServicePacks = new List<ServicePacksDTO>(); { from sp in db.ServicePacks
join st in db.States.DefaultIfEmpty() on sp.State_id equals st.State_