Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

OleDbProviderSettings.DynamicParameters Property

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
public bool DynamicParameters { get; set; }

Property Value

Type: System.Boolean
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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.