public void ItCanAcceptAJoinToASelectStatement() { const string expectedText = "INNER JOIN {0} ON ({1} = ({2}))\r\n"; var statement = new Select() [ SecondColumn.Top(1) ].From(SecondTable); new InnerJoin() [ FirstTable.On(FirstColumn.Matches(statement)) ] .Should() .Be(string.Format(expectedText, FirstTable, FirstColumn, statement)); }
public void ItCanContainAnInStatementWithASubQuery() { const string clause = "WHERE {0} IN (SELECT {1} FROM {2})"; var innerSelect = new Select() [ SecondColumn ].From(SomeTable); new Where() [ FirstColumn.In(innerSelect) ] .Should() .Be(string.Format(clause, FirstColumn, SecondColumn, SomeTable)); }