Bagikan melalui


DtsContainer.IsolationLevel Properti

Definisi

Mendapatkan atau mengatur tingkat isolasi transaksi dalam DtsContainer objek.

public:
 property System::Data::IsolationLevel IsolationLevel { System::Data::IsolationLevel get(); void set(System::Data::IsolationLevel value); };
[Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyCategory(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PropertyCategoryTransactions")]
[Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "IsolationLevelDesc")]
public System.Data.IsolationLevel IsolationLevel { get; set; }
[<Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyCategory(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PropertyCategoryTransactions")>]
[<Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "IsolationLevelDesc")>]
member this.IsolationLevel : System.Data.IsolationLevel with get, set
Public Property IsolationLevel As IsolationLevel

Nilai Properti

Nilai bilangan bulat yang sesuai dengan tingkat isolasi.

Atribut

Contoh

Contoh kode berikut membuat Package, yang merupakan kelas yang mewarisi dari DtsContainer. menunjukkan Package penggunaan beberapa properti yang diwariskan.

using System;  
using System.Collections.Generic;  
using System.Text;  
using Microsoft.SqlServer.Dts.Runtime;  

namespace Microsoft.SqlServer.SSIS.Samples  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Application app = new Application();  
            Package pkg = new Package();  

            // Package name must be assigned.  
            pkg.Name = "My DtsContainer inheritance test package";  

            // Display the values that manually assigned.  
            Console.WriteLine("Package Name: {0}", pkg.Name);  

            // Packages are assigned the following default values when created.  
            Console.WriteLine("Package ID:           {0}", pkg.ID);  
            Console.WriteLine("FailPackageOnFailure: {0}", pkg.FailPackageOnFailure);  
            Console.WriteLine("FailParentOnFailure:  {0}", pkg.FailParentOnFailure);  
            Console.WriteLine("Locale ID:            {0}", pkg.LocaleID);  
            Console.WriteLine("Is DefaultLocaleID?   {0}", pkg.IsDefaultLocaleID);  
            Console.WriteLine("Isolation Level:      {0}", pkg.IsolationLevel);  
            Console.WriteLine("LoggingMode:          {0}", pkg.LoggingMode);  
            Console.WriteLine("MaximumErrorCount:    {0}", pkg.MaximumErrorCount);  
            Console.WriteLine("TransactionOption:    {0}", pkg.TransactionOption);  
        }  
    }  
}  
Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  

Namespace Microsoft.SqlServer.SSIS.Samples  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            Dim app As Application =  New Application()   
            Dim pkg As Package =  New Package()   

            ' Package name must be assigned.  
            pkg.Name = "My DtsContainer inheritance test package"  

            ' Display the values that manually assigned.  
            Console.WriteLine("Package Name: {0}", pkg.Name)  

            ' Packages are assigned the following default values when created.  
            Console.WriteLine("Package ID:           {0}", pkg.ID)  
            Console.WriteLine("FailPackageOnFailure: {0}", pkg.FailPackageOnFailure)  
            Console.WriteLine("FailParentOnFailure:  {0}", pkg.FailParentOnFailure)  
            Console.WriteLine("Locale ID:            {0}", pkg.LocaleID)  
            Console.WriteLine("Is DefaultLocaleID?   {0}", pkg.IsDefaultLocaleID)  
            Console.WriteLine("Isolation Level:      {0}", pkg.IsolationLevel)  
            Console.WriteLine("LoggingMode:          {0}", pkg.LoggingMode)  
            Console.WriteLine("MaximumErrorCount:    {0}", pkg.MaximumErrorCount)  
            Console.WriteLine("TransactionOption:    {0}", pkg.TransactionOption)  
        End Sub  
    End Class  
End Namespace  

Contoh Output:

Nama Paket: Paket pengujian pewarisan DtsContainer saya

ID Paket: {2C2FAA96-35BA-4c5e-A39A-C5D7D30A0D79}

FailPackageOnFailure: False

FailParentOnFailure: False

ID Lokal: 1033

Apakah DefaultLocaleID? FALSE

Tingkat Isolasi: Dapat diserialisasikan

LoggingMode: UseParentSetting

MaximumErrorCount: 1

TransactionOption: Didukung

Keterangan

Nilai default properti ini adalah -1, atau Tidak Ditentukan. Untuk informasi selengkapnya tentang nilai yang tersedia, lihat enumerasi IsolationLevel yang digunakan di namespace System.Data, di ADO dan di OLE DB.

Tabel berikut ini mencantumkan nilai yang tersedia untuk IsolationLevel properti .

Nilai Tingkat Isolasi
-1 Tidak disebutkan
16 Kekacauan
256 ReadUncommitted
4096 ReadCommitted
65536 RepeatableRead
1048576 Serializable

Berlaku untuk