public void TestSelect_RemoveSource() { var builder = new SelectBuilder(); var table1 = builder.AddTable(new Table("Table1")); var table2 = builder.AddTable(new Table("Table2")); builder.AddProjection(table1.Column("Column")); var table2Column = builder.AddProjection(table2.Column("Column")); builder.RemoveSource(table2); builder.RemoveProjection(table2Column); var formatter = new Formatter(); var commandText = formatter.GetCommandText(builder); var expected = "SELECT Table1.Column FROM Table1"; Assert.AreEqual(expected, commandText, "The wrong SQL was generated."); }