Example #1
0
        public IAndOr IsNull()
        {
            if (!string.IsNullOrEmpty(Operand))
            {
                InnerSql.Append(Operand);
            }

            InnerSql.Append(" (").Append(WhereColumnName).Append(" IS NULL)");

            return(this);
        }
        public IWithParameter WithParameter(string parameter, object arg)
        {
            if (Arguments.Count > 0)
            {
                InnerSql.Append(',');
            }

            Arguments.Add(new SqlArgument(arg));

            InnerSql.Append(parameter);

            return(this);
        }
Example #3
0
        public IWhereSingleColumn Where(string column)
        {
            if (string.IsNullOrEmpty(column))
            {
                throw new ArgumentException(ExceptionMessages.ArgumentNullOrEmpty.FormatWith("column"));
            }

            WhereColumnName = SqlCharacters.EscapeSql(column);

            if (!AddedWhere)
            {
                InnerSql.Append(" WHERE");
                AddedWhere = true;
            }

            return(this);
        }