c# - Set options to FbTransaction -


how can set options fbtransaction

write nowait rec_version read_committed 

in code execute insert/update sql statements:

fbconnectionstringbuilder fbconnstr = new fbconnectionstringbuilder();  using (fbconnection fbconn = new fbconnection(fbconnstr)) {    fbconn.open();    using (fbtransaction fbtran = fbconn.begintransaction())    {       using (fbcommand fbcmd = new fbcommand("insert test values (1)", fbconn, fbtran)       {          fbcmd.commandtype = commandtype.text;          fbcmd.executenonquery();          fbcmd.transaction.commit();       }    }    fbconn.close(); } 

you use fbtransactionoptions:

fbtransaction transaction = connection.begintransaction(     fbtransactionoptions.readcommitted  |     fbtransactionoptions.write|     fbtransactionoptions.recversion|     fbtransactionoptions.nowait |     ); 

look @ isolationlevel:

  • isolationlevel.readuncommitted
  • isolationlevel.readcommitted
  • isolationlevel.repeatableread
  • isolationlevel.serializable

you do:

fbtransaction transaction = connection.begintransaction( isolationlevel.serializable ); 

Comments

Popular posts from this blog

windows - Single EXE to Install Python Standalone Executable for Easy Distribution -

c# - Access objects in UserControl from MainWindow in WPF -

javascript - How to name a jQuery function to make a browser's back button work? -