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;
}