C# (CSharp) Bamboo.Mssql.Database Examples

Example #1

File: Schema.cs Project: mstanford/water

        public static Bamboo.Mssql.Database Read(string connectionString)
        {
            System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectionString);
            connection.Open();

            Bamboo.Mssql.Database database = new Bamboo.Mssql.Database();

            database.Name          = connection.Database;
            database.Tables        = ReadTables(connection);
            database.Relationships = ReadRelationships(connection);
            database.Views         = ReadViews(connection);
            database.Procedures    = ReadProcedures(connection);

            connection.Close();

            return(database);
        }

Example #2

File: DatabaseTreeNode.cs Project: mstanford/water

        public DatabaseTreeNode(string connectionString)
        {
            Bamboo.Mssql.Database database = SqlSchemaReader.Read(connectionString);

            this.Text = database.Name;
            this.Tag  = database;

            this.ImageIndex         = Images.Database;
            this.SelectedImageIndex = Images.Database;

            TablesTreeNode tablesTreeNode = new TablesTreeNode(database.Tables);

            this.Nodes.Add(tablesTreeNode);

            ViewsTreeNode viewsTreeNode = new ViewsTreeNode(database.Views);

            this.Nodes.Add(viewsTreeNode);

            ProceduresTreeNode proceduresTreeNode = new ProceduresTreeNode(database.Procedures);

            this.Nodes.Add(proceduresTreeNode);
        }