Свойство Table.LockEscalation

Gets or sets the type of lock escalation that is used on the table.

Пространство имен: Microsoft.SqlServer.Management.Smo
Сборка: Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)

Синтаксис

'Декларация
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Deploy)> _
Public Property LockEscalation As LockEscalationType 
    Get 
    Set
'Применение
Dim instance As Table 
Dim value As LockEscalationType 

value = instance.LockEscalation

instance.LockEscalation = value

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Deploy)]
public LockEscalationType LockEscalation { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Deploy)]
public:
virtual property LockEscalationType LockEscalation {
    LockEscalationType get () sealed;
    void set (LockEscalationType value) sealed;
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Deploy)>]
abstract LockEscalation : LockEscalationType with get, set
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Deploy)>]
override LockEscalation : LockEscalationType with get, set

final function get LockEscalation () : LockEscalationType 
final function set LockEscalation (value : LockEscalationType)

Значение свойства

Тип: Microsoft.SqlServer.Management.Smo.LockEscalationType
A LockEscalationType value that specifies the type of lock escalation that is used on the table.

Реализует

ITableOptions.LockEscalation

Примеры

The following code example shows how to set the lock escalation type used by the table, and display that information.

Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];

Table tb = new Table(db, "Test Table");
Column col1 = new Column(tb, "Name", DataType.NChar(50));
Column col2 = new Column(tb, "ID", DataType.Int);

tb.Columns.Add(col1); 
tb.Columns.Add(col2); 
tb.LockEscalation = LockEscalationType.Auto;
tb.Create();

Console.WriteLine("The table uses the " + tb.LockEscalation.ToString() + " escalation type.");

Powershell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")

#Create the Table
$tb = new-object Microsoft.SqlServer.Management.Smo.Table($db, "Tesghjt Table")
$col1 = new-object Microsoft.SqlServer.Management.Smo.Column($tb, "Name", [Microsoft.SqlServer.Management.Smo.DataType]::NChar(50))
$col2 = new-object Microsoft.SqlServer.Management.Smo.Column($tb, "ID", [Microsoft.SqlServer.Management.Smo.DataType]::Int)
$tb.Columns.Add($col1)
$tb.Columns.Add($col2)
$tb.LockEscalation = [Microsoft.SqlServer.Management.Smo.LockEscalationType]::Auto
$tb.Create()

Write-Host "The table uses the" $tb.LockEscalation "escalation type."