question on sql stored procedures:
from this thread i understand whether the stored proc can be converted to a .sh file or an function. My requirement is integrate the stored procedure to a UI ( like asp.net or WPF) because my stored procedure is returning a data set. What is the best approach, can i call a vertica function through ADO.net ?
I am using the vertica ADO.net connector by the way .