Blog
SQLiteTransaction Class
SQLite Transaction class is used for generating an SQL query in SQLite.
SQLiteTransaction Class is used if you want to
create an SQL query in SQLite. For using this you need to include
Devart.Data.SQLite namespace. The public methods of this class are as
follows:
Commit:- It is used for making any transaction permanent in database. You can
even override it. The commit statement is used in SQLite in a same way it is
used in SQL.The syntax of it if you want to override it is:
Syntax:
public override void Commit();
CreateObjRef:- It generates an object which have information that helps
in creation of a proxy and that proxy is required to establish connection with a
remote object.
The System.MarshalByRefObject is a base class for
CreateObjRef method. The
System.MarshalByRefObject makes possible retrieval of
objects across boundaries of application domain in applications that can do
remoting.
Dispose :- DbTransaction class is the super class for a
transaction. It uses some unmanaged resources so Dispose function takes away
those unmanaged resources. System.Data.Common.DbTransaction class is a super class for
Dispose function.
GetLifetimeService :-It accesses the present lifetime
service object that manages the lifetime policy for this instance. It is also
inherited from
System.MarshalByRefObject.
RollBack:- If there is any transaction in SQLite database that fails in
between, this statement move it to the state which it was before performing a
transaction. It can also be overridden.