MetaStoredProcedure

MetaStoredProcedure class specifies a stored procedure that exists in the underlying database. It gives information about: the Name of the procedure, and all In and Out parameters.

The following examples shows you how to get information about the stored procedures in your model:

private string GetStoredProcedures(Telerik.OpenAccess.Metadata.MetadataContainer container)
{
   StringBuilder sb = new StringBuilder();
   foreach (MetaStoredProcedure storedProcedure in container.StoredProcedures)
   {
       sb.AppendFormat("\nName: {0}", storedProcedure.Name);
       sb.AppendLine("Parameters:");
       foreach (MetaStoredProcedureParameter parameter in storedProcedure.Parameters)
       {
           sb.AppendFormat("\tParameterName: {0}", parameter.Name);
           sb.AppendFormat("\tType: {0}", parameter.Type);
       }
   }
   return sb.ToString();
}

Private Function GetStoredProcedures(ByVal container _
    As Telerik.OpenAccess.Metadata.MetadataContainer) As String
 Dim sb As New StringBuilder()
 For Each storedProcedure As MetaStoredProcedure In container.StoredProcedures
  sb.AppendFormat(vbLf & "Name: {0}", storedProcedure.Name)
  sb.AppendLine("Parameters:")
  For Each parameter As MetaStoredProcedureParameter In storedProcedure.Parameters
   sb.AppendFormat(vbTab & "ParameterName: {0}", parameter.Name)
   sb.AppendFormat(vbTab & "Type: {0}", parameter.Type)
  Next parameter
 Next storedProcedure
 Return sb.ToString()
End Function