Examines database for potential design issues
Design issues include things like Naming stored procedures with 'sp_*' Naming objects using SQL server reserved keywords
DatabaseDesignIssueInspector Class Documentation
Ejemplo n.º 1
0
        public Database GetDatabaseMetaData()
        {
            Database database = null;

            if (SqlConnectionTester.TestConnectionString(this.sqlConnectionString, false).Success)
            {
                this.peta = new PetaPoco.Database(this.sqlConnectionString, "System.Data.SqlClient");


                database = this.queryForDatabase();

                var schemaInspector = new SchemaInspector(this.peta);

                database.Schemas = schemaInspector.GetSchemas(database);

                //TODO: add input parameter to control inspection for design issues
                DesignIssue.DatabaseDesignIssueInspector designIssueInspector = new DesignIssue.DatabaseDesignIssueInspector();
                database.DesignIssueWarnings = designIssueInspector.GetDesignIssueWarnings(database);
            }

            return(database);
        }
Ejemplo n.º 2
0
        public Database GetDatabaseMetaData()
        {
            Database database = null;

            if (SqlConnectionTester.TestConnectionString(this.sqlConnectionString, false).Success)
            {
                this.peta = new PetaPoco.Database(this.sqlConnectionString, "System.Data.SqlClient");

                database = this.queryForDatabase();

                var schemaInspector = new SchemaInspector(this.peta);

                database.Schemas = schemaInspector.GetSchemas(database);

                //TODO: add input parameter to control inspection for design issues
                DesignIssue.DatabaseDesignIssueInspector designIssueInspector = new DesignIssue.DatabaseDesignIssueInspector();
                database.DesignIssueWarnings = designIssueInspector.GetDesignIssueWarnings(database);

            }

            return database;
        }