public void VisitSqlCaseExpression_WithElse()
{
var case1 = new SqlCaseExpression.CaseWhenPair(new SqlCustomTextExpression("test1", typeof(bool)), new SqlCustomTextExpression("value1", typeof(int)));
var case2 = new SqlCaseExpression.CaseWhenPair(new SqlCustomTextExpression("test2", typeof(bool)), new SqlCustomTextExpression("value2", typeof(int)));
var elseCase = new SqlCustomTextExpression("elseValue", typeof(int));
var expression = new SqlCaseExpression(typeof(int), new[] { case1, case2 }, elseCase);
SqlGeneratingExpressionVisitor.GenerateSql(expression, _commandBuilder, _stageMock);
Assert.That(_commandBuilder.GetCommandText(), Is.EqualTo("CASE WHEN test1 THEN value1 WHEN test2 THEN value2 ELSE elseValue END"));
}
public void SetUp()
{
_sqlCustomTextExpression = new SqlCustomTextExpression("test", typeof(string));
}