private static void TestComplexClause() { ComplexFromClause from = new ComplexFromClause(); InnerJoin join = new InnerJoin(new TableAlias("emp", "a"), new TableAlias("dept", "b"), "a.dept", "b.dept"); from.AddJoin(join); Console.WriteLine(from.ToString()); }
public void TestComplexFromClauseWithInnerJoin() { string expected = "FROM emp AS a INNER JOIN dept AS b ON a.dept=b.dept"; ComplexFromClause from = new ComplexFromClause(); InnerJoin join = new InnerJoin(new TableAlias("emp", "a"), new TableAlias("dept", "b"), "a.dept", "b.dept"); from.AddJoin(join); Assert.AreEqual(expected.ToLower(), from.ToString().ToLower()); }