Returns raw SQL to execute for the specified command, or an empty string
when the command uses a stored procedure.
Namespace:
AdvantageCMS.Core.Common.BaseClasses
Assembly:
AdvantageCMS.Core (in AdvantageCMS.Core.dll)
Parameters
- commandName
- Type: String
The logical command name. When stored procedures handle all operations,
this is typically ignored and the method returns String.
Return Value
A SQL string to execute, or
String to use the stored
procedure identified by
commandName.
Most implementations return
String because the data
access layer resolves the stored procedure by
commandName
directly. Use this method only when you need to supply ad-hoc SQL instead.