Codesmith's schemaexplorer component

Schemaexplorer encapsulates all database objects. Database schemas such as databaseschema, tableschema, and columnschema are provided, and data source information is extracted by dynamically loading Assembly. This function is implemented by the idbschemaprovider interface. Many components are provided on codesmith's website. V3.1 provides adoxschemaprovider and sqlschemaprovider for accessing ADO and SQL databases, similar to oledbdataadpater and sqldataadpater In ADO. net. Databaseschema represents a database. Constructed based on connnectionstring and idbschemaprovider. Its main attributes are tableschmeacollection and viewschemacollection, which provide the data table and data view information of the database. Tableschema represents a database table. It mainly provides columnschemacollection. That is, the column data of the data table. Columnschema indicates the columns of a data table. The main attributes are columnname, systemtype, columntype, isprimarykeymember, and so on. Extendedpropertycollection is provided for all the above three types to store extended information. This collection is similar to hashtable. In addition, special information about databases of this type provided by many database providers is also stored here. reference method: call the Program set that contains schemaexplorer, similar. add reference in. Net <% @ Assembly name = "schemaexplorer" %> use the import label to import the namespace of schemaexplorer, similar to using in C. <% @ import namespace = "schemaexplorer" %> tableschema-type attribute datatable detection table and table-based content and attribute templates. <% @ property name = "sourcetable" type = "schemaexplorer. tableschema "Category =" datatable "Description =" table that the stored procedures shocould be based on. "%> type: attribute value data type category: the type of this attribute displayed on the attribute panel of codesmith explorer , such as drop-down selection and direct input.