Namespace PerpetuumSoft.DataModel.MsSql contains classes representing database object model.

Classes

  ClassDescription
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

  InterfaceDescription
ISchemaObject
Unites all schema-related objects.
ISecurable
Unites all securable objects.
ISupportRulesDefaults
Unites all objects supporting default values and rules.

Enumerations

  EnumerationDescription
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.