How setup Postgres function in schema modeler and how to call it in C#

Data Abstract
1

I use Postgres, and C# / DatAbstract Visual studio

  1. How setup in the schema modeler a postgres function (stored procedur), I did not seen any documentation about it,

This function has for exemple two variables: V1 integer and V2 string and the result is an integer.

  1. And after how can I call this function with DALINK ?

Thank in advance

2

Hello

Sorry for the belated answer.
Only Stored Procedures that return datasets can be used as tables that are accessible via DA LINQ (and even there will be some significant limitations)

To call a Stored Procedure that requrns a scalar value you need to difene it as Schema Command.

Then it can be called from the client using code like

    private RemObjects.DataAbstract.RemoteCommand remoteCommand1;
    ...
    this.remoteCommand1 = new RemObjects.DataAbstract.RemoteCommand(this.components);
    this.remoteCommand1.ExecuteCall.Parameters.Clear();
    this.remoteCommand1.ExecuteCall.Parameters.Add("aCommandName", "String", RemObjects.SDK.ParameterDirection.In);
    this.remoteCommand1.ExecuteCall.Parameters.Add("aParameterArray", "DataParameterArray", RemObjects.SDK.ParameterDirection.In);
    this.remoteCommand1.ExecuteCall.Parameters.Add("Result", "Integer", RemObjects.SDK.ParameterDirection.Result);
    this.remoteCommand1.ExecuteCall.OutgoingCommandNameParameter = "aCommandName";
    this.remoteCommand1.ExecuteCall.OutgoingParametersParameter = "aParameterArray";
    this.remoteCommand1.ExecuteCall.IncomingAffectedRowsParameter = "Result";
    this.remoteCommand1.RemoteService = this.remoteService;

And the call itself looks like

    remoteCommand1.Execute("Insert_Employees",
                       new string[] { "FirstName", "LastName", "Title" },
                       new object[] { editor.firstName, editor.lastName, editor.title});

There are overloads of this method that allow to access OUT parameters as well.

Regards