Click or drag to resize

DynamicQueryEngineBaseCreateRetrievalQueryFromSQL Method

Creates the retrieval query from the SQL query specified using the parameter values specified and is configured with the aspects specified.

Namespace:  SD.LLBLGen.Pro.ORMSupportClasses
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.9.0.0 (5.9.0)
Syntax
protected virtual IRetrievalQuery CreateRetrievalQueryFromSQL(
	DbConnection connectionToUse,
	PlainSQLFetchAspects fetchAspects,
	string sqlQuery,
	Object parameterValues
)

Parameters

connectionToUse
Type: System.Data.CommonDbConnection
The connection to use
fetchAspects
Type: SD.LLBLGen.Pro.ORMSupportClassesPlainSQLFetchAspects
The fetch aspects. can be null, in which case the defaults are used
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
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.

Return Value

Type: IRetrievalQuery
ready to use IRetrievalQuery object
See Also