public ICollection <ConfigurationAsset> GetCMDBForKey(string key)
        {
            using (CMDBEntities ctx = this.cmdbEntities)
            {
                var query = from ca in ctx.ConfigurationAssets.AsNoTracking() from ak in ca.AccessKeys where ak.key == key select ca;

                ICollection <ConfigurationAsset> configAssets = query.ToList <ConfigurationAsset>();
                return(configAssets);
            }
        }
        public ICollection <ConfigurationAsset> GetCMDBForKey(string key, string group, string subGroup)
        {
            using (CMDBEntities ctx = this.cmdbEntities)
            {
                var query = from ca in ctx.ConfigurationAssets.AsNoTracking() from ak in ca.AccessKeys where ak.key == key select ca;
                if (!String.IsNullOrWhiteSpace(group))
                {
                    query = query.Where(ca => ca.group == group);
                }
                if (!String.IsNullOrWhiteSpace(subGroup))
                {
                    query = query.Where(ca => ca.subgroup == subGroup);
                }


                ICollection <ConfigurationAsset> configAssets = query.ToList <ConfigurationAsset>();
                return(configAssets);
            }
        }
 public CMDBServiceManager(CMDBEntities cmdbEntities)
 {
     this.cmdbEntities = cmdbEntities;
 }