Question
How can we perform transactions in .net?
Answers
The most common sequence of steps that would be performed while developing a transactional application is as follows:

Open a database connection using the Open method of the connection object.
Begin a transaction using the Begin Transaction method of the connection object.

This method provides us with a transaction object that we will use later to commit or rollback the transaction.Note that changes caused by any queries executed before calling the Begin Transaction method will be committed to the database immediately after they execute. Set the Transaction property of the command object to the above mentioned transaction object. Execute the SQL commands using the command object. We may use one or more command objects for this purpose, as long as the Transaction property of all the objects is set to a valid transaction object. Commit or roll back the transaction using the Commit or Rollback method of the transaction object. Close the database connection.   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q Which among the four driver is pure Java driver ?
  • Q The best known poem of Charles Lamb ______:
  • Q Which of the following are the two key features of progressive discipline? (A)A system of warning steps and gradual increase in the severity of corrective action (B)Informal counseling and positive corrective action (C)Transfers and demotions (D)All of the above
  • Q Can you give an example of an electrophilic substitution reaction?
  • Q What tools do you have available to you for troubleshooting?
  • Q BRN is the international vehicle registration for which country?
  • Q Whit countries parliament is called The Storting
  • Q Aero planes of which airline sported Meera Mehta? s "Paithan Sari Motif" on their tails for sometime?
  • Q What is system tuner?
  • Q What is the function used to get a reference to an object inside the silverlight control?
  • Q How to integrate your struts application with spring?