Esempio n. 1
0
        /// <summary>
        /// Returns string with CREATE TABLE sql for the table which owns this index.
        /// </summary>
        /// <param name="connection">Connection to use to execute query.</param>
        /// <param name="row">DataRow with information about index.</param>
        /// <returns>Returns string with CREATE TABLE sql for this table.</returns>
        private static string GetCreateTableQuery(DataConnectionWrapper connection, DataRow row)
        {
            // Extract schema and table name
            string schemaName = DataInterpreter.GetString(row, Attributes.Schema);
            string tableName  = DataInterpreter.GetString(row, Attributes.Table);

            if (String.IsNullOrEmpty(schemaName) || String.IsNullOrEmpty(tableName))
            {
                Debug.Fail("Unable to get table or schema name");
                return(String.Empty);
            }

            return(TableDescriptor.GetCreateTableQuery(connection, schemaName, tableName));
        }
Esempio n. 2
0
        /// <summary>
        /// Reads table with Database Objects which satisfy given restriction. Uses table enumeration for legacy
        /// version.
        /// </summary>
        /// <param name="connection">The DataConnectionWrapper to be used for enumeration.</param>
        /// <param name="restrictions">The restrictions to be putted on the retrieved objects set.</param>
        /// <param name="sort">Sort expresion to append after ORDER BY clause.</param>
        /// <returns>Returns table with Database Objects which satisfy given restriction.</returns>
        protected override DataTable ReadTable(DataConnectionWrapper connection, object[] restrictions, string sort)
        {
            if (connection == null)
            {
                throw new ArgumentNullException("connection");
            }

            // Extract server version
            Version serverVersion = connection.ServerVersion;

            // For latest version just return base result
            if (serverVersion == null || serverVersion.Major >= 5)
            {
                return(base.ReadTable(connection, restrictions, sort));
            }
            ;

            // For legacy version enumerate tables
            DataTable result = TableDescriptor.Enumerate(connection, restrictions);

            // If result is empty, return it
            if (result == null)
            {
                return(null);
            }

            // Add is updatable column
            result.Columns.Add(Attributes.IsUpdatable, typeof(string));

            // Set is updatable to true for each row
            foreach (DataRow table in result.Rows)
            {
                DataInterpreter.SetValueIfChanged(table, Attributes.IsUpdatable, DataInterpreter.True);
            }

            // Finaly, return result
            return(result);
        }