MicroLite.Builder.SelectSqlBuilder.Average C# (CSharp) Method

Average() public method

public Average ( string columnName ) : IFunctionOrFrom
columnName string
return IFunctionOrFrom
        public IFunctionOrFrom Average(string columnName)
        {
            this.AddFunctionCall("AVG", columnName, columnName);

            return this;
        }

Same methods

SelectSqlBuilder::Average ( string columnName, string columnAlias ) : IFunctionOrFrom

Usage Example

        public void AverageThrowsArgumentExceptionForNullColumnAlias()
        {
            var sqlBuilder = new SelectSqlBuilder(SqlCharacters.Empty);

            var exception = Assert.Throws<ArgumentException>(
                () => sqlBuilder.Average("Column", null));

            Assert.Equal(ExceptionMessages.ArgumentNullOrEmpty.FormatWith("columnAlias"), exception.Message);
        }
All Usage Examples Of MicroLite.Builder.SelectSqlBuilder::Average