DatabaseTargetCommandText Property

Gets or sets the text of the SQL command to be run on each log level.

Namespace: NLog.Targets
Assembly: NLog.Database (in NLog.Database.dll) Version: 5.5.0+1873145cbc26e0312d9481234d69ce7dc68aac4e

Syntax

Copy

public Layout CommandText { get; set; }

Public Property CommandText As Layout
	Get
	Set

Dim instance As DatabaseTarget
Dim value As Layout

value = instance.CommandText

instance.CommandText = value

member CommandText : Layout with get, set

Property Value

Type: Layout

Remarks

Typically this is a SQL INSERT statement or a stored procedure call. It should use the database-specific parameters (marked as @parameter for SQL server or :parameter for Oracle, other data providers have their own notation) and not the layout renderers, because the latter is prone to SQL injection attacks. The layout renderers should be specified as <parameter /> elements instead.

Reference

DatabaseTarget Class

NLog.Targets Namespace

DatabaseTargetAddLanguageSpecificTextSet("LST11EF0828_0?cpp=::|nu=.");CommandText Property

Property Value

Reference

DatabaseTargetCommandText Property