Exemple #1
0
        /// <summary>
        ///     Helper method to create a new transient SQL table, not yet attached to anything.
        /// </summary>
        /// <param name="name">The physical SQL table name</param>
        /// <param name="aliasPrefix">A suggested table alias</param>
        /// <returns>The SQL table</returns>
        public SqlTable CreateTable(string name, string aliasPrefix)
        {
            // Note: name can be empty for aggregate table
            var table = new SqlTable
            {
                Name        = name,
                TableAlias  = AliasManager.CreateAlias(aliasPrefix),
                ParentQuery = this,
                References  = FullStatement.References,
                AllowAccessToAllResources = FullStatement.AllowAccessToAllResources,
                DenyAccessToAllResources  = FullStatement.DenyAccessToAllResources
            };

            return(table);
        }