public HowTo_UseTransactions() { //<document> long _iduser = 0L; OGen.lib.datalayer.DBConnection _con = OGen.lib.datalayer.DBConnectionsupport.CreateInstance( // set your db server type here OGen.lib.datalayer.DBServerTypes.PostgreSQL, // and connectionstring "Server=127.0.0.1;Port=5432;User ID=postgres;Password=passpub;Database=OGen-NTier_UTs;" ); // before beginning a transaction we need to open the connection _con.Open(); try { // beginning transaction _con.Transaction.Begin(); // performing some operations on db _con.Execute_SQLQuery( string.Format( "delete from \"User\" where \"IDUser\" = {0}", _iduser.ToString() ) ); // commit transaction _con.Transaction.Commit(); } catch (Exception _ex) { // rollback transaction _con.Transaction.Rollback(); } finally { // terminate transaction _con.Transaction.Terminate(); } // closing connection _con.Close(); _con.Dispose(); _con = null; //</document> }
public HowTo_Execute_SQLQuery() { //<document> long _iduser = 0L; OGen.lib.datalayer.DBConnection _con = OGen.lib.datalayer.DBConnectionsupport.CreateInstance( // set your db server type here OGen.lib.datalayer.DBServerTypes.PostgreSQL, // and connectionstring "Server=127.0.0.1;Port=5432;User ID=postgres;Password=passpub;Database=OGen-NTier_UTs;" ); // executing your sql query _con.Execute_SQLQuery( string.Format( "delete from \"User\" where \"IDUser\" = {0}", _iduser.ToString() ) ); _con.Dispose(); _con = null; //</document> }