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)); }