The ISQLQuery type exposes the following members.

Methods

  NameDescription
Public methodAddEntity(String)
Declare a "root" entity, without specifying an alias
Public methodAddEntity(Type)
Declare a "root" entity, without specifying an alias
Public methodAddEntity(String, String)
Declare a "root" entity
Public methodAddEntity(String, Type)
Declare a "root" entity
Public methodAddEntity(String, String, LockMode)
Declare a "root" entity, specifying a lock mode
Public methodAddEntity(String, Type, LockMode)
Declare a "root" entity, specifying a lock mode
Public methodAddJoin(String, String)
Declare a "joined" entity
Public methodAddJoin(String, String, LockMode)
Declare a "joined" entity, specifying a lock mode
Public methodAddScalar
Declare a scalar query result
Public methodEnumerable()()()()
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.)
Public methodEnumerable<(Of <<'(T>)>>)()()()()
Strongly-typed version of Enumerable()()()().
(Inherited from IQuery.)
Public methodExecuteUpdate
Execute the update or delete statement.
(Inherited from IQuery.)
Public methodFuture<(Of <<'(T>)>>)
Get a enumerable that when enumerated will execute a batch of queries in a single database roundtrip
(Inherited from IQuery.)
Public methodFutureValue<(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.)
Public methodList()()()()
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.)
Public methodList(IList)
Return the query results an place them into the IList.
(Inherited from IQuery.)
Public methodList<(Of <<'(T>)>>)()()()()
Strongly-typed version of List()()()().
(Inherited from IQuery.)
Public methodSetAnsiString(Int32, String)
Bind an instance of a String to an indexed parameter using an NHibernate AnsiStringType.
(Inherited from IQuery.)
Public methodSetAnsiString(String, String)
Bind an instance of a String to a named parameter using an NHibernate AnsiStringType.
(Inherited from IQuery.)
Public methodSetBinary(Int32, array<Byte>[]()[][])
Bind an instance of a Byte array to an indexed parameter using an NHibernate BinaryType.
(Inherited from IQuery.)
Public methodSetBinary(String, array<Byte>[]()[][])
Bind an instance of a Byte array to a named parameter using an NHibernate BinaryType.
(Inherited from IQuery.)
Public methodSetBoolean(Int32, Boolean)
Bind an instance of a Boolean to an indexed parameter using an NHibernate BooleanType.
(Inherited from IQuery.)
Public methodSetBoolean(String, Boolean)
Bind an instance of a Boolean to a named parameter using an NHibernate BooleanType.
(Inherited from IQuery.)
Public methodSetByte(Int32, Byte)
Bind an instance of a Byte to an indexed parameter using an NHibernate ByteType.
(Inherited from IQuery.)
Public methodSetByte(String, Byte)
Bind an instance of a Byte to a named parameter using an NHibernate ByteType.
(Inherited from IQuery.)
Public methodSetCacheable
Enable caching of this query result set.
(Inherited from IQuery.)
Public methodSetCacheMode
Override the current session cache mode, just for this query.
(Inherited from IQuery.)
Public methodSetCacheRegion (Inherited from IQuery.)
Public methodSetCharacter(Int32, Char)
Bind an instance of a Char to an indexed parameter using an NHibernate CharType.
(Inherited from IQuery.)
Public methodSetCharacter(String, Char)
Bind an instance of a Char to a named parameter using an NHibernate CharType.
(Inherited from IQuery.)
Public methodSetComment
Add a comment to the generated SQL.
(Inherited from IQuery.)
Public methodSetDateTime(Int32, DateTime)
Bind an instance of a DateTime to an indexed parameter using an NHibernate DateTimeType.
(Inherited from IQuery.)
Public methodSetDateTime(String, DateTime)
Bind an instance of a DateTime to a named parameter using an NHibernate DateTimeType.
(Inherited from IQuery.)
Public methodSetDateTime2(Int32, DateTime) (Inherited from IQuery.)
Public methodSetDateTime2(String, DateTime) (Inherited from IQuery.)
Public methodSetDateTimeOffset(Int32, DateTimeOffset) (Inherited from IQuery.)
Public methodSetDateTimeOffset(String, DateTimeOffset) (Inherited from IQuery.)
Public methodSetDecimal(Int32, Decimal)
Bind an instance of a Decimal to an indexed parameter using an NHibernate DecimalType.
(Inherited from IQuery.)
Public methodSetDecimal(String, Decimal)
Bind an instance of a Decimal to a named parameter using an NHibernate DecimalType.
(Inherited from IQuery.)
Public methodSetDouble(Int32, Double)
Bind an instance of a Double to an indexed parameter using an NHibernate DoubleType.
(Inherited from IQuery.)
Public methodSetDouble(String, Double)
Bind an instance of a Double to a named parameter using an NHibernate DoubleType.
(Inherited from IQuery.)
Public methodSetEntity(Int32, Object)
Bind an instance of a mapped persistent class to an indexed parameter.
(Inherited from IQuery.)
Public methodSetEntity(String, Object)
Bind an instance of a mapped persistent class to a named parameter.
(Inherited from IQuery.)
Public methodSetEnum(Int32, Enum)
Bind an instance of a persistent enumeration class to an indexed parameter using an NHibernate PersistentEnumType.
(Inherited from IQuery.)
Public methodSetEnum(String, Enum)
Bind an instance of a persistent enumeration class to a named parameter using an NHibernate PersistentEnumType.
(Inherited from IQuery.)
Public methodSetFetchSize
Set a fetch size for the underlying ADO query.
(Inherited from IQuery.)
Public methodSetFirstResult
Sets the first row to retrieve.
(Inherited from IQuery.)
Public methodSetFlushMode
Override the current session flush mode, just for this query.
(Inherited from IQuery.)
Public methodSetGuid(Int32, Guid)
Bind an instance of a Guid to a named parameter using an NHibernate GuidType.
(Inherited from IQuery.)
Public methodSetGuid(String, Guid)
Bind an instance of a Guid to a named parameter using an NHibernate GuidType.
(Inherited from IQuery.)
Public methodSetInt16(Int32, Int16)
Bind an instance of a Int16 to an indexed parameter using an NHibernate Int16Type.
(Inherited from IQuery.)
Public methodSetInt16(String, Int16)
Bind an instance of a Int16 to a named parameter using an NHibernate Int16Type.
(Inherited from IQuery.)
Public methodSetInt32(Int32, Int32)
Bind an instance of a Int32 to an indexed parameter using an NHibernate Int32Type.
(Inherited from IQuery.)
Public methodSetInt32(String, Int32)
Bind an instance of a Int32 to a named parameter using an NHibernate Int32Type.
(Inherited from IQuery.)
Public methodSetInt64(Int32, Int64)
Bind an instance of a Int64 to an indexed parameter using an NHibernate Int64Type.
(Inherited from IQuery.)
Public methodSetInt64(String, Int64)
Bind an instance of a Int64 to a named parameter using an NHibernate Int64Type.
(Inherited from IQuery.)
Public methodSetLockMode
Set the lockmode for the objects idententified by the given alias that appears in the FROM clause.
(Inherited from IQuery.)
Public methodSetMaxResults
Set the maximum number of rows to retrieve.
(Inherited from IQuery.)
Public methodSetParameter(Int32, Object)
Bind a value to an indexed parameter, guessing the NHibernate type from the class of the given object.
(Inherited from IQuery.)
Public methodSetParameter(String, Object)
Bind a value to a named query parameter, guessing the NHibernate IType from the class of the given object.
(Inherited from IQuery.)
Public methodSetParameter(Int32, Object, IType)
Bind a value to an indexed parameter.
(Inherited from IQuery.)
Public methodSetParameter(String, Object, IType)
Bind a value to a named query parameter
(Inherited from IQuery.)
Public methodSetParameter<(Of <<'(T>)>>)(Int32, T)
Bind a value to an indexed parameter.
(Inherited from IQuery.)
Public methodSetParameter<(Of <<'(T>)>>)(String, T)
Bind a value to a named query parameter
(Inherited from IQuery.)
Public methodSetParameterList(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.)
Public methodSetParameterList(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.)
Public methodSetProperties
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.)
Public methodSetReadOnly
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.)
Public methodSetResultSetMapping
Use a predefined named ResultSetMapping
Public methodSetResultTransformer
Set a strategy for handling the query results. This can be used to change "shape" of the query result.
(Inherited from IQuery.)
Public methodSetSingle(Int32, Single)
Bind an instance of a Single to an indexed parameter using an NHibernate SingleType.
(Inherited from IQuery.)
Public methodSetSingle(String, Single)
Bind an instance of a Single to a named parameter using an NHibernate SingleType.
(Inherited from IQuery.)
Public methodSetString(Int32, String)
Bind an instance of a String to an indexed parameter using an NHibernate StringType.
(Inherited from IQuery.)
Public methodSetString(String, String)
Bind an instance of a String to a named parameter using an NHibernate StringType.
(Inherited from IQuery.)
Public methodSetTime(Int32, DateTime)
Bind an instance of a DateTime to an indexed parameter using an NHibernate DateTimeType.
(Inherited from IQuery.)
Public methodSetTime(String, DateTime)
Bind an instance of a DateTime to a named parameter using an NHibernate DateTimeType.
(Inherited from IQuery.)
Public methodSetTimeAsTimeSpan(Int32, TimeSpan) (Inherited from IQuery.)
Public methodSetTimeAsTimeSpan(String, TimeSpan) (Inherited from IQuery.)
Public methodSetTimeout
The timeout for the underlying ADO query
(Inherited from IQuery.)
Public methodSetTimeSpan(Int32, TimeSpan) (Inherited from IQuery.)
Public methodSetTimeSpan(String, TimeSpan) (Inherited from IQuery.)
Public methodSetTimestamp(Int32, DateTime)
Bind an instance of a DateTime to an indexed parameter using an NHibernate TimestampType.
(Inherited from IQuery.)
Public methodSetTimestamp(String, DateTime)
Bind an instance of a DateTime to a named parameter using an NHibernate TimestampType.
(Inherited from IQuery.)
Public methodUniqueResult()()()()
Convenience method to return a single instance that matches the query, or null if the query returns no results.
(Inherited from IQuery.)
Public methodUniqueResult<(Of <<'(T>)>>)()()()()
Strongly-typed version of UniqueResult()()()().
(Inherited from IQuery.)

Properties

  NameDescription
Public propertyIsReadOnly
Will entities (and proxies) returned by the query be loaded in read-only mode?
(Inherited from IQuery.)
Public propertyNamedParameters
The names of all named parameters of the query
(Inherited from IQuery.)
Public propertyQueryString
The query string
(Inherited from IQuery.)
Public propertyReturnAliases
Return the HQL select clause aliases (if any)
(Inherited from IQuery.)
Public propertyReturnTypes
The NHibernate types of the query result set.
(Inherited from IQuery.)

See Also