public IEnumerable<Catalog> ReadDB(int? pID) { IEnumerable<Catalog> iCatalog; CatalogDataContext db = new CatalogDataContext(); iCatalog = db.ZNodeCatalogs.AsEnumerable() .Select(row => new Catalog { catalogID = row.CatalogID, isActive = row.IsActive, title = row.Name, portalID = (!row.PortalID.HasValue) ? 0 : (int)row.PortalID }); if (pID.HasValue) { iCatalog = iCatalog.Where(row => row.portalID == pID); } return iCatalog; }
public IEnumerable<PortalCatalog> ReadDB(int? pID) { IEnumerable<PortalCatalog> iCatalog; PortalCatalogDataContext db = new PortalCatalogDataContext(); CatalogDataContext dbCat = new CatalogDataContext(); iCatalog = db.ZNodePortalCatalogs.AsEnumerable() .Join( dbCat.ZNodeCatalogs, _PCat => _PCat.CatalogID, _CData => _CData.CatalogID, (_PCat, _CData) => new { _CData.Name, _CData.IsActive, _PCat.CatalogID, _PCat.LocaleID, _PCat.PortalCatalogID, _PCat.PortalID, _PCat.Theme, _PCat.CSS } ) .Select(row => new PortalCatalog { catalogID = row.CatalogID, CSS = row.CSS, portalID = row.PortalID, localeID = row.LocaleID, portalCatalogID = row.PortalCatalogID, name = row.Name, theme = row.Theme, isActive = row.IsActive }); if (pID.HasValue) { iCatalog = iCatalog.Where(row => row.portalID == pID); } return iCatalog; }