public void TestSqlServerAliases()
{
CustomerTableMetadata c = new CustomerTableMetadata();
QueryCriteria qc = new QueryCriteria(c);
qc.Add(CriteriaOperator.Equality, c.TableFields[0], 47);
qc.Add(CriteriaOperator.Or, c.TableFields[1]);
qc.Add(CriteriaOperator.Equality, c.TableFields[0], 48);
qc.Add(CriteriaOperator.Between, c.TableFields[0], 48, 70);
qc.Add(CriteriaOperator.Like, c.TableFields[1], "blah");
qc.Add(CriteriaOperator.Not, c.TableFields[0], 48);
qc.Add(CriteriaOperator.IsNull, c.TableFields[0]);
qc.Add(CriteriaOperator.OrderBy, c.TableFields[1], "asc");
qc.Add(CriteriaOperator.OrderBy, c.TableFields[0], "desc");
//aliases
qc.AddAlias("Age", "AAAAAAAg");
qc.AddAlias("Name", "Numele_bahhhhhhhhhhhhhh");
IQueryCriteriaGenerator ss = DataFactory.InitializeQueryCriteriaGenerator(DatabaseServer.SqlServer);
ExecutionQuery s = ss.GenerateSelect(qc);
Console.WriteLine(s.Query);
DataSet ds = psqlserver.GetDataSet(qc);
Assert.IsTrue(ds != null);
}
public void TestSqlServerSmaller()
{
CustomerTableMetadata c = new CustomerTableMetadata();
QueryCriteria qc = new QueryCriteria(c);
qc.Add(CriteriaOperator.Smaller, c.TableFields[0], 47);
qc.AddAlias(c.TableFields[0].fieldName, "kko_cu_lapte");
//IQueryCriteriaGenerator ss = DataFactory.InitializeQueryCriteriaGenerator(DatabaseServer.SqlServer);
//string s = ss.GenerateSelect(qc);
//Console.WriteLine(s);
DataSet ds = psqlserver.GetDataSet(qc);
Assert.IsTrue(ds != null);
}
