本文整理汇总了C#中MicroLite.Builder.SelectSqlBuilder.Sum方法的典型用法代码示例。如果您正苦于以下问题：C# SelectSqlBuilder.Sum方法的具体用法？C# SelectSqlBuilder.Sum怎么用？C# SelectSqlBuilder.Sum使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类MicroLite.Builder.SelectSqlBuilder的用法示例。
在下文中一共展示了SelectSqlBuilder.Sum方法的6个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SumThrowsArgumentExceptionForNullColumnAlias
public void SumThrowsArgumentExceptionForNullColumnAlias()
{
var sqlBuilder = new SelectSqlBuilder(SqlCharacters.Empty);
var exception = Assert.Throws<ArgumentException>(
() => sqlBuilder.Sum("Column", null));
Assert.Equal(ExceptionMessages.ArgumentNullOrEmpty.FormatWith("columnAlias"), exception.Message);
}示例2: SelectWhereGroupByOrderByWithSqlCharacters
public void SelectWhereGroupByOrderByWithSqlCharacters()
{
var sqlBuilder = new SelectSqlBuilder(MsSqlCharacters.Instance, "CustomerId");
var sqlQuery = sqlBuilder
.Sum("Total")
.From("Invoices")
.Where("OrderDate").IsGreaterThan(new DateTime(2000, 1, 1))
.GroupBy("Total")
.OrderByDescending("OrderDate")
.ToSqlQuery();
Assert.Equal("SELECT [CustomerId],SUM([Total]) AS Total FROM [Invoices] WHERE ([OrderDate] > @p0) GROUP BY [Total] ORDER BY [OrderDate] DESC", sqlQuery.CommandText);
Assert.Equal(1, sqlQuery.Arguments.Count);
Assert.Equal(DbType.DateTime, sqlQuery.Arguments[0].DbType);
Assert.Equal(new DateTime(2000, 1, 1), sqlQuery.Arguments[0].Value);
}示例3: SelectWhereGroupByOrderBy
public void SelectWhereGroupByOrderBy()
{
var sqlBuilder = new SelectSqlBuilder(SqlCharacters.Empty, "CustomerId");
var sqlQuery = sqlBuilder
.Sum("Total")
.From("Invoices")
.Where("OrderDate").IsGreaterThan(new DateTime(2000, 1, 1))
.GroupBy("Total")
.OrderByDescending("OrderDate")
.ToSqlQuery();
Assert.Equal("SELECT CustomerId,SUM(Total) AS Total FROM Invoices WHERE (OrderDate > ?) GROUP BY Total ORDER BY OrderDate DESC", sqlQuery.CommandText);
Assert.Equal(1, sqlQuery.Arguments.Count);
Assert.Equal(DbType.DateTime, sqlQuery.Arguments[0].DbType);
Assert.Equal(new DateTime(2000, 1, 1), sqlQuery.Arguments[0].Value);
}示例4: SelectSumWithSqlCharacters
public void SelectSumWithSqlCharacters()
{
var sqlBuilder = new SelectSqlBuilder(MsSqlCharacters.Instance, (string)null);
var sqlQuery = sqlBuilder
.Sum("CreditLimit")
.From(typeof(Customer))
.Where("CustomerStatusId").IsEqualTo(CustomerStatus.Active)
.ToSqlQuery();
Assert.Equal("SELECT SUM([CreditLimit]) AS CreditLimit FROM [Sales].[Customers] WHERE ([CustomerStatusId] = @p0)", sqlQuery.CommandText);
Assert.Equal(1, sqlQuery.Arguments.Count);
Assert.Equal(DbType.Int32, sqlQuery.Arguments[0].DbType);
Assert.Equal(CustomerStatus.Active, sqlQuery.Arguments[0].Value);
}示例5: SelectSumWithOtherColumn
public void SelectSumWithOtherColumn()
{
var sqlBuilder = new SelectSqlBuilder(SqlCharacters.Empty, "Id");
var sqlQuery = sqlBuilder
.Sum("CreditLimit")
.From(typeof(Customer))
.Where("CustomerStatusId").IsEqualTo(CustomerStatus.Active)
.ToSqlQuery();
Assert.Equal("SELECT Id,SUM(CreditLimit) AS CreditLimit FROM Sales.Customers WHERE (CustomerStatusId = ?)", sqlQuery.CommandText);
Assert.Equal(1, sqlQuery.Arguments.Count);
Assert.Equal(DbType.Int32, sqlQuery.Arguments[0].DbType);
Assert.Equal(CustomerStatus.Active, sqlQuery.Arguments[0].Value);
}示例6: SelectSumWithAlias
public void SelectSumWithAlias()
{
var sqlBuilder = new SelectSqlBuilder(SqlCharacters.Empty, (string)null);
var sqlQuery = sqlBuilder
.Sum("CreditLimit", columnAlias: "SumCreditLimit")
.From(typeof(Customer))
.Where("CustomerStatusId").IsEqualTo(CustomerStatus.Active)
.ToSqlQuery();
Assert.Equal(1, sqlQuery.Arguments.Count);
Assert.Equal(CustomerStatus.Active, sqlQuery.Arguments[0]);
Assert.Equal("SELECT SUM(CreditLimit) AS SumCreditLimit FROM Sales.Customers WHERE (CustomerStatusId = ?)", sqlQuery.CommandText);
}