MicroLite.Builder.SelectSqlBuilder.AndWhere C# (CSharp) Method

AndWhere() public method

public AndWhere ( string predicate ) : IAndOrOrderBy
predicate string
return IAndOrOrderBy
        public IAndOrOrderBy AndWhere(string predicate, params object[] args)
        {
            if (string.IsNullOrEmpty(predicate))
            {
                throw new ArgumentException(ExceptionMessages.ArgumentNullOrEmpty.FormatWith("predicate"));
            }

            if (args == null)
            {
                throw new ArgumentNullException("args");
            }

            for (int i = 0; i < args.Length; i++)
            {
                this.Arguments.Add(new SqlArgument(args[i]));
            }

            var renumberedPredicate = SqlUtility.RenumberParameters(predicate, this.Arguments.Count);

            this.InnerSql.Append(" AND (")
                .Append(renumberedPredicate)
                .Append(')');

            return this;
        }

Same methods

SelectSqlBuilder::AndWhere ( string column ) : IWhereSingleColumn

Usage Example

        public void AndWhereThrowsArgumentExceptionForNullPredicate()
        {
            var sqlBuilder = new SelectSqlBuilder(SqlCharacters.Empty);

            var exception = Assert.Throws<ArgumentException>(
                () => sqlBuilder.AndWhere(null, new object()));

            Assert.Equal(ExceptionMessages.ArgumentNullOrEmpty.FormatWith("predicate"), exception.Message);
        }
All Usage Examples Of MicroLite.Builder.SelectSqlBuilder::AndWhere