Inetdev Framework

ISchemaDiscoverer

Allows the implementation of code that discover a database schema.

Namespace:
Inetdev.Data.DatabaseSchema
Type:
Interface
Public:
Yes
Protected:
No
Sealed:
No
Abstract:
Yes

Properties

CommandBuilder

Database command builder.

Signature:
public IDbCmdBuilder CommandBuilder { get; set; }

DataAccessAPI

Database access.

Signature:
public IDbAccess DataAccessAPI { get; set; }

Methods

ExistsSchema

Checks whether a schema exists.

Signature:
public Boolean ExistsSchema(schema)
Returns

true if the schema exists.

Parameters
Name Type Summary
schema Schema Schema to check.

ExistsTable

Checks whether a table exists.

Signature:
public Boolean ExistsTable(schema, tableName)
Returns

true if the table exists.

Parameters
Name Type Summary
schema String Schema to which the table belongs to.
tableName String Name of the table to check.

ExistsTable

Checks whether a table exists.

Signature:
public Boolean ExistsTable(table)
Returns

true if the table exists.

Parameters
Name Type Summary
table Table Table to check.

ExistsView

Checks whether a view exists.

Signature:
public Boolean ExistsView(schema, viewName)
Returns

true if the view exists.

Parameters
Name Type Summary
schema String Schema to which the view belongs to.
viewName String Name of the view to check.

ExistsView

Checks whether a view exists.

Signature:
public Boolean ExistsView(view)
Returns

true if the view exists.

Parameters
Name Type Summary
view Table View to check.

GetCatalogs

Gets a list of user created catalogs.

Signature:
public IEnumerable<Catalog> GetCatalogs()
Returns

A list of user catalogs.

GetSchemas

Gets a list of user created schemas.

Signature:
public IEnumerable<Schema> GetSchemas()
Returns

A list of schemas.

GetTable

Gets a table schema from the database;

Signature:
public Table GetTable(schema, tableName)
Returns

A table definition.

Parameters
Name Type Summary
schema String Schema that the table belongs to.
tableName String The name of the table.

GetTable

Gets a table schema from the database.

Signature:
public Table GetTable(tableName)
Returns

A table definition.

Parameters
Name Type Summary
tableName TableName Name of the table.

GetTableNames

Gets a list of table names from the database.

Signature:
public IEnumerable<TableName> GetTableNames()
Returns

A list of table names.

GetTables

Gets a list of all tables from the database.

Signature:
public IEnumerable<Table> GetTables()
Returns

A collection of tables.

GetView

Gets a view schema from the database.

Signature:
public Table GetView(schema, viewName)
Returns

A definition for the specified view.

Parameters
Name Type Summary
schema String Schema to which the view belongs to.
viewName String Name of the view.

GetView

Gets a view schema from the database.

Signature:
public Table GetView(viewName)
Returns

A definition for the specified view.

Parameters
Name Type Summary
viewName TableName Name of the view.

GetViewNames

Gets a list of view names from the database.

Signature:
public IEnumerable<TableName> GetViewNames()
Returns

A list of view names.

GetViews

Gets a list of all views from the database.

Signature:
public IEnumerable<Table> GetViews()
Returns

A collection of views.

In this document