Ejemplo n.º 1
0
        public override string ToTable(int top = 0)
        {
            var strFields = SelectString.Length == 0 ? "*" : SelectString.ToString();

            var topString = new StringBuilder();

            if (top > 0)
            {
                if (WhereString.Length > 0)
                {
                    topString.Append(" AND ");
                }
                topString.Append(string.Format("ROWNUM <= {0}", top));
            }
            return(string.Format("SELECT {0} FROM {1} {2} {3} {4};", GetFields(), TableName, WhereString, topString,
                                 SortString));
        }