OleDbProviderSettings.DynamicParameters Propiedad
Gets or sets the Boolean property value that specifies whether the provider allows '?' parameter marker syntax for parameterized queries.
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property DynamicParameters As Boolean
Get
Set
'Uso
Dim instance As OleDbProviderSettings
Dim value As Boolean
value = instance.DynamicParameters
instance.DynamicParameters = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool DynamicParameters { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property bool DynamicParameters {
bool get ();
void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member DynamicParameters : bool with get, set
function get DynamicParameters () : boolean
function set DynamicParameters (value : boolean)
Valor de la propiedad
Tipo: 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.
Comentarios
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.
Ejemplos
Utilizar servidores vinculados en SMO