コード例 #1
0
ファイル: QueryBuilder.cs プロジェクト: mzabani/SqlBuilder
        /// <summary>
        /// AND's the specified <paramref name="andCondition"/> to the QueryBuilder.
        /// </summary>
        /// <param name='andCondition'>
        /// The condition to be ANDed.
        /// </param>
        public QueryBuilder Where(SqlFragment andCondition)
        {
            if (whereCondition == null)
            {
                whereCondition = new WhereCondition(andCondition);
            }
            else
            {
                whereCondition.And(andCondition);
            }

            return(this);
        }
コード例 #2
0
        /// <summary>
        /// Joins the table of name <paramref name="joined_table_name"/>, represented by type <typeparamref name="JT" /> to the root entity, the join condition
        /// being expressed in <paramref name="joinCondition"/>.
        /// </summary>
        /// <param name="joined_table_name">The real name of the table to be joined, as it is in the database.</param>
        /// <param name="joinType">The type of join (inner, outer etc.)</param>
        /// <typeparam name="JT">The type that represents the newly joined table.</typeparam>
        public RootQueryBuilder <T> Join <JT>(string joined_table_name, Expression <Func <T, JT, bool> > joinCondition, JoinType joinType)
        {
            if (QueriedTables.ContainsKey(joined_table_name))
            {
                throw new InvalidOperationException("This table has already been queried/joined. Please use a method that allows you to join to the same table more than once.");
            }

            var conditionBuilder = new WhereConditionGeneratorTreeVisitor();

            conditionBuilder.AddType(RootTable, RootEntityType);
            conditionBuilder.AddType(joined_table_name, typeof(JT));
            conditionBuilder.Visit(joinCondition);
            WhereCondition condFragment = conditionBuilder.Fragment;

            Qb.Join(joined_table_name, condFragment, joinType);

            return(this);
        }
コード例 #3
0
 public WhereConditionGeneratorTreeVisitor() : base()
 {
     Fragment      = new WhereCondition();
     TableEntities = new Dictionary <Type, string>(2);
 }