How do I do transactions in .Net ?

[yaron]

[Jon Skeet [C# MVP]]

yaron <ya***@discussions.microsoft.com> wrote:

<nothing>

It would help if you'd be more specific in your question. For most
database connections, however, there's a BeginTransaction method call
you can make which will return you a reference to an object
representing the transaction - that can then be committed or rolled
back.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Jani Järvinen [MVP]]

Yaron,

like Jon said, these newsgroups probably aren't the best place to learn
broad topics like transaction handling, but I can give you pointers where
to start. Also, the term "transaction" can also be used in many different
contexts in programming; however I assume you are looking for information
regarding database (ADO.NET) transactions.

In ADO.NET, transactions are started with a method from the connection
class. For example, if you were accessing SQL Server, then you would use the
System.Data.SqlClient.SqlConnection class. This class has a method called
BeginTransaction which starts a transaction. This returns an object of type
SqlTransaction. Other ADO.NET connection classes like OleDbConnection has a
similar method.

After you are done, you can call the Commit method of the given
SqlTransaction object, or Rollback should you want to roll the transaction
back.

The .NET Framework SDK documentation has good information about
transactions. See the index entry "transaction processing, about transaction
processing" and the related topics form more information.

You might also find Shrijeet Nair's quick introduction helpful (from C#
Corner):
http://www.c-sharpcorner.com/Code/20...nsNConcurr.asp

--
Regards,

Mr. Jani Järvinen
C# MVP
Helsinki, Finland
ja***@removethis.dystopia.fi
http://www.saunalahti.fi/janij/

[Siva M]

You can use the BeginTransaction() method of the appropriate DB connection
object and call Commit() or Rollback() method on the returned transaction
object reference.

Hope this is what you are looking for.

"yaron" <ya***@discussions.microsoft.com> wrote in message
news:16**********************************@microsof t.com...