

About dbschema information code#
Currently the source code in repository includes an example of using the library with NHibernate.If you’re a database developer, you know the time saving value of being able to visually design, document and query SQL and NoSQL databases from a single UI. Personally, I have used the library in T4 templates, creating classes that use SubSonic3 and NHibernate. In order to make the T4 include template compact, and include only data providers needed use the MakeT4Template.vbs utility.

T4 Include Template: An T4 template that can be included from other T4 templates, in order to provide functionality in T4 templates tranformation.Binary: An assembly that can be used in.Implementing support for new databases is easy and fast. One can retrieve the names of all store procedures ( DbSchema.GetProcedures()), and their parameters ( DbSchema.GetProcedureParameters()) ExtensibilityĬore functions needed for each database type, are implemented through interface. Also the Many-To-Many relation tables ( DbSchema.GetTablesManyToManyRelations()) can be retrieved. Retrieving table relations ( DbSchema.GetConstraints()), by passing the table schema and name, one can retrieve, the One-to-Many relations ( DbSchema.GetTableOneToManyRelations()) and Many-to-One relations ( DbSchema.GetTableManyToOneRelations()) a table is participating. Passing the schema and name of a table, one can retrieve its columns ( DbSchema.GetTableColumns()), columns that compose the primary key ( DbSchema.GetTablePrimaryKe圜olumns()) or the columns that are not part of the table's primary key, and are not part of foreign key definitions ( DbSchema.GetTableFields()). Using the library gives you the methods to easily retrieve tables and views ( DbSchema.GetSchemaTables()), only tables ( DbSchema.GetTables()), only views ( DbSchema.GetViews()) or tables that are not part in ManyToMany relationships ( DbSchema.GetTablesLogical()). It uses objects to access databases, and System.Reflection to access common database provider methods, which are not exposed via - only for procedure parameter retrieving. It has no hard-references to database provider assemblies. This request gave me the idea to create this library.Ĭurrently offers support for: Being involved in a project that created code depending on a database schema, using T4 templates, I had to find a way to recycle the schema retrieving code for various databases.Ĭontributing on T4 templates and schema retrieving code for SubSonic3, Rob Conery asked for a simple schema retrieving engine, with no hard references on database provider assemblies. More or less, every developer has the need to create custom code depending in a database's schema. You'll no longer have to create your custom code in order to extract schema from your databases.

NET programmers to extract a database's schema (tables, views, columns, procedures, procedures' parameters and relations). Project DescriptionĭbSchema makes it easier for.

