BimlGen.BimlService.GetSchemas C# (CSharp) Method

GetSchemas() public method

public GetSchemas ( Microsoft database ) : List
database Microsoft
return List
        public List<Schema> GetSchemas( Microsoft.SqlServer.Management.Smo.Database database )
        {
            var schemas = new List<Schema>();
            foreach (Microsoft.SqlServer.Management.Smo.Schema schema in database.Schemas)
            {
                var bimlSchema = new Schema
                    {
                        DatabaseName = database.Name,
                        Name = schema.Name,
                        Owner = schema.Owner,
                    };

                var annotations = GetAnnotations( schema.ExtendedProperties );
                if (annotations.Any())
                    bimlSchema.Annotations = annotations;

                schemas.Add( bimlSchema );
            }
            return schemas;
        }

Usage Example

Example #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;
        }
All Usage Examples Of BimlGen.BimlService::GetSchemas