Classes

  ClassDescription
AnsiSubstringFunction
ANSI-SQL substring Documented in: ANSI X3.135-1992 American National Standard for Information Systems - Database Language - SQL
AnsiTrimEmulationFunction
A SQLFunction implementation that emulates the ANSI SQL trim function on dialects which do not support the full definition. However, this function definition does assume the availability of ltrim, rtrim, and replace functions which it uses in various combinations to emulate the desired ANSI trim() functionality.
CastFunction
ANSI-SQL style cast(foo as type) where the type is a NHibernate type
CharIndexFunction
Emulation of locate() on Sybase
ClassicAggregateFunction
ClassicAvgFunction
Classic AVG sqlfunction that return types as it was done in Hibernate 3.1
ClassicCountFunction
Classic COUNT sqlfunction that return types as it was done in Hibernate 3.1
ClassicSumFunction
Classic SUM sqlfunction that return types as it was done in Hibernate 3.1
NoArgSQLFunction
Summary description for NoArgSQLFunction.
NvlFunction
Emulation of coalesce() on Oracle, using multiple nvl() calls
PositionSubstringFunction
Emulation of locate() on PostgreSQL
SQLFunctionRegistry
SQLFunctionTemplate
Represents HQL functions that can have different representations in different SQL dialects. E.g. in HQL we can define function
 Copy Code
concat(?1, ?2)
to concatenate two strings p1 and p2. Target SQL function will be dialect-specific, e.g.
 Copy Code
(?1 || ?2)
for Oracle,
 Copy Code
concat(?1, ?2)
for MySql,
 Copy Code
(?1 + ?2)
for MS SQL. Each dialect will define a template as a string (exactly like above) marking function parameters with '?' followed by parameter's index (first index is 1).
StandardSQLFunction
Provides a standard implementation that supports the majority of the HQL functions that are translated to SQL.
VarArgsSQLFunction
Support for slightly more general templating than StandardSQLFunction, with an unlimited number of arguments.

Interfaces

  InterfaceDescription
ISQLFunction
Provides support routines for the HQL functions as used in the various SQL Dialects Provides an interface for supporting various HQL functions that are translated to SQL. The Dialect and its sub-classes use this interface to provide details required for processing of the function.