public void ItShouldBePossibleToPartitionByMultipleColumns()
{
var expr = Select.Column <Person>(p => p.Name)
.Column <Person>(p => Sql.Max(p.Age), Over.PartitionBy <Person>(p => p.Name).ThenBy <Person>(p => p.LivesAtHouseId))
.From <Person>();
var result = expr.ToSqlExpression();
Assert.That(result, Is.EqualTo(TokenGeneration_SelectPartitionTests_Results.partitionByMultipleColumnsExpression));
}
public void ItShouldBePossibleToBothPartitionAndOrderByAColumn()
{
var expr = Select.Column <Person>(p => p.Name)
.Column <Person>(
p => Sql.Sum(p.Age),
Over.PartitionBy <Person>(p => p.Name).OrderBy <Person>(p => p.Age))
.From <Person>();
var result = expr.ToSqlExpression();
Assert.That(result, Is.EqualTo(TokenGeneration_SelectPartitionTests_Results.orderAndPartitionByColumnExpression));
}
