public void SimpleCase() { var q = new SharpQuery(); SimpleCase c = new SimpleCase(1); c.When(1, 2).When(3, 4).Else(5); q.Select(c).EndStatement(); var script = q.ToString(); TSqlAssert.ScriptsAreEqual(script, @" SELECT ( CASE @p0 WHEN @p0 THEN @p1 WHEN @p2 THEN @p3 ELSE @p4 END ) "); }
public void SimpleCase() { var q = new SharpQuery(); SimpleCase c = new SimpleCase(1); c.When(1, 2).When(3, 4).Else(5); q.Select(c).EndStatement(); var script = q.ToString(); TSqlAssert.ScriptsAreEqual(script, @" SELECT ( CASE @p0 WHEN @p0 THEN @p1 WHEN @p2 THEN @p3 ELSE @p4 END ) "); }
public void SimpleCaseConstructorTest() { SimpleCase target = new SimpleCase(); Assert.Inconclusive("TODO: Implement code to verify target"); }