OleDbProviderSettings.DynamicParameters OleDbProviderSettings.DynamicParameters OleDbProviderSettings.DynamicParameters Property

Definition

Gets or sets the Boolean property value that specifies whether the provider allows '?' parameter marker syntax for parameterized queries.

public:
 property bool DynamicParameters { bool get(); void set(bool value); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone)]
public bool DynamicParameters { get; set; }
Public Property DynamicParameters As Boolean
Property Value

A Boolean value that specifies whether SQL Server allows parameterized queries with the OLE DB provider.

If True, parameterized queries are allowed.

If False (default), parameterized queries are not allowed.

Examples

Using Linked Servers in SMO

Remarks

Setting this option allows SQL Server to execute parameterized queries against the OLE DB provider. The ability to execute parameterized queries against the OLE DB provider can yield better performance for certain queries.

Applies to