What is the main reason to use transactions?
Currently I just use a fbcommand statement to execute some sql statement.
I am curious does this way auto commit?
If I do use transactions can someone sent a sample code for a basic select
transaction.
Thanks.
Gary,
See this
http://www.firebirdsql.org/index.php?op=develsub=netproviderid=examples
and for more information here:
http://firebirdsql.org/dotnetfirebird/index.html
-
Take Surveys. Earn Cash. Influence the Future of IT
Join
At 11:16 PM 2/04/2007, you wrote:
What is the main reason to use transactions?
Because in a transactional database (which Firebird is) you can't
avoid it. Everything happens in a transaction, such that the work
that you are doing is isolated from what everyone else is doing.
Currently I just
Hello:
Currently I just use a fbcommand statement to execute some sql statement.
I am curious does this way auto commit?
When you run a query with the FbCommand if the FbCommand instance has no
transaction specfified, the provider will start one for you and will do
a commit or a rollback of
See this
http://www.firebirdsql.org/index.php?op=develsub=netproviderid=examples
refer 2nd example.
On 4/2/07, Marvin Cook [EMAIL PROTECTED] wrote:
Hi,
Could someone point me to a code example of using a transaction with
the FB .Net Provider?
Thanks
Marv
The easiest way is to use TransactionScope.
using (TransactionScope scope = new TransactionScope())
{
//do your code
sc.Complete();
}
Or you can make TableAdapter's connection public visible and start
transaction manually (this is some kind of old-school way).
--
Jiri {x2} Cincura
The easiest way is to use TransactionScope.
using (TransactionScope scope = new TransactionScope())
{
//do your code
sc.Complete();
}
I'll try it.
Thanks
Marv
-
Take Surveys. Earn Cash. Influence the Future of