public IDataSchemaProcedure GetProcedureOrFunction(string schemaName, string objectName) { IDataSchemaProcedure procedureOrFunction = null; if (!string.IsNullOrEmpty(schemaName) && !string.IsNullOrEmpty(objectName)) { var procedureList = _selector.SelectMappedObjects<IVsDataStoredProcedure>(new object[] { DefaultCatalog, schemaName, objectName }, true); if (procedureList.Count > 0) { procedureOrFunction = new DataSchemaProcedure(this, procedureList[0]); } else { var functionList = _selector.SelectMappedObjects<IVsDataScalarFunction>(new object[] { DefaultCatalog, schemaName, objectName }, true); if (functionList.Count > 0) { procedureOrFunction = new DataSchemaProcedure(this, functionList[0]); } else { var tvfList = _selector.SelectMappedObjects<IVsDataTabularFunction>( new object[] { DefaultCatalog, schemaName, objectName }, true); if (tvfList.Count > 0) { procedureOrFunction = new DataSchemaProcedure(this, tvfList[0]); } } } } return procedureOrFunction; }
public IDataSchemaProcedure GetProcedureOrFunction(string schemaName, string objectName) { IDataSchemaProcedure procedureOrFunction = null; if (!string.IsNullOrEmpty(schemaName) && !string.IsNullOrEmpty(objectName)) { var procedureList = _selector.SelectMappedObjects <IVsDataStoredProcedure>(new object[] { DefaultCatalog, schemaName, objectName }, true); if (procedureList.Count > 0) { procedureOrFunction = new DataSchemaProcedure(this, procedureList[0]); } else { var functionList = _selector.SelectMappedObjects <IVsDataScalarFunction>(new object[] { DefaultCatalog, schemaName, objectName }, true); if (functionList.Count > 0) { procedureOrFunction = new DataSchemaProcedure(this, functionList[0]); } else { var tvfList = _selector.SelectMappedObjects <IVsDataTabularFunction>( new object[] { DefaultCatalog, schemaName, objectName }, true); if (tvfList.Count > 0) { procedureOrFunction = new DataSchemaProcedure(this, tvfList[0]); } } } } return(procedureOrFunction); }