示例#1
0
        /// <summary>
        /// Serializes all of the tables from the SELECT statment.
        /// </summary>
        public virtual string SerializeSelectTables(SQLSelectTables selectTables)
        {
            var strSQL = String.Join(", ",
                selectTables
                .Where(table => selectTables.Joins == null || !selectTables.Joins.Exists(table))
                .Select(table => SerializeSelectTableBase(table))
                .ToArray());

            if (selectTables.Joins != null)
            {
                string strJoinsSQL = SerializeSelectTableJoins(selectTables.Joins);

                if (strJoinsSQL != string.Empty && strSQL != string.Empty)
                    strSQL += " ";

                strSQL += strJoinsSQL;
            }

            return strSQL;
        }
示例#2
0
 public SQLSelect()
 {
     pobjTables = new SQLSelectTables(this);
 }