// no statement building
#else
//
// SQL Statement builder
//
#region public override bool BuildStatement(DBStatementBuilder builder)
public override bool BuildStatement(DBStatementBuilder builder)
{
if (string.IsNullOrEmpty(this.FunctionName))
{
return(false);
}
builder.BeginFunction(this.KnownFunction, this.FunctionName);
builder.BeginFunctionParameterList();
if (this.HasParameters)
{
int index = 0;
foreach (DBClause p in this.Parameters)
{
builder.BeginFunctionParameter(index);
p.BuildStatement(builder);
builder.EndFunctionParameter(index);
index++;
}
}
builder.EndFunctionParameterList();
builder.EndFunction(this.KnownFunction, this.FunctionName);
if (string.IsNullOrEmpty(this.Alias) == false)
{
builder.WriteAlias(this.Alias);
}
return(true);
}
// no statement building
#else
public override bool BuildStatement(DBStatementBuilder builder)
{
if (string.IsNullOrEmpty(this.Owner) == false)
{
builder.BeginIdentifier();
builder.WriteObjectName(this.Owner);
builder.EndIdentifier();
builder.AppendIdSeparator();
}
builder.BeginIdentifier();
builder.WriteObjectName(this.SequenceName);
builder.EndIdentifier();
builder.AppendIdSeparator();
builder.BeginFunction(this.KnownFunction, string.Empty);
builder.BeginFunctionParameterList();
if (this.HasParameters)
{
this.Parameters.BuildStatement(builder);
}
builder.EndFunctionParameterList();
builder.EndFunction(this.KnownFunction, string.Empty);
return(true);
}
// no statement building
#else
//
// SQL Statement building
//
#region public override bool BuildStatement(DBStatementBuilder builder)
public override bool BuildStatement(DBStatementBuilder builder)
{
builder.BeginAggregateFunction(this.Function, this.Function.ToString());
builder.BeginFunctionParameterList();
if (this.InnerReference != null)
{
this.InnerReference.BuildStatement(builder);
}
builder.EndFunctionParameterList();
builder.EndAggregateFunction(this.Function, this.Function.ToString());
if (string.IsNullOrEmpty(this.Alias) == false)
{
builder.WriteAlias(this.Alias);
}
return(true);
}