Pessimistic views on SQL Server and Oracle

Using System;
Using System. Data;
Namespace Com. CUC. Wu. Example
{
Public   Class Class1
{
// For SQL Server, the isolation level of a connection-related transaction is
// Repeatable read or serializable. For Oracle, use select for update in command.
Public   Void Lockedsqldatarow ()
{
Dataset DS =   New Dataset ();
Sqlconnection sconn =   New Sqlconnection ( " Server = localhost; uid = sa; Pwd = sa; database = pubs " );
Sconn. open ();
Sqltransaction TX =   New Sconn. begintransaction (isolationlevel. serializable );

Sqlcommand cmd =   New Sqlcommand ( " Select * from authors " , Conn, TX );
Sqldataadapter da =   New Sqldataadapter (CMD );
Da. Fill (DS, " Autors " );
// Rows locked here

DS. Tables [ 0 ]. Rows [ 1 ] [ 2 ] = " Free " ;

Sqlcommandbuilder BLD =   New Sqlcommandbuilder (DA );
Da. Update (DS, " Authors " );
TX. Commit ();
// Rows unlocked here
Da. Dispose ();
Conn. Close (); // Please refer to **í · å × ê ô'
}
Public   Void Lockedoradatarow ()
{
Dataset DS =   New Dataset ();
Oledbconnection oconn =   New Oledbconnection ( " Provider = msdaora; Data Source = ocr11; user id = Scott; Password = Tiger " );
Conn. open ();

Oledbtransaction TX = Oconn. begintransaction ();
Oledbcommand cmd =   New Oledbcommand ( " Select * Form EMP for update " , Conn, TX );

Oledbdataadapter da =   New Oledbdataadapter (CMD );
Da. Fill (DS, " EMP " );
// Rows locked here;

DS. Tables [ 0 ]. Rows [ 9 ] [ 2 ] =   " Clerk " ;
Oledbcommandbuilder BLD =   New Oledbcommandbuilder (DA );
Da. Update (DS, " EMP " );
TX. Commit ();
// Rows unlocked here
Da. Dispose ();
Oconn. Close ();
}
} ;

}