public void RenderOrderByClause() { Column column = new Column("Column1"); GroupByClause groupByClause = new GroupByClause(column); Assert.AreEqual("[Column1]", sqlClientRenderer.Render(groupByClause)); }
public void RenderTableFromClause() { Table table = new Table("Table1"); TableFromClause tableFromClause = new TableFromClause(table); Assert.AreEqual("[Table1]", sqlClientRenderer.Render(tableFromClause)); }
public void RenderOrderByClause() { Column column = new Column("Column1"); OrderByClause orderByClause = new OrderByClause(column); Assert.AreEqual("[Column1] ASC", sqlClientRenderer.Render(orderByClause)); }
public void RenderExpressionSelectClause() { Column column = new Column("Column1"); SelectClause selectClause = new SelectClause(column); Assert.AreEqual("[Column1]", sqlClientRenderer.Render(selectClause)); }
public void RenderIntegerLiteralArray() { IEnumerable <int> array = new int[] { 1, 2, 3 }; IntegerLiteralArray integerLiteralArray = new IntegerLiteralArray(array); Assert.AreEqual("1,2,3", sqlClientRenderer.Render(integerLiteralArray)); }
public void RenderLowerFunction() { Column column = new Column("Column1"); LowerFunction lowerFunction = new LowerFunction(column); Assert.AreEqual("LOWER([Column1])", sqlClientRenderer.Render(lowerFunction)); }
public void RenderComparisonPredicate() { Column column = new Column("Column1"); StringLiteralValue stringLiteralValue = new StringLiteralValue("Value1"); ComparisonPredicate comparisonPredicate = new ComparisonPredicate(column, ComparisonPredicateType.Equals, stringLiteralValue); Assert.AreEqual("[Column1] = 'Value1'", sqlClientRenderer.Render(comparisonPredicate)); }
public void RenderHavingClausesAnd() { Column column1 = new Column("Column1"); Column column2 = new Column("Column2"); StringLiteralValue stringLiteralValue1 = new StringLiteralValue("Value1"); StringLiteralValue stringLiteralValue2 = new StringLiteralValue("Value2"); ComparisonPredicate comparisonPredicate1 = new ComparisonPredicate(column1, ComparisonPredicateType.Equals, stringLiteralValue1); ComparisonPredicate comparisonPredicate2 = new ComparisonPredicate(column2, ComparisonPredicateType.Equals, stringLiteralValue2); HavingClause havingClause1 = new HavingClause(comparisonPredicate1); HavingClause havingClause2 = new HavingClause(comparisonPredicate2); HavingClauses havingClauses = new HavingClauses(havingClause1, BooleanOperatorType.And, havingClause2); Assert.AreEqual("([Column1] = 'Value1' AND [Column2] = 'Value2')", sqlClientRenderer.Render(havingClauses)); }
public void RenderBooleanLiteralValue() { BooleanLiteralValue booleanLiteralValue = new BooleanLiteralValue(true); Assert.AreEqual("1", sqlClientRenderer.Render(booleanLiteralValue)); }
public void RenderColumn() { Column column = new Column("Column1"); Assert.AreEqual("[Column1]", sqlClientRenderer.Render(column)); }
public void RenderEmptySelectQuery() { SelectQuery selectQuery = new SelectQuery(); Assert.AreEqual("", sqlClientRenderer.Render(selectQuery)); }
public void RenderDistinctModifier() { DistinctModifier distinctModifier = new DistinctModifier(); Assert.AreEqual("DISTINCT", sqlClientRenderer.Render(distinctModifier)); }
public void RenderParameter() { Parameter parameter = new Parameter("Parameter1", 1, DbType.Int32, ParameterDirection.Input); Assert.AreEqual("@Parameter1", sqlClientRenderer.Render(parameter)); }