public int CheckParent(int elementDefinitionID) { Pixco.Framework.AssetManagement.Data.AMF_devDb dbAsset = new Pixco.Framework.AssetManagement.Data.AMF_devDb(); MetadataElementOptionDataMapper oElementMapper = new MetadataElementOptionDataMapper(dbAsset); string sqlStr = @"select metadataElementDefinitionID from Asset.MetadataElementOption where Asset.MetadataElementOption.ID = ( select top 1 metadataElementOptionID from Asset.MetadataElementDefinitionMetadataElementOption where metadataElementDefinitionID = " + elementDefinitionID.ToString() + ")"; QueryResult queryElement = oElementMapper.findBySql(sqlStr); List listElement = (List)queryElement.Result; if (listElement.Count > 0) { CheckParent(listElement[0].MetadataElementDefinitionID); } return elementDefinitionID; }