public void TestManyToManyJoinEmpty() { var testCriteria = new TestManyToManyJoinCriteria { WithAnotherTable = false, }; var builder = new TestQueryBuilder <TestManyToManyJoinCriteria>(testCriteria); var query = builder.Build(); Assert.AreEqual( "Select TableName.* , 0 as SplitOnAnotherTableAnotherId from TableName" , SimplifyString(query.Sql) ); }
public void TestManyToManyJoin() { var testCriteria = new TestManyToManyJoinCriteria { WithAnotherTable = true, }; var builder = new TestQueryBuilder <TestManyToManyJoinCriteria>(testCriteria); var query = builder.Build(); Assert.AreEqual( "Select TableName.* , 0 as SplitOnAnotherTableAnotherId , AnotherTable.* from TableName " + "LEFT JOIN AnotherTableCurrentTable on AnotherTableCurrentTable.CurrentId = TableName.CurrentId " + "LEFT JOIN AnotherTable on AnotherTable.AnotherId = AnotherTableCurrentTable.AnotherId" , SimplifyString(query.Sql) ); }