Devart Forums

Code: Select all

CREATE OR REPLACE FUNCTION ret_bool(condition boolean)
  RETURNS boolean AS
' BEGIN  Return condition; END;'
  LANGUAGE plpgsql VOLATILE
  COST 10000;
ALTER FUNCTION ret_bool(boolean)
  OWNER TO postgres;

Code: Select all

[Function(Name=@"public.ret_bool", IsComposable=true)]
public System.Nullable<System.Boolean> RetBool([Parameter(Name="condition", DbType="BOOLEAN")] System.Nullable<bool> condition)
        {
            IExecuteResult _RetBoolResult = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), condition);
            return ((System.Nullable<System.Boolean>)(_RetBoolResult.ReturnValue));
        }

Code: Select all

PostgreDataContext context = new PostgreDataContext();
 bool results = (bool) context.RetBool(false);

Code: Select all

PgSqlConnection connection = new PgSqlConnection(connectionString);
connection.Open();
PgSqlCommand command = new PgSqlCommand("ret_bool", connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add("condition", PgSqlType.Boolean);
command.Parameters["condition"].Value = true;
command.Parameters.Add("return_value", PgSqlType.Boolean);
command.Parameters["return_value"].Direction = System.Data.ParameterDirection.ReturnValue;
command.ExecuteNonQuery();
bool result = (bool) command.Parameters["return_value"].Value;

Code: Select all

IAsyncResult myResult = command.BeginExecuteNonQuery();   
// enter you code here
command.EndExecuteNonQuery(myResult);
bool result = (bool) command.Parameters["return_value"].Value;

Code: Select all

command.ExecuteNonQuery();
bool result = (bool) command.Parameters["return_value"].Value;