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); }