AtomsFramework Persistence Layer Reference Guide

IRelationalDatabase Members

IRelationalDatabase overview

Public Instance Properties

ConnectionPool A collection of IConnection objects
Name The Name of the database
OidTable The OIDTable for the database
UseAnsiNulls The connection requires ANSI Null handling.

Public Instance Methods

FreeConnection Releases a connection
GetClauseStringAnd Gets the databases string for the AND clause
GetClauseStringAs Gets the databases string for the AS clause.
GetClauseStringAscend Gets the databases string for the ASCEND clause
GetClauseStringAverage Gets the databases string for the AVG() clause
GetClauseStringBetween Gets the databases string for the BETWEEN clause
GetClauseStringCount Gets the databases string for the COUNT clause
GetClauseStringDelete Gets the databases string for the DELETE clause
GetClauseStringDescend Gets the databases string for the DESCEND clause
GetClauseStringEqualTo Gets the databases string for the equal to clause
GetClauseStringForUpdate Gets the databases string for the UPDATE clause
GetClauseStringFrom Gets the databases string for the FROM clause
GetClauseStringGroupBy Gets the databases string for the GROUP BY clause
GetClauseStringHaving Gets the databases string for the HAVING clause
GetClauseStringIn Gets the databases string for the IN clause
GetClauseStringInList Gets the databases string for the IN Array clause
GetClauseStringInsert Gets the databases string for the INSERT clause
GetClauseStringIs Gets the databases string for the IS clause
GetClauseStringLeftJoin Gets the databases string for the LEFT JOIN clause
GetClauseStringLike Gets the databases string for the LIKE clause
GetClauseStringLimit Gets the databases string for the TOP or LIMIT clause
GetClauseStringMax Gets the databases string for the MAX()clause
GetClauseStringMin Gets the databases string for the MIN() clause
GetClauseStringNot Gets the databases string for the NOT clause
GetClauseStringNotEqualTo Gets the databases string for the not equal to clause
GetClauseStringOn Gets the databases string for the ON clause
GetClauseStringOr Gets the databases string for the OR clause
GetClauseStringOrderBy Gets the databases string for the ORDER BY clause
GetClauseStringSelect Gets the databases string for the SELECT clause
GetClauseStringSet Gets the databases string for the SET clause
GetClauseStringSum Gets the databases string for the SUM() clause
GetClauseStringTableAlias Gets the databases string for aliasing a table name
GetClauseStringUpdate Gets the databases string for the UPDATE clause
GetClauseStringValues Gets the databases string for the VALUES clause
GetClauseStringWhere Gets the databases string for the WHERE clause
GetConnection Obtains a connection to the database.
GetIdentityValue Gets the last identity value used by the connection.
GetNewConnection Establishes a new connection to the database.
GetNextOidAValue Gets the next A value from the databases OID table.
GetParameterHolder Returns the SQL syntax placeholder for a parameter
GetValueFor Gets a database compatible string value for an object
Init Initialise connection paramteter information for the database.
LimitClauseAtStart Indicates that the LIMIT/TOP clause should be at the start of the SQL statement
SupportsSelectOffsets Indicates that the database supports offsets in the TOP clause (mysql)
UseBracketsForJoins Indicates that the database uses brackets for grouping join clauses

See Also

IRelationalDatabase Interface | AtomsFramework Namespace