Represents HQL functions that can have different representations in different SQL dialects.
E.g. in HQL we can define function
CopyC# to concatenate two strings
p1 and p2. Target SQL function will be dialect-specific, e.g.
CopyC# for
Oracle,
CopyC# for MySql,
CopyC# 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).
Namespace: NHibernate.Dialect.Function![](../icons/CopyCode.gif)
concat(?1, ?2)
![](../icons/CopyCode.gif)
(?1 || ?2)
![](../icons/CopyCode.gif)
concat(?1, ?2)
![](../icons/CopyCode.gif)
(?1 + ?2)
Assembly: NHibernate (in NHibernate.dll) Version: 3.2.0.4000 (3.2.0.4000)
Syntax
C# |
---|
[SerializableAttribute] public class SQLFunctionTemplate : ISQLFunction |
Visual Basic |
---|
<SerializableAttribute> _ Public Class SQLFunctionTemplate _ Implements ISQLFunction |
Visual C++ |
---|
[SerializableAttribute] public ref class SQLFunctionTemplate : ISQLFunction |
Inheritance Hierarchy
System..::..Object
NHibernate.Dialect.Function..::..SQLFunctionTemplate
NHibernate.Dialect.Function..::..AnsiExtractFunction
NHibernate.Dialect.Function..::..AnsiTrimFunction
NHibernate.Dialect.Function..::..SQLFunctionTemplate
NHibernate.Dialect.Function..::..AnsiExtractFunction
NHibernate.Dialect.Function..::..AnsiTrimFunction