Namespace PerpetuumSoft.DataModel.MsSql contains classes representing database object model.
Classes
| Class | Description | |
|---|---|---|
| Assembly | Represents Assembly in the database structure. | |
| BoundingBox | ||
| CheckConstraint | Represents the check constaint in the database structure. | |
| CLRFunctionBase | Basic class for CLR functions. | |
| CLRType | Represents CLR type in the database structure. | |
| ColumnBase | Abstract base class for all column classes. | |
| ColumnBaseCollection | Basic class for table columns, views and computable columns. | |
| ColumnRef | Represents reference to a column. | |
| ColumnRefCollection | Represents a collection of ColumnRef. | |
| ComputedColumn | Represents the computed column in a table. | |
| Constraint | Abstract base class for all constraint classes. | |
| Database | Represents the database structure. | |
| DatabaseObject | Abstract base class for all database entities. | |
| DatabaseObjectCollection | Represents a collection of DatabaseObject. | |
| DatabaseOptions | Represents Database options. | |
| DataColumn | Represents a data column in a database table. | |
| DataColumnSql10 | ||
| DataType | Abstract base class for all column types. | |
| DataType..::.BigInt | Represents the bigint data type. | |
| DataType..::.Binary | Represents the binary data type. | |
| DataType..::.Bit | Represents the bit data type. | |
| DataType..::.Char | Represents the char data type. | |
| DataType..::.Date | ||
| DataType..::.DateSizedType | ||
| DataType..::.DateTime | Represents the datetime data type. | |
| DataType..::.DateTime2 | ||
| DataType..::.DateTimeOffset | ||
| DataType..::.Decimal | Represents the decimal data type. | |
| DataType..::.Float | Represents the float data type. | |
| DataType..::.Geography | ||
| DataType..::.Geometry | ||
| DataType..::.Hierarchyid | ||
| DataType..::.Image | Represents the image data type. | |
| DataType..::.Int | Represents the int data type. | |
| DataType..::.Money | Represents the moey data type. | |
| DataType..::.NChar | Represents the nchar data type. | |
| DataType..::.NText | Represents the ntext data type. | |
| DataType..::.Numeric | Represents the numeric data type. | |
| DataType..::.NVarChar | Represents the nvarchar data type. | |
| DataType..::.Real | Represents the real data type. | |
| DataType..::.SizedType | Abstract base class for the types defined by size. | |
| DataType..::.SmallDateTime | Represents the smalldatetime data type. | |
| DataType..::.SmallInt | Represents the smallint data type. | |
| DataType..::.SmallMoney | Represents the smallmoney data type. | |
| DataType..::.SqlVariant | Represents the sqlvariant data type. | |
| DataType..::.Text | Represents the text data type. | |
| DataType..::.Time | ||
| DataType..::.TimeStamp | Represents the timestamp data type. | |
| DataType..::.TinyInt | Represents the tinyint data type. | |
| DataType..::.TypeWithPrecision | Base class for the types defined by scale and precision. | |
| DataType..::.UniqueIdentifier | Represents the uniqueidentifier data type. | |
| DataType..::.UserCLRType | Represents user CLR type in hte database structure. | |
| DataType..::.UserTableType | ||
| DataType..::.UserType | Represents the user defined data type. | |
| DataType..::.VarBinary | Represents the varbinary data type. | |
| DataType..::.VarChar | Represents the var char data type. | |
| DataType..::.Xml | Represents the xml data type. | |
| DdlTrigger | Represents DLL trigger in the database structure. | |
| Default | Represents default value. | |
| DefaultConstraint | Represents default constraint in the database structure. | |
| Dependency | Represents dependency beetween sql objects. | |
| DependencyCollection | Represents a collection of Dependency . | |
| Element | Abstract base class for all definition cleaases of the database structure. | |
| ExtendedProperty | Represents extended properties in the database structure. | |
| ExtendedPropertyCollection | Represents the extended properties collection. | |
| ForeignKey | Represents a foreign key in the database structure. | |
| FunctionBase | Basic class for all functions in the data base structure. | |
| Grant | Represents grant of permission on the securable object in the database structure. | |
| GrantCollection | Represents collection of permission grants in the database structure. | |
| GridDestiny | ||
| Identity | Stores identity settings of a table column. | |
| Index | Represents an index in the database structure. | |
| IndexBase | Abstract base class for the index objects. | |
| IndexColumn | Represents a column in the index. | |
| IndexColumnCollection | Represents a collection of IndexColumn . | |
| IndexFilter | ||
| IndexSql10 | ||
| InlineTableValuedFunction | Represents the inline table valued function in the database structure. | |
| InParameter | Represents input parameter for the function and stored procedure in a data base structure. | |
| KeyConstraint | Abtsract base class for the primary key and unique key objects. | |
| MultistatementTableValuedFunction | Represents the multistatement table valued function in the database structure. | |
| OutParameter | Represents the function output parameter in the database structure. | |
| ParameterBase | Basic class for function parameters. | |
| ParameterBaseCollection | Represents collection of function parameters in the database structure. | |
| ParameterOrderRef | ||
| Permission | Represents permission in the database structure. | |
| PermissionCollection | Represents collection of permissions in the database structure. | |
| PrimaryKey | Represents a primary key in the database structure. | |
| Principal | Represents principal in the database structure. Base class for users and roles. | |
| Role | Represents role in the database structure. | |
| RoleMember | Represents role member in the database structure. | |
| RoleMemberCollection | Represents collection of the role members. | |
| Rule | Represents rule in database structure. | |
| RuleDefaultObject | Represents object containing reference to ISupportRulesDefaults | |
| RuleDefaultObjectCollection | Represents collection of objects of the RuleDefaultObject type. | |
| ScalarCLRFunction | Represents scalar CLR functions in the database structure. | |
| ScalarFunction | Represents scalar function in the database structure. | |
| Schema | Represent the schema in the database structure. | |
| SchemaObject | Base class for the schema-aware objects. | |
| SpatialIndexSql10 | ||
| StoredProcedure | Represents the stored procedure in the database structure. | |
| Synonym | Represents synonym in the database structure. | |
| Table | Represents a table in the database structure. | |
| TableBase | Abstract superclass for the table and view objects. | |
| TableColumn | Represents table column in the database structure. | |
| TableTypeSql10 | ||
| TableValuedCLRFunction | Represents the table valued CLR function in the database structure. | |
| TableValuedCLRFunctionSql10 | ||
| TableValuedFunction | Represents the table valued function in the database structure. | |
| TextFunction | Basic class for functions and stored procedures. | |
| Trigger | Represents trigger in the database structure. | |
| UniqueConstraint | Represents an unique constraint. | |
| User | Represents user in the database structure. | |
| UserDefinedType | Represents a user defined type in the database structure. | |
| View | Represents a view in the database structure. | |
| ViewColumn | Represents a column in a view. | |
| XmlIndex | Represents xml index in the database structure. | |
| XmlSchemaCollection | Represents collection of xml schemas in the database structure. |
Interfaces
| Interface | Description | |
|---|---|---|
| ISchemaObject | Unites all schema-related objects. | |
| ISecurable | Unites all securable objects. | |
| ISupportRulesDefaults | Unites all objects supporting default values and rules. |
Enumerations
| Enumeration | Description | |
|---|---|---|
| DefaultCursor | DefaultCursor. | |
| DestinyEnum | ||
| ExecuteAsClause | Represents possible values of the function security context. | |
| ForeignKeyAction | Enumerates foreign key action types. | |
| GrantAction | Represents action on granting permission on the securable object. | |
| GrantMode | Represents mode to grant permission on the securable object . | |
| IndexColumnOrder | Represents an order of the index elements. | |
| NullInputOption | Represents options of function execution subject to the input values. | |
| PageVerify | PageVerify. | |
| Parameterization | Parameterization. | |
| PermissionSet | Represents set of assembly permissions in the database structure. | |
| RoleType | Represents role type in the database structure. | |
| SqlVersionEnum | ||
| TessellationSchema | ||
| UserType | Represents user type in the database structure. | |
| XmlIndexType | Represents xml index type. |