Propriété Table.LockEscalation

Article
04/26/2013

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

Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Deploy)> _
Public Property LockEscalation As LockEscalationType 
    Get 
    Set
'Utilisation
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)

Valeur de propriété

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

Implémente

ITableOptions.LockEscalation

Exemples

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."