public void TestSimpleJoinEmpty()
{
var testCriteria = new TestJoinCriteria
{
WithAnotherTable = false,
};
var builder = new TestQueryBuilder <TestJoinCriteria>(testCriteria);
var query = builder.Build();
Assert.AreEqual(
"Select TableName.* , 0 as SplitOnAnotherTableCurrentTableId from TableName"
, SimplifyString(query.Sql)
);
}
public void TestSimpleJoin()
{
var testCriteria = new TestJoinCriteria
{
WithAnotherTable = true,
};
var builder = new TestQueryBuilder <TestJoinCriteria>(testCriteria);
var query = builder.Build();
Assert.AreEqual(
"Select TableName.* , 0 as SplitOnAnotherTableCurrentTableId , AnotherTable.* from TableName LEFT JOIN AnotherTable on AnotherTable.CurrentTableId = TableName.CurrentTableId"
, SimplifyString(query.Sql)
);
}
