Using Stored Procedure with ADO.net

Sushanth_B

Iam using ADO.net driver for vertica and working in asp.net I need to create a graph and for this i need to execute a stored procedure. Got to know that vertica doesnt support stored procedure .please specify a step by step instruction for creating external procedure in vertica and use through ado.net

Prasanta_Pal

Refer to the below link how to create external Stored Proc https://my.vertica.com/docs/6.1.x/HTML/index.htm#13587.htm Call the stored proc similar to a SELECT statement from .Net code.