MetadataProviderUtils.GetStoredProcParameters Method

Retrieves the stored procedure parameters.

Namespace:  Microsoft.SqlServer.Management.SqlParser.MetadataProvider
Assembly:  Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.dll)

Syntax

'Declaration
Public Shared Function GetStoredProcParameters ( _
    storedProcText As String, _
    metadataFactory As IMetadataFactory, _
    dataTypeLookup As ISystemDataTypeLookup, _
    collationInfo As CollationInfo, _
    parseOptions As ParseOptions _
) As IMetadataOrderedCollection(Of IParameter)
'Usage
Dim storedProcText As String 
Dim metadataFactory As IMetadataFactory 
Dim dataTypeLookup As ISystemDataTypeLookup 
Dim collationInfo As CollationInfo 
Dim parseOptions As ParseOptions 
Dim returnValue As IMetadataOrderedCollection(Of IParameter)

returnValue = MetadataProviderUtils.GetStoredProcParameters(storedProcText, _
    metadataFactory, dataTypeLookup, _
    collationInfo, parseOptions)

public static IMetadataOrderedCollection<IParameter> GetStoredProcParameters(
    string storedProcText,
    IMetadataFactory metadataFactory,
    ISystemDataTypeLookup dataTypeLookup,
    CollationInfo collationInfo,
    ParseOptions parseOptions
)

public:
static IMetadataOrderedCollection<IParameter^>^ GetStoredProcParameters(
    String^ storedProcText, 
    IMetadataFactory^ metadataFactory, 
    ISystemDataTypeLookup^ dataTypeLookup, 
    CollationInfo^ collationInfo, 
    ParseOptions^ parseOptions
)

static member GetStoredProcParameters : 
        storedProcText:string * 
        metadataFactory:IMetadataFactory * 
        dataTypeLookup:ISystemDataTypeLookup * 
        collationInfo:CollationInfo * 
        parseOptions:ParseOptions -> IMetadataOrderedCollection<IParameter> 

public static function GetStoredProcParameters(
    storedProcText : String, 
    metadataFactory : IMetadataFactory, 
    dataTypeLookup : ISystemDataTypeLookup, 
    collationInfo : CollationInfo, 
    parseOptions : ParseOptions
) : IMetadataOrderedCollection<IParameter>

Parameters

• storedProcText
  Type: System.String
  The stored procedure text.

• metadataFactory
  Type: Microsoft.SqlServer.Management.SqlParser.MetadataProvider.IMetadataFactory
  The IMetadataFactory object that is used to create metadata objects.

• dataTypeLookup
  Type: Microsoft.SqlServer.Management.SqlParser.MetadataProvider.ISystemDataTypeLookup
  The ISystemDataTypeLookup object that is used to search for available system data types.

• collationInfo
  Type: Microsoft.SqlServer.Management.SqlParser.Metadata.CollationInfo
  The CollationInfo object that represents the collation of the related database.

• parseOptions
  Type: Microsoft.SqlServer.Management.SqlParser.Parser.ParseOptions
  The parsing options.

Return Value

Type: Microsoft.SqlServer.Management.SqlParser.Metadata.IMetadataOrderedCollection<IParameter>
An ordered collection of parameters; nulla null reference (Nothing in Visual Basic) if no parameters are present.

See Also

Reference

MetadataProviderUtils Class

Microsoft.SqlServer.Management.SqlParser.MetadataProvider Namespace