LLBLGen Pro v5.9 Runtime Framework Reference Manual
Namespaces
SD.LLBLGen.Pro Namespaces
SD.LLBLGen.Pro.ORMSupportClasses Namespaces
SD.LLBLGen.Pro.ORMSupportClasses
DataAccessAdapterCore Class
DataAccessAdapterCore Methods
CallActionStoredProcedure Method
CallActionStoredProcedureAsync Method
CallRetrievalStoredProcedure Method
CloseConnection Method
Commit Method
CommitAsync Method
CreateActionQueryForPackedQueryFactoryFunc Method
CreateCorrectStoredProcedureName Method
CreateDynamicQueryEngine Method
CreateNewPhysicalConnection Method
CreateNewPhysicalDataAdapter Method
CreateNewPhysicalTransaction Method
CreatePrimaryKeyFilter Method
CreatePrimaryKeyFilters Method
CreateQueryCreationManager Method
CreateStoredProcedureCallCommand Method
DeleteEntitiesDirectly Method
DeleteEntitiesDirectlyAsync Method
DeleteEntity Method
DeleteEntityAsync Method
DeleteEntityCollection Method
DeleteEntityCollectionAsync Method
Dispose Method
ExecuteActionQuery Method
ExecuteActionQueryAsync Method
ExecuteMultiRowDataTableRetrievalQuery Method
ExecuteMultiRowDataTableRetrievalQueryAsync Method
ExecuteMultiRowRetrievalQuery Method
ExecuteMultiRowRetrievalQueryAsync Method
ExecuteScalarQuery Method
ExecuteScalarQueryAsync Method
ExecuteSingleRowRetrievalQuery Method
ExecuteSQL Method
ExecuteSQLAsync Method
FetchDataReader Method
FetchDataReaderAsync Method
FetchEntity Method
FetchEntityCollection Method
FetchEntityCollectionAsync Method
FetchEntityUsingUniqueConstraint Method
FetchExcludedFields Method
FetchExcludedFieldsAsync Method
FetchNewEntity Method
FetchPrefetchPath Method
FetchProjection Method
FetchProjectionAsync Method
FetchQuery Method
FetchQueryAsync Method
FetchScalarQuery Method
FetchScalarQueryAsync Method
FetchTypedList Method
FetchTypedListAsync Method
FetchTypedView Method
GetActiveConnection Method
GetDbCount Method
GetDbProviderFactoryInstance Method
GetDbSpecificCreatorInstance Method
GetScalar Method
HandleValueReadErrors Method
IDataAccessCore.FetchExcludedFieldBatch Method
IDataAccessCore.FetchExcludedFieldBatchAsync Method
IDataAccessCore.ProduceCorrectStoredProcedureName Method
InitClassPhase2 Method
ITransactionController.Commit Method
ITransactionController.Rollback Method
MergeManyToMany Method
MergeManyToManyAsync Method
OnAfterTransactionCommit Method
OnAfterTransactionRollback Method
OnBeforeEntitySave Method
OnBeforeTransactionCommit Method
OnBeforeTransactionRollback Method
OnDeleteEntitiesDirectly Method
OnDeleteEntitiesDirectlyComplete Method
OnDeleteEntity Method
OnDeleteEntityCollection Method
OnDeleteEntityCollectionComplete Method
OnDeleteEntityComplete Method
OnFetchEntity Method
OnFetchEntityCollection Method
OnFetchEntityCollectionComplete Method
OnFetchEntityComplete Method
OnFetchTypedList Method
OnFetchTypedListComplete Method
OnFetchTypedView Method
OnFetchTypedViewComplete Method
OnGetScalar Method
OnInsertPersistenceObjects Method
OnSaveEntity Method
OnSaveEntityCollection Method
OnSaveEntityCollectionComplete Method
OnSaveEntityComplete Method
OnUpdateEntitiesDirectly Method
OnUpdateEntitiesDirectlyComplete Method
OpenConnection Method
OpenConnectionAsync Method
PerformExecuteSingleRowRetrievalQuery Method
PostProcessNewDynamicQueryEngine Method
RawCallActionStoredProcedure Method
RawCallRetrievalProcedure Method
ReadHandleCatalogNameSettingFromConfig Method
ReadHandleSchemaNameSettingFromConfig Method
Rollback Method
SaveEntity Method
SaveEntityAsync Method
SaveEntityCollection Method
SaveEntityCollectionAsync Method
SaveTransaction Method
SetPerInstanceCompatibilityLevel Method
StartTransaction Method
StartTransactionAsync Method
UpdateEntitiesDirectly Method
UpdateEntitiesDirectlyAsync Method
WireTransaction Method
Click or drag to resize

DataAccessAdapterCoreExecuteSQL Method

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

Parameters

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

IDataAccessAdapterExecuteSQL(String, Object)
See Also