|
public BuildOrderByPart ( |
||
| sqlStatement | ||
| commandBuilder | ISqlCommandBuilder | |
| 리턴 | void | |
public void BuildOrderBy_WithSingleOrderByClause()
{
var columnExpression = new SqlColumnDefinitionExpression(typeof(string), "t", "Name", false);
var orderByClause = new Ordering(columnExpression, OrderingDirection.Asc);
var sqlStatement = new SqlStatement(
new TestStreamedValueInfo(typeof(int)),
_entityExpression,
new[] { _sqlTable },
null,
null,
new[] { orderByClause },
null,
false,
null,
null);
_stageMock.Expect(mock => mock.GenerateTextForOrdering(_commandBuilder, orderByClause))
.WhenCalled(mi => ((SqlCommandBuilder)mi.Arguments[0]).Append("[t].[Name] ASC"));
_stageMock.Replay();
_generator.BuildOrderByPart(sqlStatement, _commandBuilder);
Assert.That(_commandBuilder.GetCommandText(), Is.EqualTo(" ORDER BY [t].[Name] ASC"));
_stageMock.VerifyAllExpectations();
}
public void BuildOrderBy_WithSingleOrderByClause()
{
var columnExpression = new SqlColumnDefinitionExpression(typeof(string), "t", "Name", false);
var orderByClause = new Ordering(columnExpression, OrderingDirection.Asc);
var sqlStatement = SqlStatementModelObjectMother.CreateMinimalSqlStatement(new SqlStatementBuilder {
Orderings = { orderByClause }
});
_stageMock.Expect(mock => mock.GenerateTextForOrdering(_commandBuilder, orderByClause))
.WhenCalled(mi => ((SqlCommandBuilder)mi.Arguments[0]).Append("[t].[Name] ASC"));
_stageMock.Replay();
_generator.BuildOrderByPart(sqlStatement, _commandBuilder);
Assert.That(_commandBuilder.GetCommandText(), Is.EqualTo(" ORDER BY [t].[Name] ASC"));
_stageMock.VerifyAllExpectations();
}