|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SqlTransactionhi,
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? -- Show quoteMiha 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" <neven.klofutar@**re...m.o..v...e**vip.hr> wrote in message news:OiuekOq8GHA.4620@TK2MSFTNGP02.phx.gbl... > 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,
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 Show quote "Miha Markic [MVP C#]" <miha at rthand com> wrote in message news:eNGv8cq8GHA.1492@TK2MSFTNGP02.phx.gbl... > 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" <neven.klofutar@**re...m.o..v...e**vip.hr> wrote in > message news:OiuekOq8GHA.4620@TK2MSFTNGP02.phx.gbl... >> 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,
"Neven Klofutar" <neven.klofutar@**re...m.o..v...e**vip.hr> wrote in message Sure, there are, but not in your case.news:ecKnIxr8GHA.940@TK2MSFTNGP03.phx.gbl... > 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 You should read a Sql Server book (perhaps Sahil Malik's) (or help files) to > specific. understand transactions. -- 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/ 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. Show quote "Neven Klofutar" <neven.klofutar@**re...m.o..v...e**vip.hr> wrote in message news:ecKnIxr8GHA.940@TK2MSFTNGP03.phx.gbl... > 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 [MVP C#]" <miha at rthand com> wrote in message > news:eNGv8cq8GHA.1492@TK2MSFTNGP02.phx.gbl... >> 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" <neven.klofutar@**re...m.o..v...e**vip.hr> wrote in >> message news:OiuekOq8GHA.4620@TK2MSFTNGP02.phx.gbl... >>> 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 >>> >> >> > > 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. :-) CorShow quote "Neven Klofutar" <neven.klofutar@**re...m.o..v...e**vip.hr> schreef in bericht news:ecKnIxr8GHA.940@TK2MSFTNGP03.phx.gbl... > 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 [MVP C#]" <miha at rthand com> wrote in message > news:eNGv8cq8GHA.1492@TK2MSFTNGP02.phx.gbl... >> 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" <neven.klofutar@**re...m.o..v...e**vip.hr> wrote in >> message news:OiuekOq8GHA.4620@TK2MSFTNGP02.phx.gbl... >>> 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 >>> >> >> > >  |
|||||||||||||||||||||||
Other interesting topics