LLBLGen Pro v5.10 Runtime Framework Reference Manual
Namespaces
SD.LLBLGen.Pro Namespaces
SD.LLBLGen.Pro.ORMSupportClasses Namespaces
SD.LLBLGen.Pro.ORMSupportClasses
DaoBase Class
DaoBase Methods
AddNew Method
AddNewAsync Method
CallActionStoredProcedure Method
CallActionStoredProcedureAsync Method
CallRetrievalStoredProcedure Method
CreateConnection Method
CreateDataAdapter Method
CreatePrimaryKeyFilter Method
CreatePrimaryKeyFilters Method
CreateTransaction Method
DeleteExisting Method
DeleteExistingAsync Method
DeleteMulti Method
DeleteMultiAsync Method
DetermineConnectionToUse Method
ExecuteActionQuery Method
ExecuteActionQueryAsync Method
ExecuteMultiRowDataTableRetrievalQuery Method
ExecuteMultiRowRetrievalQuery Method
ExecuteScalarQuery Method
ExecuteScalarQueryAsync Method
ExecuteSingleRowRetrievalQuery Method
ExecuteSQL Method
ExecuteSQLAsync Method
FetchExcludedFields Method
FetchExcludedFieldsAsync Method
FetchExisting Method
FetchExistingPolymorphic Method
FetchQuery Method
FetchQueryAsync Method
FetchScalarQuery Method
FetchScalarQueryAsync Method
GetAsDataReader Method
GetAsDataReaderAsync Method
GetAsProjection Method
GetAsProjectionAsync Method
GetConnectionString Method
GetDbCount Method
GetMulti Method
GetMultiAsDataTable Method
GetMultiAsync Method
GetScalar Method
HandleValueReadErrors Method
InsertMulti Method
InsertMultiAsync Method
PerformExecuteSingleRowRetrievalQuery Method
PerformFetchEntityAction Method
PerformGetMultiAction Method
PerformGetMultiActionAsync Method
PerformPolymorphicEntityFetch Method
UpdateExisting Method
UpdateExistingAsync Method
UpdateMulti Method
UpdateMultiAsync Method
Click or drag to resize

DaoBaseExecuteSQL Method

Executes the specified plain SQL query using this DAO. 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.10.0.0 (5.10.0)
Syntax
Copy
public virtual int ExecuteSQL(
	ITransaction containingTransaction,
	string sqlQuery,
	Object parameterValues = null
)

Parameters

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. 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.

Return Value

Type: Int32
The value returned by the executed DbCommand. In general this is the number of rows affected by the executed sqlQuery

Implements

IDaoExecuteSQL(ITransaction, String, Object)
See Also