DaoBaseFetchQueryT Method (PlainSQLFetchAspects, ITransaction, String, Object)

Executes the specified plain SQL query using this DAO and projects each row in the resultset to an instance of T. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery.

Namespace: SD.LLBLGen.Pro.ORMSupportClasses
Assembly: SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.7.0.0 (5.7.0)

Syntax

Copy

public virtual List<T> FetchQuery<T>(
	PlainSQLFetchAspects fetchAspects,
	ITransaction containingTransaction,
	string sqlQuery,
	Object parameterValues = null
)

Public Overridable Function FetchQuery(Of T) ( 
	fetchAspects As PlainSQLFetchAspects,
	containingTransaction As ITransaction,
	sqlQuery As String,
	Optional parameterValues As Object = Nothing
) As List(Of T)

Parameters

fetchAspects: Type: SD.LLBLGen.Pro.ORMSupportClassesPlainSQLFetchAspects
The fetch aspects for this query. Can be null, in which case the defaults are used.
containingTransaction: Type: SD.LLBLGen.Pro.ORMSupportClassesITransaction
A containing transaction if caller is added to a transaction, or null of not.
sqlQuery: Type: SystemString
The SQL query to execute, which returns a resultset. Should contain parameter names for the parameter values, or placeholders for parameter sets. See documentation for details regarding format specifics.
parameterValues (Optional): Type: SystemObject
The object containing the parameter values to use in the query. If it's an object array, parameters using ordening are assumed, otherwise for each public, non-static property, a parameter is created.

Type Parameters

T: The type of the element to project each row to.

Return Value

Type: ListT
A list with 0 or more instances of T, one for each row in the resultset obtained from executing the query constructed from sqlQuery and the specified parameters

Implements

IDaoFetchQueryT(PlainSQLFetchAspects, ITransaction, String, Object)

Reference

DaoBase Class

FetchQuery Overload