public void TestJoinSqlServerMultipleJoins()
{
QueryCriteria qcFirst = new QueryCriteria(first);
QueryCriteria qcSecond = new QueryCriteria(second);
QueryCriteria qcThird = new QueryCriteria(third);
qcThird.Add(CriteriaOperator.Equality, third.TableFields[1], "tt");
qcFirst.AddJoin(JoinType.Inner, first.TableName, first.TableFields[0], second.TableName, second.TableFields[1], qcSecond);
qcFirst.Add(CriteriaOperator.Higher, first.TableFields[0], 1);
qcFirst.AddJoin(JoinType.Inner, second.TableName, second.TableFields[0], third.TableName, third.TableFields[2], qcThird);
DataSet ds = psqlserver.GetDataSet(qcFirst);
Assert.IsTrue(ds != null);
}
public void TestJoinSqlServerSingleJoin()
{
QueryCriteria qcFirst = new QueryCriteria(first);
QueryCriteria qcSecond = new QueryCriteria(second);
QueryCriteria qcThird = new QueryCriteria(third);
qcFirst.AddJoin(JoinType.Inner, first.TableName, first.TableFields[0], second.TableName, second.TableFields[1], qcSecond);
qcFirst.Add(CriteriaOperator.OrderBy, first.TableFields[0], "Asc");
DataSet ds = psqlserver.GetDataSet(qcFirst);
Assert.IsTrue(ds != null);
}
