Deveel.Data.Sql Namespace Reference

Namespaces
namespace	Compile
namespace	Cursors
namespace	Expressions
namespace	Fluid
namespace	Objects
namespace	Parser
namespace	Query
namespace	Schemas
namespace	Sequences
namespace	Statements
namespace	Tables
namespace	Triggers
namespace	Variables
namespace	Views

Classes
struct	CellId
class	CreateTableTests
class	CursorTests
class	DropTableTests
class	ExceptionHandler
class	ExecutionContext
class	HandledExceptions
interface	IDbObject
	Represents a database object, such as a table, a trigger, a type or a column. More...
interface	IExecutable
interface	IGroupResolver
	Defines a contract used by grouping functions to find information about the current group being evaluated. More...
class	IndexInfo
class	IndexSetInfo
class	InsertTests
interface	IObjectInfo
interface	IObjectManager
	Defines the contract for the business managers of database objects of a given type. More...
interface	ISequenceManager
	Manages the sequences within an isolated context. More...
interface	ITableVariableResolver
interface	IVariableResolver
	An interface to resolve a variable name to a constant object. More...
class	JoinTableTests
class	MutableTableTests
class	ObjectName
	Describes the name of an object within a database. More...
class	QueryContextExtensions
class	QueryExtensions
class	QueryLimit
class	QueryParameter
class	SchemaTypes
class	SortColumn
	Object used to represent a column in the ORDER BY clauses of a select statement. More...
class	SqlErrorException
class	SqlModelErrorCodes
	Enumerates a known set of codes in a SQL Model More...
class	SqlQuery
class	SqlQueryExtensions
class	TableQueryTests
class	VariableTests

Enumerations
enum	CompositeFunction { CompositeFunction.Union = 1, CompositeFunction.Intersect = 2, CompositeFunction.Except = 3, CompositeFunction.None = -1 }
	The kind of composite function in a CompositeTable. More...
enum	DbObjectType {   DbObjectType.Table = 1, DbObjectType.View = 2, DbObjectType.Type = 4, DbObjectType.Variable = 8,   DbObjectType.Row = 10, DbObjectType.Column = 11, DbObjectType.Trigger = 17, DbObjectType.Sequence = 18,   DbObjectType.Routine = 20, DbObjectType.Cursor = 25, DbObjectType.Schema = 51 }
	The kind of objects that can be handled by a database system and its managers More...
enum	QueryParameterDirection { QueryParameterDirection.In = 1, QueryParameterDirection.Out = 2, QueryParameterDirection.InOut = In | Out }
enum	QueryParameterStyle { QueryParameterStyle.Default = 0, QueryParameterStyle.Named = 1, QueryParameterStyle.Marker = 2 }
	In a SQL query object, this is the form of parameters passed from the client side to the server side, defining the identification of the single parameters passed. More...
enum	SequenceType { SequenceType.Native = 1, SequenceType.Normal = 2 }
	The form of a ISequence object in a transaction. More...

Enumeration Type Documentation

enum Deveel.Data.Sql.CompositeFunction

strong

The kind of composite function in a CompositeTable.

Enumerator
Union	The composite function for finding the union of the tables.
Intersect	The composite function for finding the interestion of the tables.
Except	The composite function for finding the difference of the tables.
None	An unspecified composite function.

Definition at line 25 of file CompositeFunction.cs.

                                  {
        Union = 1,

        Intersect = 2,

        Except = 3,

        None = -1
    }

enum Deveel.Data.Sql.DbObjectType

strong

The kind of objects that can be handled by a database system and its managers

See also

IObjectManager

Enumerator
Table	A TABLE object in a database.
View	A VIEW object obtained by a source query.
Type	A user-defined TYPE that holds complex objects in a database column.
Variable	A single variable within a query context or in the system global context.
Row	A single ROW in a database table, that holds tabular data as configured by the table specifications.
Column	The single COLUMN of a table in a database, handling the form of data that can be stored in a cell.
Trigger	A TRIGGER fired at provided write events (INSERT, UPDATE or DELETE) over a table at a given moments (BEFORE or AFTER).
Sequence	A SEQUENCE of numeric values that can be native or user-defined with given configuration.
Routine	A routine (PROCEDURE or FUNCTION) defined in a database, that is a program with defined input parameters and optional output values or return value (in FUNCTION).
Cursor	A cursor is a named, precomputed, query, that accepts optional parameters and handles a state of the iteration over the query.
Schema	A SCHEMA object, that is a named container of multiple types of objects (eg. TABLE, PROCEDURE, VIEW, etc.).

Definition at line 27 of file DbObjectType.cs.

                             {
        Table = 1,

        View = 2,

        Type = 4,

        Variable = 8,

        Row = 10,

        Column = 11,

        Trigger = 17,

        Sequence = 18,

        Routine = 20,

        Cursor = 25,

        Schema = 51
    }

enum Deveel.Data.Sql.QueryParameterDirection

strong

Enumerator
In
Out
InOut

Definition at line 21 of file QueryParameterDirection.cs.

                                        {
        In = 1,
        Out = 2,
        InOut = In | Out
    }

enum Deveel.Data.Sql.QueryParameterStyle

strong

In a SQL query object, this is the form of parameters passed from the client side to the server side, defining the identification of the single parameters passed.

See also

SqlQuery.ParameterStyle

Enumerator
Default	No specific form of the parameter was given: this default to the system default parameter style configured.
Named	Defines parameters uniquely identified within the query context by a name. In this form query parameter names must be prefixed by the </c> character.
Marker	Parameters that are replaced on a zero-based index of the input parameters of a query. These parameters are not identified by a unique name, but by a ? character that acts as a place-holder for an input parameter.

Definition at line 27 of file QueryParameterStyle.cs.

                                    {
        Default = 0,

        Named = 1,

        Marker = 2
    }

enum Deveel.Data.Sql.SequenceType

strong

The form of a ISequence object in a transaction.

See also

ISequence, ISequence.SequenceInfo, SequenceInfo.Type

Enumerator
Native	A sequence on a table that is handled natively by the system. Typically, this is the unique incremental number of record entries in a table.
Normal	Denotes a sequence created by the user and that has a specified incremental factor, and other attributes.

Definition at line 26 of file SequenceType.cs.

                             {
        Native = 1,

        Normal = 2
    }