The ISQLQuery type exposes the following members.
Methods
Name | Description | |
---|---|---|
AddEntity(String) |
Declare a "root" entity, without specifying an alias
| |
AddEntity(Type) |
Declare a "root" entity, without specifying an alias
| |
AddEntity(String, String) |
Declare a "root" entity
| |
AddEntity(String, Type) |
Declare a "root" entity
| |
AddEntity(String, String, LockMode) |
Declare a "root" entity, specifying a lock mode
| |
AddEntity(String, Type, LockMode) |
Declare a "root" entity, specifying a lock mode
| |
AddJoin(String, String) |
Declare a "joined" entity
| |
AddJoin(String, String, LockMode) |
Declare a "joined" entity, specifying a lock mode
| |
AddScalar |
Declare a scalar query result
| |
Enumerable()()()() |
Return the query results as an IEnumerable. If the query contains multiple results
per row, the results are returned in an instance of object[].
(Inherited from IQuery.) | |
Enumerable<(Of <<'(T>)>>)()()()() |
Strongly-typed version of Enumerable()()()().
(Inherited from IQuery.) | |
ExecuteUpdate |
Execute the update or delete statement.
(Inherited from IQuery.) | |
Future<(Of <<'(T>)>>) |
Get a enumerable that when enumerated will execute
a batch of queries in a single database roundtrip
(Inherited from IQuery.) | |
FutureValue<(Of <<'(T>)>>) |
Get an IFutureValue instance, whose value can be retrieved through
its Value property. The query is not executed until the Value property
is retrieved, which will execute other Future queries as well in a
single roundtrip
(Inherited from IQuery.) | |
List()()()() |
Return the query results as an IList. If the query contains multiple results per row,
the results are returned in an instance of object[].
(Inherited from IQuery.) | |
List(IList) |
Return the query results an place them into the IList.
(Inherited from IQuery.) | |
List<(Of <<'(T>)>>)()()()() |
Strongly-typed version of List()()()().
(Inherited from IQuery.) | |
SetAnsiString(Int32, String) |
Bind an instance of a String to an indexed parameter
using an NHibernate AnsiStringType.
(Inherited from IQuery.) | |
SetAnsiString(String, String) |
Bind an instance of a String to a named parameter
using an NHibernate AnsiStringType.
(Inherited from IQuery.) | |
SetBinary(Int32, array<Byte>[]()[][]) |
Bind an instance of a Byte array to an indexed parameter
using an NHibernate BinaryType.
(Inherited from IQuery.) | |
SetBinary(String, array<Byte>[]()[][]) |
Bind an instance of a Byte array to a named parameter
using an NHibernate BinaryType.
(Inherited from IQuery.) | |
SetBoolean(Int32, Boolean) |
Bind an instance of a Boolean to an indexed parameter
using an NHibernate BooleanType.
(Inherited from IQuery.) | |
SetBoolean(String, Boolean) |
Bind an instance of a Boolean to a named parameter
using an NHibernate BooleanType.
(Inherited from IQuery.) | |
SetByte(Int32, Byte) | (Inherited from IQuery.) | |
SetByte(String, Byte) | (Inherited from IQuery.) | |
SetCacheable |
Enable caching of this query result set.
(Inherited from IQuery.) | |
SetCacheMode | Override the current session cache mode, just for this query. (Inherited from IQuery.) | |
SetCacheRegion | (Inherited from IQuery.) | |
SetCharacter(Int32, Char) | (Inherited from IQuery.) | |
SetCharacter(String, Char) | (Inherited from IQuery.) | |
SetComment | Add a comment to the generated SQL. (Inherited from IQuery.) | |
SetDateTime(Int32, DateTime) |
Bind an instance of a DateTime to an indexed parameter
using an NHibernate DateTimeType.
(Inherited from IQuery.) | |
SetDateTime(String, DateTime) |
Bind an instance of a DateTime to a named parameter
using an NHibernate DateTimeType.
(Inherited from IQuery.) | |
SetDateTime2(Int32, DateTime) | (Inherited from IQuery.) | |
SetDateTime2(String, DateTime) | (Inherited from IQuery.) | |
SetDateTimeOffset(Int32, DateTimeOffset) | (Inherited from IQuery.) | |
SetDateTimeOffset(String, DateTimeOffset) | (Inherited from IQuery.) | |
SetDecimal(Int32, Decimal) |
Bind an instance of a Decimal to an indexed parameter
using an NHibernate DecimalType.
(Inherited from IQuery.) | |
SetDecimal(String, Decimal) |
Bind an instance of a Decimal to a named parameter
using an NHibernate DecimalType.
(Inherited from IQuery.) | |
SetDouble(Int32, Double) |
Bind an instance of a Double to an indexed parameter
using an NHibernate DoubleType.
(Inherited from IQuery.) | |
SetDouble(String, Double) |
Bind an instance of a Double to a named parameter
using an NHibernate DoubleType.
(Inherited from IQuery.) | |
SetEntity(Int32, Object) |
Bind an instance of a mapped persistent class to an indexed parameter.
(Inherited from IQuery.) | |
SetEntity(String, Object) |
Bind an instance of a mapped persistent class to a named parameter.
(Inherited from IQuery.) | |
SetEnum(Int32, Enum) |
Bind an instance of a persistent enumeration class to an indexed parameter
using an NHibernate PersistentEnumType.
(Inherited from IQuery.) | |
SetEnum(String, Enum) |
Bind an instance of a persistent enumeration class to a named parameter
using an NHibernate PersistentEnumType.
(Inherited from IQuery.) | |
SetFetchSize | Set a fetch size for the underlying ADO query. (Inherited from IQuery.) | |
SetFirstResult |
Sets the first row to retrieve.
(Inherited from IQuery.) | |
SetFlushMode |
Override the current session flush mode, just for this query.
(Inherited from IQuery.) | |
SetGuid(Int32, Guid) | (Inherited from IQuery.) | |
SetGuid(String, Guid) | (Inherited from IQuery.) | |
SetInt16(Int32, Int16) | (Inherited from IQuery.) | |
SetInt16(String, Int16) | (Inherited from IQuery.) | |
SetInt32(Int32, Int32) | (Inherited from IQuery.) | |
SetInt32(String, Int32) | (Inherited from IQuery.) | |
SetInt64(Int32, Int64) | (Inherited from IQuery.) | |
SetInt64(String, Int64) | (Inherited from IQuery.) | |
SetLockMode |
Set the lockmode for the objects idententified by the
given alias that appears in the FROM clause.
(Inherited from IQuery.) | |
SetMaxResults |
Set the maximum number of rows to retrieve.
(Inherited from IQuery.) | |
SetParameter(Int32, Object) |
Bind a value to an indexed parameter, guessing the NHibernate type from
the class of the given object.
(Inherited from IQuery.) | |
SetParameter(String, Object) |
Bind a value to a named query parameter, guessing the NHibernate IType
from the class of the given object.
(Inherited from IQuery.) | |
SetParameter(Int32, Object, IType) |
Bind a value to an indexed parameter.
(Inherited from IQuery.) | |
SetParameter(String, Object, IType) |
Bind a value to a named query parameter
(Inherited from IQuery.) | |
SetParameter<(Of <<'(T>)>>)(Int32, T) |
Bind a value to an indexed parameter.
(Inherited from IQuery.) | |
SetParameter<(Of <<'(T>)>>)(String, T) |
Bind a value to a named query parameter
(Inherited from IQuery.) | |
SetParameterList(String, IEnumerable) |
Bind multiple values to a named query parameter, guessing the NHibernate
type from the class of the first object in the collection. This is useful for binding a list
of values to an expression such as foo.bar in (:value_list) (Inherited from IQuery.) | |
SetParameterList(String, IEnumerable, IType) |
Bind multiple values to a named query parameter. This is useful for binding a list
of values to an expression such as foo.bar in (:value_list) (Inherited from IQuery.) | |
SetProperties |
Bind the property values of the given object to named parameters of the query,
matching property names with parameter names and mapping property types to
NHibernate types using heuristics.
(Inherited from IQuery.) | |
SetReadOnly |
Set the read-only mode for entities (and proxies) loaded by this query. This setting
overrides the default setting for the session (see DefaultReadOnly).
(Inherited from IQuery.) | |
SetResultSetMapping |
Use a predefined named ResultSetMapping
| |
SetResultTransformer |
Set a strategy for handling the query results. This can be used to change
"shape" of the query result.
(Inherited from IQuery.) | |
SetSingle(Int32, Single) |
Bind an instance of a Single to an indexed parameter
using an NHibernate SingleType.
(Inherited from IQuery.) | |
SetSingle(String, Single) |
Bind an instance of a Single to a named parameter
using an NHibernate SingleType.
(Inherited from IQuery.) | |
SetString(Int32, String) |
Bind an instance of a String to an indexed parameter
using an NHibernate StringType.
(Inherited from IQuery.) | |
SetString(String, String) |
Bind an instance of a String to a named parameter
using an NHibernate StringType.
(Inherited from IQuery.) | |
SetTime(Int32, DateTime) |
Bind an instance of a DateTime to an indexed parameter
using an NHibernate DateTimeType.
(Inherited from IQuery.) | |
SetTime(String, DateTime) |
Bind an instance of a DateTime to a named parameter
using an NHibernate DateTimeType.
(Inherited from IQuery.) | |
SetTimeAsTimeSpan(Int32, TimeSpan) | (Inherited from IQuery.) | |
SetTimeAsTimeSpan(String, TimeSpan) | (Inherited from IQuery.) | |
SetTimeout |
The timeout for the underlying ADO query
(Inherited from IQuery.) | |
SetTimeSpan(Int32, TimeSpan) | (Inherited from IQuery.) | |
SetTimeSpan(String, TimeSpan) | (Inherited from IQuery.) | |
SetTimestamp(Int32, DateTime) |
Bind an instance of a DateTime to an indexed parameter
using an NHibernate TimestampType.
(Inherited from IQuery.) | |
SetTimestamp(String, DateTime) |
Bind an instance of a DateTime to a named parameter
using an NHibernate TimestampType.
(Inherited from IQuery.) | |
UniqueResult()()()() |
Convenience method to return a single instance that matches
the query, or null if the query returns no results.
(Inherited from IQuery.) | |
UniqueResult<(Of <<'(T>)>>)()()()() |
Strongly-typed version of UniqueResult()()()().
(Inherited from IQuery.) |
Properties
Name | Description | |
---|---|---|
IsReadOnly |
Will entities (and proxies) returned by the query be loaded in read-only mode?
(Inherited from IQuery.) | |
NamedParameters |
The names of all named parameters of the query
(Inherited from IQuery.) | |
QueryString |
The query string
(Inherited from IQuery.) | |
ReturnAliases | Return the HQL select clause aliases (if any) (Inherited from IQuery.) | |
ReturnTypes |
The NHibernate types of the query result set.
(Inherited from IQuery.) |