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
)
Protected Overridable Function CreateRetrievalQueryFromSQL (
connectionToUse As DbConnection,
fetchAspects As PlainSQLFetchAspects,
sqlQuery As String,
parameterValues As Object
) As IRetrievalQuery
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:
IRetrievalQueryready to use IRetrievalQuery object
See Also