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);
}
