Namespace Albatross.Database
This namespace defines objects that represent database objects such as table, view, procedures etc. It also defines interfaces to retrieve the objects from a database.
- target framework
- netstandard2.0
- net46
Classes
Column
Database
A particular database on a server. The object should have enough information to generate a database connection string.
DatabasePermission
Index
The class represents a table index
IndexColumn
The class represents an column of an index
Parameter
The class represents a stored procedure parameter
Procedure
The class represents a database stored procedure
SqlType
The class represents a database data type
Table
The class represents a database table
Variable
The class represents a sql variable
View
The class represents a database view
Interfaces
ICheckProcedureCreated
IDatabaseObject
IDeployProcedure
IGetConnectionString
Provide with an Database object, the interface can produce a connection string by invoking the Get(Database) function.
IGetDatabasePermission
IGetDbConnection
Provided with a Database input, the interface will return a database connection object
IGetProcedure
Provide with a Database object, the schema and name of a stored procedure, the interface will query the database and populate a Procedure object
IGetProcedureDefinition
IGetSqlType
Provide with a Database object, the schema and name of a sql type, the interface will query the database and populate a SqlType object For system types, schema could be null or in case of microsoft sql server - "sys".
IGetTable
Provided with a Database object, schema and name, the interface will query and return a Table object.
IGetTableColumnType
The interface will return the SqlType for the specified Table and Column
IGetView
Provided with a Database object, schema and name, the interface will query the database and return a View object.
IListProcedure
search the database for stored procedures that match the criteria
IListProcedureParameter
The interface will query the database and return the list of Parameter for the Procedure object.
IListSqlType
The interface will return all the SqlType in the specified Database
IListTable
search the database for table that match the criteria
IListTableColumn
The interface will return all Column for the specified Table object.
IListTableIndex
The interface will return all the Index of the specified Table
IListTableIndexColumn
The interface will return all the IndexColumn for the specified Index