DataExtensionsCreateParameterizedCommand Method

public static IDbCommand CreateParameterizedCommand(
	this IDbConnection connection,
	string sql,
	params Object[] values
)

<ExtensionAttribute>
Public Shared Function CreateParameterizedCommand ( 
	connection As IDbConnection,
	sql As String,
	ParamArray values As Object()
) As IDbCommand

public:
[ExtensionAttribute]
static IDbCommand^ CreateParameterizedCommand(
	IDbConnection^ connection, 
	String^ sql, 
	... array<Object^>^ values
)

[<ExtensionAttribute>]
static member CreateParameterizedCommand : 
        connection : IDbConnection * 
        sql : string * 
        values : Object[] -> IDbCommand 

GSF.Data.DataExtensions.CreateParameterizedCommand = function(connection, sql, ... values);

Parameters

connection  IDbConnection

The database connection.

sql  String

The SQL statement.

values  Object

The values for the parameters of the IDbCommand in the order that they appear in the SQL statement.

Return Value

Usage Note

This method does very rudimentary parsing of the SQL statement so parameter names should start with the '@' character and should be surrounded by either spaces, parentheses, or commas.

Do not use the same parameter name twice in the expression so that each parameter, identified by '@', will have a corresponding value.

Reference