AccessProviderSample.AccessDBProvider.TableIsPresent C# (CSharp) Method

TableIsPresent() private method

Checks to see if the specified table is present in the database
private TableIsPresent ( string tableName ) : bool
tableName string Name of the table to check
return bool
        private bool TableIsPresent(string tableName)
        {
            // using ODBC connection to the database and get the schema of tables
            AccessDBPSDriveInfo di = this.PSDriveInfo as AccessDBPSDriveInfo;
            if (di == null)
            {
                return false;
            }

            OdbcConnection connection = di.Connection;
            DataTable dt = connection.GetSchema("Tables");

            // check if the specified tableName is available
            // in the list of tables present in the database
            foreach (DataRow dr in dt.Rows)
            {
                string name = dr["TABLE_NAME"] as string;
                if (name.Equals(tableName, StringComparison.OrdinalIgnoreCase))
                {
                    return true;
                }
            }

            WriteError(new ErrorRecord(
                new ArgumentException("Specified Table is not present in database"), "TableNotAvailable",
                     ErrorCategory.InvalidArgument, tableName));

            return false;
        }