| .NET Distributed Transactions on Enterprise Services: a demo |
| The Code Project |
| This demo shows you how to develop .NET components capable of participating in distributed transactions coordinated by .NET Enterprise Services |
|
| ADO.NET 2.0 Feature Matrix |
| MSDN |
| ADO.NET 2.0 includes a new base-class provider model, features for all providers, and changes to System.Data.SqlClient. Get an overview of these new features, examples of their use, and a chart of which features are provider-neutral and SqlClient-specific. |
|
| BUG: SQLClient: SQLReader Doesn't Propagate Deadlock Exceptions (Q316667) |
| http://www.kbalertz.com/ |
| When you execute the |
|
| ColdStorage Advertising Service Development |
| MSDN |
| This article describes some of the issues faced and lessons learned in the development of the ColdStorage sample Advertising Service. |
|
| Declarative Transactions using ADO.NET and Without Enterprise Services |
| The Code Project |
| Sometimes it is nice to prototype up a simple database application. This code may help, by providing the automatic transactional model of COM+ in a non-COM+ environment. This example uses "Interception" to provide automatic transactioning support for non-COM+ classes. |
|
| Generic Coding with the ADO.NET 2.0 Base Classes and Factories |
| MSDN |
| Learn more about the new functionality in ADO.NET 2.0 that enables you to create generic data access code. |
|
| Handling Transactions Between .NET Components |
| MSDN |
| "I read your column in the February 2002 issue of MSDN® Magazine regarding COM+, DCOM, and MSMQ serialization in .NET. You said that if a component is performing transactions on a single database and you expect that you'll always be going against only one database, then you don't necessarily need COM+ to implement those transactions; instead, you can implement them with ADO.NET. This seems to be a big change in philosophy.
Could you give me more information about how I can handle transactions between .NET components even though I am dealing with the same database? If I pass on the connection string and keep a connection open, doesn't that incur overhead as well?" |
|
| HOW TO: Roll Back Updates After an Error When You Use DataAdapter and DataSet in ADO.NET and Visual C# .NET |
| http://www.kbalertz.com/ |
| (316024) - This article describes how to roll back updates after an error when you use a DataAdapter and a DataSet object. If your client application uses an ADO.NET DataSet object to store changes that are made to data or to add new records, you can use a... |
|
| SQL Transactions with the SqlTransaction Class |
| DevHood |
| For those of you who are already familiar with transactions, you can skip all the reading and just look at the code samples. For those of you who are not familiar with transactions, this tutorial will attempt to explain in a little more detail. This tutorial also assumes some knowledge of SQL and how to execute SQL commands. |
|
| The SQLTransaction Object |
| STANDARDIO.ORG |
| With the SQLTransaction object in ASP.NET you have access to the rollback and commit methods. What are they good for? Making sure that a sequence of database commands doesn't go off half-cocked. If you are updating thousands of records in one loop, it would be somewhat disastrous if the server encountered an error in the middle of the loop, leaving your table with some records updated and some not.Transactions can be executed on several levels. A local transaction uses the internal transaction manager of a program such as SQL Server or Message Queue Server. A distributed transaction uses the Microsoft Distributed Transaction Coordinator (DTC) as a transaction manager and a transaction coordinator to run transactions in a distributed environment. This article will discuss manaul transactions, which allow stricter control of your transactions within an application. |
|
| Transaction Control |
| MSDN |
| This article describes how to run local and distributed transactions in your Microsoft .NET applications. |
|
| Transactions in Web Services - Part 1 |
| C# Corner |
| This article discusses what transactions are and how trasactions can be used in Web services by Web developers. |
|
