I do not know how to use Oracle.Transactions in my code.
My code looks like this:
I have a public class BaseAdapter from wich all my adapters inherit and where I put my save() etc like this:
Code: Select all
public class BaseAdapter where T : Devart.Data.Linq.DataContext, new()
{
protected T DB;
StringBuilder sb = new StringBuilder();
public BaseAdapter()
{
DB = new T();
// Voorlopig willen we de output zien
DB.Log = new System.IO.StringWriter(sb);
DB.Log = Console.Out;
}
public void Dispose()
{
this.DB.Dispose();
}
public bool Save()
{
try
{
ChangeSet cs = DB.GetChangeSet();
DB.SubmitChanges(System.Data.Linq.ConflictMode.ContinueOnConflict);
return true;
}
catch (Devart.Data.Linq.ChangeConflictException e)
{ ...
}
catch (OracleException ex)
{...
}
catch (Exception ex)
{...
}
}
Code: Select all
public class InskSetAdapter : BaseAdapter
{
public void addVES(CT_VES ves_ipar)
{
DB.CT_VES.InsertOnSubmit(ves_ipar);
}
}
Code: Select all
InskSetAdapter inskAdapter = new InskSetAdapter();
CT_VES ves_rec = new CT_VES();
// do something with ves_rec
inskAdapter.addVES(ves_rec);
inskAdaper.Save();
I want to use it something like:
Code: Select all
InskSetAdapter inskAdapter = new InskSetAdapter();
CT_VES ves_rec = new CT_VES();
// do something with ves_rec
// BeginTransaction
// Again do something with ves_rec
// if (ok) then Transaction.Commit();
// else Transaction.Rollback();
inskAdapter.addVES(ves_rec);
inskAdaper.Save();
Thanks,