Example #1
0
        private void AddDataTypes(TreeNode typesNode)
        {
            var schemas = Database.Dmvs.Schemas.ToDictionary(x => x.schema_id);

            var types = Database.Dmvs.Types.Where(x => !x.IsTableType && x.IsUserDefined)
                        .Select(x => new { Name = $"{schemas[x.SchemaID].name}.{x.Name}", Description = DatabaseMetaData.GetTypeName(Database.Dmvs, x, true) })
                        .OrderBy(t => t.Name).ToArray();

            if (types.Length == 0)
            {
                return;
            }

            var tableNode = typesNode.Nodes.Add("User-Defined Data Types");

            foreach (var type in types)
            {
                /*var typeNode =*/ tableNode.Nodes.Add($"{type.Name} ({type.Description})");
                //typeNode.ContextMenu = dataTypeMenu;
            }
        }