Devart Forums

Code: Select all

Guid[] ids = new Guid[] { . . . };
using ( PgSqlCommand cmd = new PgSqlCommand( "SELECT function( ids );" ) {
    cmd.Parameters.AddWithValue( "ids", ids );

    PgSqlReader reader = cmd.ExecuteReader();
    while ( reader.Read() ) {
        ... 
    }
}

Code: Select all

The Type ARRAY is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.

Code: Select all

CREATE OR REPLACE FUNCTION security.SynchRolesForGroup(grpid uuid, roleids uuid[]) RETURNS void AS
$BODY$
DECLARE
    RoleId      UUID;
BEGIN
    DELETE FROM security.aspnetx_RolesInGroups WHERE GroupId = GrpId;

    -- Now loop over all of the UUIDs in the RoleIds parameter
    FOREACH RoleId IN ARRAY RoleIds LOOP
        INSERT INTO security.aspnetx_RolesInGroups
            ( GroupId, RoleId )
        VALUES
            ( GrpId, RoleId );
    END LOOP;
END;
$BODY$
  LANGUAGE plpgsql;

Code: Select all

public static int PutImageBytes( CarSystemEntities context, byte[] image ) {
    PgSqlConnection connection = ( (EntityConnection) context.Connection ).StoreConnection as PgSqlConnection;

    try {
        if ( connection.State != ConnectionState.Open ) {
            connection.Open();
        }

        PgSqlLargeObject lo = new PgSqlLargeObject( connection );
        lo.ReadTimeout = 0;
        lo.WriteTimeout = 0;

        lo.Create();
        lo.Open();
        lo.Write( image, 0, image.Length );
                lo.Close();

        return lo.Oid;
    } catch ( Exception ex ) {
        throw new DataAccessException( DataAccessOperations.PutImageBytes, FailureReason.DatabaseError, ex );
    }
}