public static void Shop_GetProductCount(string StoreName, string APIKey, string Password, string Vendor = null, string ProductType = null, string PublishedStatus = null)
{
ShopifyClient sp = new ShopifyClient(StoreName, APIKey, Password);
SqlPipe p = SqlContext.Pipe;
// Create the record and specify the metadata for the columns.
SqlDataRecord record = new SqlDataRecord(new SqlMetaData("ProductCount", SqlDbType.Int));
string _v = Vendor != null ? Vendor : "";
string _pt = ProductType != null ? ProductType : "";
string _ps = PublishedStatus != null ? PublishedStatus : "";
// Mark the begining of the result-set.
SqlContext.Pipe.SendResultsStart(record);
record.SetInt32(0, sp.GetProductCount(_v, _pt, _ps));
// Send the row back to the client.
SqlContext.Pipe.SendResultsRow(record);
// Mark the end of the result-set.
SqlContext.Pipe.SendResultsEnd();
}