/// <summary>
/// A distinct property value count.
/// </summary>
public static IProjection CountDistinct(String fieldName)
{
return(new CountProjection(Clauses.Field(fieldName))
{
Distinct = true
});
}
/// <inheritdoc/>
public override String ToGroupString(ICriteria criteria)
{
if (Grouped)
{
return(Clauses.Field(PropertyName).Render(criteria));
}
else
{
return(base.ToGroupString(criteria));
}
}
/// <summary>
/// A property minimum value.
/// </summary>
public static IProjection Min(String fieldName)
{
return(new AggregateProjection("min", Clauses.Field(fieldName)));
}
/// <summary>
/// A property average value.
/// </summary>
public static IProjection Avg(String fieldName)
{
return(new AggregateProjection("avg", Clauses.Field(fieldName)));
}
/// <summary>
/// A property value count.
/// </summary>
public static IProjection Count(String fieldName)
{
return(new CountProjection(Clauses.Field(fieldName)));
}
/// <summary>
/// A property value sum.
/// </summary>
public static IProjection Sum(String fieldName)
{
return(new AggregateProjection("sum", Clauses.Field(fieldName)));
}
public String ToSqlString(PropertyProjection propertyProjection)
{
return(Alias(Clauses.Field(propertyProjection.PropertyName).Render(this), propertyProjection.Alias));
}
/// <summary>
/// Descending order.
/// </summary>
public static Order Desc(String fieldName)
{
return(new Order(Clauses.Field(fieldName), false));
}
/// <summary>
/// Ascending order.
/// </summary>
public static Order Asc(String fieldName)
{
return(new Order(Clauses.Field(fieldName), true));
}