Namespace DbExport.Schema

Classes

Column

Represents a column in a database table with metadata and attributes that provide detailed information about its configuration and behavior within the schema.

ColumnCollection

Represents a collection of database columns.

ColumnSet

Represents an abstract base class for a set of related columns within a database schema. Provides functionality to manage the state of column checks and evaluate check conditions.

DataType

Represents a user-defined database data type with associated metadata such as size, precision, scale, and other characteristics.

DataTypeCollection

Represents a collection of database data types.

Database

Represents a database within the schema, containing metadata about its provider, connection information, data types, and tables. It serves as the root schema item for database-related operations.

ForeignKey

Represents a foreign key constraint in a database schema. This class provides details about the referenced table, the columns involved, and the actions to take on update or delete.

ForeignKeyCollection

Represents a collection of database foreign keys.

Index

Represents a database index associated with a table. An index is used to enhance the performance of database queries by providing quick access to rows in a table based on the values of one or more columns.

IndexCollection

Represents a collection of database indexes.

Key

Represents an abstract base class for database keys, such as primary keys, foreign keys, and indexes. Provides functionality to manage columns associated with the key and to compare key signatures.

PrimaryKey

Represents the primary key of a database table. A primary key uniquely identifies each record in the table and enforces entity integrity within the database schema.

SchemaItem

Represents a base class for all schema items.

SchemaItemCollection<TItem>

Represents a collection of strongly typed schema items, providing functionality for indexing, addition, removal, and lookup based on item names. This collection is intended to manage schema items that inherit from the SchemaItem class.

Table

Represents a database table, which is a specialized ColumnSet containing columns, constraints, and relationships to other tables.

TableCollection

Represents a collection of database tables.

TableExtensions

Contains extension methods for performing various database operations on a Table object. These operations include generating SQL statements (SELECT, INSERT, UPDATE, DELETE), executing queries, and managing batch operations.

Interfaces

ICheckable

Represents an item that can be checked or unchecked.

IDataItem

Represents a data item that encapsulates schema-related properties and metadata for a database column or type definition.

Enums

ColumnAttributes

Specifies a set of attributes that can be associated with a database column.

ColumnType

Represents the types of columns that can be used in a database schema. This enumeration provides a comprehensive list of supported data types including numeric, textual, date/time, binary, and user-defined types.

ForeignKeyRule

Defines the actions to be taken when a foreign key constraint is violated or when referenced data is modified or deleted.

QueryOptions

Specifies options for customizing the behavior of query generation in database operations. These options determine how tables and columns are processed and formatted during SQL generation.