Transaction.IsolationLevel プロパティ
アセンブリ: System.Transactions (system.transactions.dll 内)

トランザクションの分離レベルを示す IsolationLevel 値のいずれか。

トランザクションの分離レベルによって、トランザクションが完了する前に、揮発性データへの他のトランザクションのアクセス レベルが決まります。分離レベルの詳細については、IsolationLevel 列挙体に関するドキュメントを参照してください。

Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
開発プラットフォームの中には、.NET Framework によってサポートされていないバージョンがあります。サポートされているバージョンについては、「システム要件」を参照してください。


TransactionIsolationLevel 列挙体
アセンブリ: System.EnterpriseServices (system.enterpriseservices.dll 内)

<SerializableAttribute> _ Public Enumeration TransactionIsolationLevel

メンバ名 | 説明 | |
---|---|---|
Any | コンポーネントの分離レベルは、呼び出し元コンポーネントの分離レベルから取得します。ルート コンポーネントの場合、使用される分離レベルは Serializable です。 | |
ReadCommitted | データの読み取り中は、変更されたデータが読み取られることを避けるために、共有ロックが設定されます。しかし、トランザクションの終了前にデータが変更されることもあるため、反復不能読み取りやファントム データが発生する可能性があります。 | |
ReadUncommitted | 共有ロックが発行されるため、排他ロックは受け入れられません。 | |
RepeatableRead | 他のユーザーがデータを更新できないようにするために、クエリで使用するすべてのデータをロックします。反復不能読み取りは回避できますが、ファントム行が発生する可能性はあります。 | |
Serializable | トランザクション完了前の更新または挿入を防止します。 |

TransactionIsolationLevel 型の使用方法のコード例を次に示します。
Imports System Imports System.EnterpriseServices Imports System.Reflection ' References: ' System.EnterpriseServices ' An instance of this class will inherit its caller's transaction isolation ' level if available. If not, it will use isolation level Serializable. <Transaction(Isolation := TransactionIsolationLevel.Any)> _ Public Class TransactionAttribute_IsolationAny Inherits ServicedComponent End Class 'TransactionAttribute_IsolationAny ' An instance of this class will read only committed data, but non-repeatable ' reads and phantom rows are still possible. <Transaction(Isolation := TransactionIsolationLevel.ReadCommitted)> _ Public Class TransactionAttribute_IsolationReadCommitted Inherits ServicedComponent End Class 'TransactionAttribute_IsolationReadCommitted ' An instance of this class will read committed and uncommitted data, so dirty ' reads, non-repeatable reads, and phantom rows are possible. <Transaction(Isolation := TransactionIsolationLevel.ReadUncommitted)> _ Public Class TransactionAttribute_IsolationReadUncommitted Inherits ServicedComponent End Class 'TransactionAttribute_IsolationReadUncommitted ' An instance of this class will read only committed data and place shared ' locks on the data, preventing other users from modifying it, but other users ' can still insert rows into the data set, so phantom rows are still possible. <Transaction(Isolation := TransactionIsolationLevel.RepeatableRead)> _ Public Class TransactionAttribute_IsolationRepeatableRead Inherits ServicedComponent End Class 'TransactionAttribute_IsolationRepeatableRead ' An instance of this class will read only committed data and place a range ' lock on the data set, preventing other users from updating or inserting rows ' into the data set until its transaction is complete. <Transaction(Isolation := TransactionIsolationLevel.Serializable)> _ Public Class TransactionAttribute_IsolationSerializable Inherits ServicedComponent End Class 'TransactionAttribute_IsolationSerializable
using System; using System.EnterpriseServices; using System.Reflection; // References: // System.EnterpriseServices // An instance of this class will inherit its caller's transaction isolation // level if available. If not, it will use isolation level Serializable. [Transaction(Isolation=TransactionIsolationLevel.Any)] public class TransactionAttribute_IsolationAny : ServicedComponent { } // An instance of this class will read only committed data, but non-repeatable // reads and phantom rows are still possible. [Transaction(Isolation=TransactionIsolationLevel.ReadCommitted)] public class TransactionAttribute_IsolationReadCommitted : ServicedComponent { } // An instance of this class will read committed and uncommitted data, so dirty // reads, non-repeatable reads, and phantom rows are possible. [Transaction(Isolation=TransactionIsolationLevel.ReadUncommitted)] public class TransactionAttribute_IsolationReadUncommitted : ServicedComponent { } // An instance of this class will read only committed data and place shared // locks on the data, preventing other users from modifying it, but other users // can still insert rows into the data set, so phantom rows are still possible. [Transaction(Isolation=TransactionIsolationLevel.RepeatableRead)] public class TransactionAttribute_IsolationRepeatableRead : ServicedComponent { } // An instance of this class will read only committed data and place a range // lock on the data set, preventing other users from updating or inserting rows // into the data set until its transaction is complete. [Transaction(Isolation=TransactionIsolationLevel.Serializable)] public class TransactionAttribute_IsolationSerializable : ServicedComponent { }
#using <System.EnterpriseServices.dll> using namespace System; using namespace System::EnterpriseServices; using namespace System::Reflection; // References: // System.EnterpriseServices // An instance of this class will inherit its caller's transaction isolation // level if available. If not, it will use isolation level Serializable. [Transaction(Isolation=TransactionIsolationLevel::Any)] public ref class IsolationAny : public ServicedComponent { }; // An instance of this class will read only committed data, but non-repeatable // reads and phantom rows are still possible. [Transaction(Isolation=TransactionIsolationLevel::ReadCommitted)] public ref class IsolationReadCommitted : public ServicedComponent { }; // An instance of this class will read committed and uncommitted data, so dirty // reads, non-repeatable reads, and phantom rows are possible. [Transaction(Isolation=TransactionIsolationLevel::ReadUncommitted)] public ref class IsolationReadUncommitted : public ServicedComponent { }; // An instance of this class will read only committed data and place shared // locks on the data, preventing other users from modifying it, but other users // can still insert rows into the data set, so phantom rows are still possible. [Transaction(Isolation=TransactionIsolationLevel::RepeatableRead)] public ref class IsolationRepeatableRead : public ServicedComponent { }; // An instance of this class will read only committed data and place a range // lock on the data set, preventing other users from updating or inserting rows // into the data set until its transaction is complete. [Transaction(Isolation=TransactionIsolationLevel::Serializable)] public ref class IsolationSerializable : public ServicedComponent { };
import System.*; import System.EnterpriseServices.*; import System.Reflection.*; // References: // System.EnterpriseServices // An instance of this class will inherit its caller's transaction isolation // level if available. If not, it will use isolation level Serializable. /** @attribute Transaction(Isolation = TransactionIsolationLevel.Any) */ public class TransactionAttribute_IsolationAny extends ServicedComponent { } //TransactionAttribute_IsolationAny // An instance of this class will read only committed data, but non-repeatable // reads and phantom rows are still possible. /** @attribute Transaction(Isolation = TransactionIsolationLevel.ReadCommitted) */ public class TransactionAttribute_IsolationReadCommitted extends ServicedComponent { } //TransactionAttribute_IsolationReadCommitted // An instance of this class will read committed and uncommitted data, so dirty // reads, non-repeatable reads, and phantom rows are possible. /** @attribute Transaction(Isolation = TransactionIsolationLevel. ReadUncommitted) */ public class TransactionAttribute_IsolationReadUncommitted extends ServicedComponent { } //TransactionAttribute_IsolationReadUncommitted // An instance of this class will read only committed data and place shared // locks on the data, preventing other users from modifying it, but other users // can still insert rows into the data set, so phantom rows are still possible. /** @attribute Transaction(Isolation = TransactionIsolationLevel. RepeatableRead) */ public class TransactionAttribute_IsolationRepeatableRead extends ServicedComponent { } //TransactionAttribute_IsolationRepeatableRead // An instance of this class will read only committed data and place a range // lock on the data set, preventing other users from updating or inserting rows // into the data set until its transaction is complete. /** @attribute Transaction(Isolation = TransactionIsolationLevel.Serializable) */ public class TransactionAttribute_IsolationSerializable extends ServicedComponent { } //TransactionAttribute_IsolationSerializable

Windows 98, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
開発プラットフォームの中には、.NET Framework によってサポートされていないバージョンがあります。サポートされているバージョンについては、「システム要件」を参照してください。


Weblioに収録されているすべての辞書からTransaction.IsolationLevelを検索する場合は、下記のリンクをクリックしてください。

- Transaction.IsolationLevelのページへのリンク