C# (CSharp) net.datacowboy.SqlServerDatabaseDocumentationGenerator.Inspection ColumnInspector Examples

Example #1

        public IList <View> GetViews(Schema schema)
        {
            IList <View> viewList = this.getViewsForSchema(schema);



            if (viewList != null && viewList.Count > 0)
            {
                var columnInspector = new ColumnInspector(this.peta);

                var indexInspector = new IndexInspector(this.peta);

                for (int v = 0; v < viewList.Count; v++)
                {
                    var view = viewList[v];

                    view.Columns = columnInspector.GetColumns(view);

                    view.Indexes = indexInspector.GetIndexes(view);

                    view.Parent = schema;
                }
            }



            return(viewList);
        }

Example #2

File: ViewInspector.cs Project: hbulzy/SqlServerDatabaseDocumentationGenerator

        public IList<View> GetViews(Schema schema)
        {
            IList<View> viewList = this.getViewsForSchema(schema);

            if (viewList != null && viewList.Count > 0)
            {
                var columnInspector = new ColumnInspector(this.peta);

                var indexInspector = new IndexInspector(this.peta);

                for (int v = 0; v < viewList.Count; v++)
                {
                   var view = viewList[v];

                    view.Columns = columnInspector.GetColumns(view);

                    view.Indexes = indexInspector.GetIndexes(view);

                    view.Parent = schema;

                }

            }

            return viewList;
        }

Example #3

File: TableFunctionInspector.cs Project: waldeilton/SqlServerDatabaseDocumentationGenerator

        public IList <TableFunction> GetTableFunctions(Schema schema)
        {
            IList <TableFunction> tfList = this.queryForTableFunctions(schema);


            if (tfList != null && tfList.Count > 0)
            {
                var paramInspector = new ParameterInspector(this.peta);

                var columnInspector = new ColumnInspector(this.peta);

                for (int t = 0; t < tfList.Count; t++)
                {
                    var func = tfList[t];

                    func.Parameters = paramInspector.GetParameters(func);

                    func.Columns = columnInspector.GetColumns(func);

                    func.Parent = schema;
                }
            }

            return(tfList);
        }

Example #4

File: TableFunctionInspector.cs Project: hbulzy/SqlServerDatabaseDocumentationGenerator

        public IList<TableFunction> GetTableFunctions(Schema schema)
        {
            IList<TableFunction> tfList = this.queryForTableFunctions(schema);

            if (tfList != null && tfList.Count > 0)
            {

                var paramInspector = new ParameterInspector(this.peta);

                var columnInspector = new ColumnInspector(this.peta);

                for (int t = 0; t < tfList.Count; t++)
                {

                    var func = tfList[t];

                    func.Parameters = paramInspector.GetParameters(func);

                    func.Columns = columnInspector.GetColumns(func);

                    func.Parent = schema;
                }

            }

            return tfList;
        }

Example #5

File: TableInspector.cs Project: waldeilton/SqlServerDatabaseDocumentationGenerator

        public IList <Table> GetTables(Schema schema)
        {
            var tableList = this.queryForTables(schema);



            if (tableList != null && tableList.Count > 0)
            {
                Table table = null;

                var columnInspector = new ColumnInspector(this.peta);

                var indexInspector = new IndexInspector(this.peta);

                var foreignKeyInspector = new ForeignKeyInspector(this.peta);

                for (int i = 0; i < tableList.Count; i++)
                {
                    table             = tableList[i];
                    table.Columns     = columnInspector.GetColumns(table);
                    table.Indexes     = indexInspector.GetIndexes(table);
                    table.ForeignKeys = foreignKeyInspector.GetForeignKeys(table);
                    table.Parent      = schema;
                }
            }


            return(tableList);
        }

Example #6

File: TableInspector.cs Project: hbulzy/SqlServerDatabaseDocumentationGenerator

        public IList<Table> GetTables(Schema schema)
        {
            var tableList = this.queryForTables(schema);

            if (tableList != null && tableList.Count > 0)
            {
                Table table = null;

                var columnInspector = new ColumnInspector(this.peta);

                var indexInspector = new IndexInspector(this.peta);

                var foreignKeyInspector = new ForeignKeyInspector(this.peta);

                for (int i = 0; i < tableList.Count; i++)
                {
                    table = tableList[i];
                    table.Columns = columnInspector.GetColumns(table);
                    table.Indexes = indexInspector.GetIndexes(table);
                    table.ForeignKeys = foreignKeyInspector.GetForeignKeys(table);
                    table.Parent = schema;
                }

            }

            return tableList;
        }