Example #1
0
        internal static MsSqlQueryStatementBase Any(params string[] expressions)
        {
            if (expressions == null)
            {
                throw new ArgumentNullException(nameof(expressions));
            }
            if (!expressions.Any())
            {
                throw new ArgumentException(nameof(expressions));
            }

            IOrSupport query = new MsSqlCondition(expressions[0], null);

            if (expressions.Length == 1)
            {
                return((MsSqlQueryStatementBase)query);
            }

            for (var index = 1; index < expressions.Length; index++)
            {
                var expression = expressions[index];
                query = query.Or(expression);
            }

            return(new MsSqlScope((MsSqlQueryStatementBase)query));
        }
Example #2
0
 public IAnd AndLike(string expression, string value, Func <bool> includeCondition)
 {
     return(new MsSqlAnd(MsSqlCondition.Create(expression, Operators.Like, value), this)
     {
         Settings = new Settings {
             IncludeCondition = includeCondition
         }
     });
 }
Example #3
0
 public IAnd And(string expression, object value, Func <bool> includeCondition)
 {
     return(new MsSqlAnd(MsSqlCondition.Create(expression, value), this)
     {
         Settings = new Settings {
             IncludeCondition = includeCondition
         }
     });
 }
Example #4
0
 public IOr Or(string expression, Func <bool> includeCondition)
 {
     return(new MsSqlOr(MsSqlCondition.Create(expression), this)
     {
         Settings = new Settings {
             IncludeCondition = includeCondition
         }
     });
 }
Example #5
0
 public IOr OrLike(string expression, object value, Func <bool> includeCondition)
 {
     return(new MsSqlOr(MsSqlCondition.Create(expression, Operators.Like, value), this)
     {
         Settings = new Settings {
             IncludeCondition = includeCondition
         }
     });
 }
Example #6
0
 public IOr Or(string expression)
 {
     return(new MsSqlOr(MsSqlCondition.Create(expression), this));
 }
Example #7
0
 public IAnd AndLike(string expression, string value)
 {
     return(new MsSqlAnd(MsSqlCondition.Create(expression, Operators.Like, value), this));
 }
Example #8
0
 public IAnd And(string expression, object value)
 {
     return(new MsSqlAnd(MsSqlCondition.Create(expression, value), this));
 }
Example #9
0
 public IAnd And(string expression)
 {
     return(new MsSqlAnd(MsSqlCondition.Create(expression), this));
 }
Example #10
0
 public IOr OrLike(string expression, string value)
 {
     return(new MsSqlOr(MsSqlCondition.Create(expression, value), this));
 }
Example #11
0
 public IWhere Where(string expression, object value)
 {
     return(new MsSqlWhere(MsSqlCondition.Create(expression, value), this));
 }
Example #12
0
 public IWhere Where(string expression)
 {
     return(new MsSqlWhere(MsSqlCondition.Create(expression), this));
 }