SqlTransaction

  • Thread starter Thread starter Neven Klofutar
  • Start date Start date
N

Neven Klofutar

hi,

I would like to learn some details about how SqlTransaction really works.
Can you please recomend some posts, sites, forums about the subject ?

thanx, Neven
 
Hi Neven,

What do you want to know?
It is just a class that issues proper sql statments to the sql server (ok,
it is a bit more but this is what it does against the server).
Or did you mean System.Transactions.Transaction class?
 
hi,

I would like to know what can I do withing scope of one transaction.
I have an application that have to delete some records from one table, and
in the same transaction insert new records. Is there some sort of limitation
one transaction can do ?
Whoever I talk about some detailed information, noone can tell me anything
specific.

Thanx, Neven


Miha Markic said:
Hi Neven,

What do you want to know?
It is just a class that issues proper sql statments to the sql server (ok,
it is a bit more but this is what it does against the server).
Or did you mean System.Transactions.Transaction class?

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Neven Klofutar said:
hi,

I would like to learn some details about how SqlTransaction really works.
Can you please recomend some posts, sites, forums about the subject ?

thanx, Neven
Click to expand...
Click to expand...
 
Hi Neven,

Neven Klofutar said:
hi,

I would like to know what can I do withing scope of one transaction.
I have an application that have to delete some records from one table, and
in the same transaction insert new records. Is there some sort of
limitation one transaction can do ?
Click to expand...

Sure, there are, but not in your case.
Whoever I talk about some detailed information, noone can tell me anything
specific.
Click to expand...

You should read a Sql Server book (perhaps Sahil Malik's) (or help files) to
understand transactions.
 
A SqlTransaction means that any statements that alter the database can
effectively be undone. This allows you to perform many changes on a database
as if it were an atomic operation. So you start the transaction, and start
making changes to the database or the data in it. If at some point there is
an unexpected error, or you decided that none of this should have happened
after all, you can roll back the transaction. Rolling back the transaction
means the database will be in the same state as before you began the
transaction in the first place. If everything is OK you can instead commit
the transaction, which means your changes will be committed to the database
and all the locks the transaction has placed will be released.

There is also plenty of information on transactions online if you use
Google.

Neven Klofutar said:
hi,

I would like to know what can I do withing scope of one transaction.
I have an application that have to delete some records from one table, and
in the same transaction insert new records. Is there some sort of
limitation one transaction can do ?
Whoever I talk about some detailed information, noone can tell me anything
specific.

Thanx, Neven


Miha Markic said:
Hi Neven,

What do you want to know?
It is just a class that issues proper sql statments to the sql server
(ok, it is a bit more but this is what it does against the server).
Or did you mean System.Transactions.Transaction class?

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Neven Klofutar said:
hi,

I would like to learn some details about how SqlTransaction really
works.
Can you please recomend some posts, sites, forums about the subject ?

thanx, Neven
Click to expand...
Click to expand...
Click to expand...
 
Neven,

Bill Vaughn has finished his book and it will be there I thought in Las
Vegas in November. For the time he took to make this book completely new and
that related to the secure style of writing from Bill, I think that it is
really something to look forward for.

Bill is in my idea the specialist in this newsgroup in the subject you are
asking for..

If you cannot use it to read you probably can use it to put your Television
Set on. It seems to have an endless amount of pages that covers almost
everything about AdoNet, while it is new written and not a kind of update
from the completely to AdoNet different Net 1.1 version.


:-)

Cor

Neven Klofutar said:
hi,

I would like to know what can I do withing scope of one transaction.
I have an application that have to delete some records from one table, and
in the same transaction insert new records. Is there some sort of
limitation one transaction can do ?
Whoever I talk about some detailed information, noone can tell me anything
specific.

Thanx, Neven


Miha Markic said:
Hi Neven,

What do you want to know?
It is just a class that issues proper sql statments to the sql server
(ok, it is a bit more but this is what it does against the server).
Or did you mean System.Transactions.Transaction class?

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Neven Klofutar said:
hi,

I would like to learn some details about how SqlTransaction really
works.
Can you please recomend some posts, sites, forums about the subject ?

thanx, Neven
Click to expand...
Click to expand...
Click to expand...
 
Back
Top