public void SqlStringTest_One() { ISqlObject field = new SqlServerField(new SqlServerSource("Table"), "Field", null); ISqlGroupClause target = new SqlGroupClause().AddExpressions(field); Assert.AreEqual <string>(string.Format("{0} {1}", target.Keyword, field.Fullname), target.SqlString); }
public void SqlStringTest_Expression() { ISqlObject source = new SqlServerSource("Table"); ISqlExpression expression = new SqlFunction("MAX").AddArgument(new SqlServerField(source, "ID", null)); ISqlObject field = SqlObject.FromVariable("ROWNUM"); ISqlGroupClause target = new SqlGroupClause().AddExpressions(expression, field); Assert.AreEqual <string>(string.Format("{0} {1}, {2}", target.Keyword, expression.SqlString, field.Fullname), target.SqlString); }
public void SqlStringTest_More() { ISqlObject source = new SqlServerSource("Table"); ISqlObject field0 = new SqlServerField(source, "Field0", null); ISqlObject field1 = SqlObject.FromVariable("ROWNUM"); ISqlGroupClause target = new SqlGroupClause().AddExpressions(field0, field1); Assert.AreEqual <string>(string.Format("{0} {1}, {2}", target.Keyword, field0.Fullname, field1.Fullname), target.SqlString); }