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
Post a Comment