Exemple #1
0
        public ConditionBuilder notEqual(string param)
        {
            SQLVerifier.VerifyVarchar255(param);

            this.conditionBuilder.condition += " " + this.NOT_EQUAL_TO + " \'" + param + "\'";

            this.queryBuilder.Query.AddCondition(new Condition(this.conditionBuilder.condition));

            return(new ConditionBuilder(queryBuilder));
        }
Exemple #2
0
        public ConditionBuilder lesserOrEqual(string param)
        {
            SQLVerifier.VerifyVarchar255(param);

            this.conditionBuilder.condition += " " + this.LESSER_OR_EQUAL + " \'" + param + "\'";

            this.queryBuilder.Query.AddCondition(new Condition(this.conditionBuilder.condition));

            return(new ConditionBuilder(queryBuilder));
        }
Exemple #3
0
        public ConditionBuilder greaterThan(string param)
        {
            SQLVerifier.VerifyVarchar255(param);

            this.conditionBuilder.condition += " " + this.GREATER_THAN + " \'" + param + "\'";

            this.queryBuilder.Query.AddCondition(new Condition(this.conditionBuilder.condition));

            return(new ConditionBuilder(queryBuilder));
        }
Exemple #4
0
        public ConditionBuilder get(params string[] list)
        {
            if (list.Length == 0)
            {
                throw new InvalidOperationException();
            }

            for (int i = 0; i < list.Length; i++)
            {
                SQLVerifier.VerifyVarchar255(list[i]);
                this.qBuilder.Query.AddSelection(new Selection(list[i]));
            }

            return(new ConditionBuilder(qBuilder));
        }
Exemple #5
0
 public ComparisonBuilder where (string param1)
 {
     SQLVerifier.VerifyVarchar255(param1);
     condition += param1;
     return(new ComparisonBuilder(qBuilder, this));
 }
Exemple #6
0
 public QueryTableBuilder name(String Name)
 {
     SQLVerifier.VerifyVarchar255(Name);
     this.Table.Name = Name;
     return(this);
 }