I\'m using SqlDataAdapter.Update with DataTables to update two SQL tables in a single transaction. If either insert fails I want to roll back all data. This is my code:
I\'m writing some merge functionality in C# asp.NET MVC2. I am also using using Linq2SQL. I have a block of code which calls two services, MessageService and UserService. These both in term call thei
We are having a few problems under开发者_开发技巧standing how best to use NHibernate.We typically have a relatively large number of quite small (in terms of number of tables) SQL Server databases rath
I have a block of code that runs within a TransactionScope and within this block of code I make several calls to the DB. Selects, Updates, Creates, and Deletes, the whole gamut. When I execute my dele
can I do something like this: using (var scope = new TransactionScope()) { using (var conn = new SqlConnection(Cs))
I am having the following deadlock in SQL Server 2005 with a specific delete stored proc and I can\'t figure out what I need to do to remedy it.
I have created a TransactionScope and within the scope various items are created and updated in the datab开发者_如何学JAVAase. During this process I make a lot of calls to the database. Originally I o
What does it mean for an SqlConnection to be \"enlisted\" in a transaction?Does it simply mean that commands I execute on the connection will participate in the transaction?
I have a client trying to communicate with a WCF service in a transactional manner. The client passes some data to the service and the service adds the data to its database accordingly. For some reaso
I am trying to nest TransactionScopes (.net 4.0) as you would nest Transactions in SQL Server, however it looks like they operate differently. I want my child transactions to be able to rollback if th
加载中,请稍侯......