AdvantageCMS.Core.Common.BaseClasses Namespace
Build With Advantage

AdvantageLayout..::..GetSQL Method

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)

Syntax


public string GetSQL(
	string commandName
)

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.

Remarks


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.