예제 #1
0
        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"));
        }
예제 #2
0
 public void SetUp()
 {
     _sqlCustomTextExpression = new SqlCustomTextExpression("test", typeof(string));
 }