ADO.NET Provider for WooCommerce

Build 20.0.7654


The Procedures schema collection describes the available stored procedures.

Retrieving the Stored Procedure Listing

To retrieve the Procedures schema collection, call the GetSchema method of the WooCommerceConnection class. Access the metadata in the DataTable object returned.

The following example outputs a list of stored procedure names:


String connectionString = " Url=http://localhost/wordpress/;ConsumerKey=ck_ec52c76185c088ecaa3145287c8acba55a6f59ad;ConsumerSecret=cs_9fde14bf57126156701a7563fc87575713c355e5;";

using (WooCommerceConnection conn = new WooCommerceConnection(connectionString)) {
  DataTable table = conn.GetSchema("Procedures");
  foreach (DataRow row in table.Rows)


Dim connectionString As String = " Url=http://localhost/wordpress/;ConsumerKey=ck_ec52c76185c088ecaa3145287c8acba55a6f59ad;ConsumerSecret=cs_9fde14bf57126156701a7563fc87575713c355e5;"

Using conn As New WooCommerceConnection(connectionString)
  Dim table As DataTable = conn.GetSchema("Procedures")
  For Each row As DataRow in table.Rows
End Using

Columns Returned

The Procedures schema collection contains the following columns:

Column NameData TypeDescription
SPECIFIC_CATALOGSystem.StringThe name of the database containing the stored procedure.
SPECIFIC_SCHEMASystem.StringThe schema that contains the stored procedure.
SPECIFIC_NAMESystem.StringThe name of the stored procedure containing the parameter.
ROUTINE_CATALOGSystem.StringThe database containing the stored procedure.
ROUTINE_SCHEMASystem.StringThe schema containing the stored procedure.
ROUTINE_NAMESystem.StringThe name of the stored procedure.
ROUTINE_TYPESystem.StringReturns PROCEDURE for stored procedures and FUNCTION for functions.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654