OleDbProviderSettings 类
The OleDbProviderSettings object represents the setting for a SQL Server OLE DB provider.
继承层次结构
System. . :: . .Object
Microsoft.SqlServer.Management.Smo. . :: . .SmoObjectBase
Microsoft.SqlServer.Management.Smo. . :: . .SqlSmoObject
Microsoft.SqlServer.Management.Smo. . :: . .NamedSmoObject
Microsoft.SqlServer.Management.Smo..::..OleDbProviderSettings
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
<SfcElementTypeAttribute("OleDbProviderSetting")> _
<SfcBrowsableAttribute(False)> _
Public NotInheritable Class OleDbProviderSettings _
Inherits NamedSmoObject _
Implements IAlterable, IScriptable
用法
Dim instance As OleDbProviderSettings
[SfcElementTypeAttribute("OleDbProviderSetting")]
[SfcBrowsableAttribute(false)]
public sealed class OleDbProviderSettings : NamedSmoObject,
IAlterable, IScriptable
[SfcElementTypeAttribute(L"OleDbProviderSetting")]
[SfcBrowsableAttribute(false)]
public ref class OleDbProviderSettings sealed : public NamedSmoObject,
IAlterable, IScriptable
[<SealedAttribute>]
[<SfcElementTypeAttribute("OleDbProviderSetting")>]
[<SfcBrowsableAttribute(false)>]
type OleDbProviderSettings =
class
inherit NamedSmoObject
interface IAlterable
interface IScriptable
end
public final class OleDbProviderSettings extends NamedSmoObject implements IAlterable, IScriptable
OleDbProviderSettings 类型公开以下成员。
属性
名称 | 说明 | |
---|---|---|
![]() |
AllowInProcess | Gets or sets the Boolean property value that specifies whether the OLE DB provider is instantiated as an in-process server. |
![]() |
Description | Gets a textual description of the OLE DB provider. |
![]() |
DisallowAdHocAccess | Gets or sets the Boolean property value that specifies whether SQL Server allows ad hoc access to data by using OPENROWSET and OPENDATASOURCE functions with the OLE DB provider. |
![]() |
DynamicParameters | Gets or sets the Boolean property value that specifies whether the provider allows '?' parameter marker syntax for parameterized queries. |
![]() |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (从 SqlSmoObject 继承。) |
![]() |
IndexAsAccessPath | Gets or sets the Boolean property value that specifies whether the OLE DB provider indexes are used to fetch data. |
![]() |
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (从 SqlSmoObject 继承。) |
![]() |
LevelZeroOnly | Gets or sets the Boolean property value that specifies whether all OLE DB providers are supported or just those that are compliant with the level 0 OLE DB interface. |
![]() |
Name | Gets or sets the name of the object. (从 NamedSmoObject 继承。) |
![]() |
NestedQueries | Gets or sets the Boolean property value that specifies whether the OLE DB provider allows nested SELECT statements in the FROM clause. |
![]() |
NonTransactedUpdates | Gets or sets the Boolean property value that specifies whether data updates with the OLE DB provider are logged and are recoverable. |
![]() |
ObjectInSpace | Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (从 SqlSmoObject 继承。) |
![]() |
Parent | Gets the Settings object that is the parent of the OleDbProviderSettings object. |
![]() |
Properties | Gets a collection of Property objects that represent the object properties. (从 SqlSmoObject 继承。) |
![]() |
ScalarResult | Gets the scalar result for the referenced object. (从 SqlSmoObject 继承。) |
![]() |
SqlServerLike | Gets or sets the Boolean property value that specifies whether the OLE DB provider supports the LIKE operator as it is implemented in Microsoft SQL Server. |
![]() |
State | Gets the state of the referenced object. (从 SmoObjectBase 继承。) |
![]() |
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (从 SqlSmoObject 继承。) |
![]() |
UserData | Gets or sets user-defined data associated with the referenced object. (从 SmoObjectBase 继承。) |
页首
方法
页首
显式接口实现
名称 | 说明 | |
---|---|---|
![]() ![]() |
IAlienObjectDiscover | (从 SqlSmoObject 继承。) |
![]() ![]() |
IAlienObjectGetParent | (从 SqlSmoObject 继承。) |
![]() ![]() |
IAlienObjectGetProperty | (从 SqlSmoObject 继承。) |
![]() ![]() |
ISfcPropertyProviderGetPropertySet | (从 SqlSmoObject 继承。) |
![]() ![]() |
IAlienObjectGetUrn | (从 SqlSmoObject 继承。) |
![]() ![]() |
IAlienObjectResolve | (从 SqlSmoObject 继承。) |
![]() ![]() |
IAlienObjectSetProperty | (从 SqlSmoObject 继承。) |
页首
注释
Thread Safety
此类型的任何公共静态(Microsoft Visual Basic 中的 Shared)成员在多线程操作中是安全的。 不保证所有实例成员都对于线程安全的。
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。