GetTables() public method

public GetTables ( Microsoft database, bool splitFactsAndDimensions ) : List
database Microsoft
splitFactsAndDimensions bool
return List
Beispiel #1
0
        public static Biml BuildBiml( BimlRequest request )
        {
            // Configure SQL SMO
            var server = new Server( request.ServerName );
            var scriptingOptions = new ScriptingOptions { Encoding = Encoding.UTF8 };
            server.Script( scriptingOptions );
            var database = new Microsoft.SqlServer.Management.Smo.Database( server, request.DatabaseName );
            database.Refresh();

            var bimlService = new BimlService();
            var output = new Biml();

            // Selectively build sections
            if ( request.HasConnections )
                output.Connections = bimlService.GetConnections( server, database );
            if ( request.HasDatabases )
                output.Databases = bimlService.GetDatabases( database );
            if( request.HasSchemas )
                output.Schemas = bimlService.GetSchemas( database );
            if (request.HasTables)
            {
                output.Tables = bimlService.GetTables( database, request.HasFactsAndDimensions );
            }
            if (request.HasFactsAndDimensions)
            {
                output.Facts = bimlService.GetFacts( database );
                output.Dimensions = bimlService.GetDimensions( database );
            }

            return output;
        }
Beispiel #2
0
        public static Biml BuildBiml(BimlRequest request)
        {
            // Configure SQL SMO
            var server           = new Server(request.ServerName);
            var scriptingOptions = new ScriptingOptions {
                Encoding = Encoding.UTF8
            };

            server.Script(scriptingOptions);
            var database = new Microsoft.SqlServer.Management.Smo.Database(server, request.DatabaseName);

            database.Refresh();

            var bimlService = new BimlService();
            var output      = new Biml();

            // Selectively build sections
            if (request.HasConnections)
            {
                output.Connections = bimlService.GetConnections(server, database);
            }
            if (request.HasDatabases)
            {
                output.Databases = bimlService.GetDatabases(database);
            }
            if (request.HasSchemas)
            {
                output.Schemas = bimlService.GetSchemas(database);
            }
            if (request.HasTables)
            {
                output.Tables = bimlService.GetTables(database, request.HasFactsAndDimensions);
            }
            if (request.HasFactsAndDimensions)
            {
                output.Facts      = bimlService.GetFacts(database);
                output.Dimensions = bimlService.GetDimensions(database);
            }

            return(output);
        }