Kpok Patagon Framework

SchemaDiscoverer

Implements basic functionality for ISchemaDiscoverers.

Namespace:
KpokPatagon.Data.DatabaseSchema
Type:
Class
Public:
Yes
Protected:
No
Sealed:
No
Abstract:
Yes
Implements:
KpokPatagon.Data.DatabaseSchema.ISchemaDiscoverer

Properties

CommandBuilder

Gets or sets the command builder service.

Signature:
public IDbCmdBuilder CommandBuilder { 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 IList GetCatalogs()
Returns

A list of user catalogs.

GetSchemas

Gets a list of user created schemas.

Signature:
public IList 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 IList GetTableNames()
Returns

A list of table names.

GetTables

Gets a list of all tables from the database.

Signature:
public IList 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 IList GetViewNames()
Returns

A list of view names.

GetViews

Gets a list of all views from the database.

Signature:
public IList GetViews()
Returns

A collection of views.

In this document