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).
Namespace:
NHibernate.Dialect.Function
Assembly:
NHibernate (in NHibernate.dll)
Syntax
Visual Basic (Declaration) |
---|
Public Class SQLFunctionTemplate _
Implements ISQLFunction |
Visual C++ |
---|
public ref class SQLFunctionTemplate : ISQLFunction |
Inheritance Hierarchy
See Also