Ejemplo n.º 1
0
        public static WhereSqlClause MergeWhere(this WhereSqlClause first, WhereSqlClause second)
        {
            if (first == null)
            {
                throw new ArgumentNullException(nameof(first));
            }
            if (second == null)
            {
                throw new ArgumentNullException(nameof(second));
            }

            var merger    = new SqlClauseMerger(first.WhereConditions, first.Parameters, second.WhereConditions, second.Parameters);
            var newClause = merger.Merge("({0}) AND ({1})");

            return(new WhereSqlClause(newClause.Sql, newClause.Parameters));
        }
Ejemplo n.º 2
0
        public static CustomSqlClause Append(this CustomSqlClause source, string sql, object[] parameters = null)
        {
            if (source == null)
            {
                throw new ArgumentNullException(nameof(source));
            }
            if (sql == null)
            {
                throw new ArgumentNullException(nameof(sql));
            }

            if (parameters == null)
            {
                parameters = new object[0];
            }

            var merger    = new SqlClauseMerger(source.Sql, source.Parameters, sql, parameters);
            var newClause = merger.Merge("{0}\n{1}");

            return(new CustomSqlClause(newClause.Sql, newClause.Parameters));
        }