Anonymous

       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<MetadataElementOption> listElement = (List<MetadataElementOption>)queryElement.Result;

           if (listElement.Count > 0)
           {
               CheckParent(listElement[0].MetadataElementDefinitionID);
           }


           return elementDefinitionID;
       }