DacpacExplorer.Pages.PropertiesPageBuilder.GetPropertiesDisplayForDacpac C# (CSharp) Méthode

GetPropertiesDisplayForDacpac() public méthode

public GetPropertiesDisplayForDacpac ( TSqlModel model ) : UIElement
model TSqlModel
Résultat UIElement
        public UIElement GetPropertiesDisplayForDacpac(TSqlModel model)
        {
            var panel = GetPropertiesDisplayPanel("Target Sql Version: " + model.Version);

            var options = model.CopyModelOptions();
            panel.Children.Add(GetSimplePropertyLabel("Database Properties:"));

            foreach (var prop in options.GetType().GetProperties().OrderBy(p => p.Name))
            {
                var val = prop.GetValue(options) as object;
                if (val == null)
                {
                    val = "NULL";
                }

                panel.Children.Add(GetPropertyLabel(prop.Name, val.ToString()));
            }

            return panel;
        }

Usage Example

Exemple #1
0
        public void Display()
        {
            TreeView.Items.Clear();

            var repository = ModelRepository.GetRepository();

            _model = repository.GetModel();

            var propertiesPageBuilder = new PropertiesPageBuilder();

            var dacpacNode = AddRootTreeItem("Dacpac Properties");

            dacpacNode.Tag = new CachedObjectDisplay
            {
                Properties = propertiesPageBuilder.GetPropertiesDisplayForDacpac(_model),
                Script     = ""
            };

            if (repository.ValidateModel())
            {
                var messages     = _model.Validate();
                var messagesNode = AddTreeItem("Validation Result", dacpacNode, _defaultForeground);
                messagesNode.Tag = new CachedObjectDisplay
                {
                    Properties = propertiesPageBuilder.GetPropertiesDisplayForValidationMessages(messages),
                    Script     = ""
                };
            }


            DisplayTopLevelNode("Tables", ModelSchema.Table);
            DisplayTopLevelNode("Views", ModelSchema.View);

            var programabililtyNode = AddRootTreeItem("Programmability");

            DisplayTopLevelNode(programabililtyNode, "Procedures", ModelSchema.Procedure);
            DisplayTopLevelNode(programabililtyNode, "Scalar Functions", ModelSchema.ScalarFunction);
            DisplayTopLevelNode(programabililtyNode, "Table-Valued Functions", ModelSchema.TableValuedFunction);
            DisplayTopLevelNode(programabililtyNode, "Database Triggers", ModelSchema.DatabaseDdlTrigger);
            DisplayTopLevelNode(programabililtyNode, "Server Triggers", ModelSchema.ServerDdlTrigger);
            DisplayTopLevelNode(programabililtyNode, "Assemblies", ModelSchema.Assembly);

            var securityNode = AddRootTreeItem("Security");

            DisplayTopLevelNode(securityNode, "Server Logins", ModelSchema.Login);
            DisplayTopLevelNode(securityNode, "Database Users", ModelSchema.User);
            DisplayTopLevelNode(securityNode, "Schemas", ModelSchema.Schema);
            DisplayTopLevelNode(securityNode, "Roles", ModelSchema.Role);

            Cursor = Cursors.Arrow;
        }
All Usage Examples Of DacpacExplorer.Pages.PropertiesPageBuilder::GetPropertiesDisplayForDacpac