tagged [transactions]

what does a using statement without variable do when disposing?

what does a using statement without variable do when disposing? I've always used using with variable and assignment. Now i have like this a class DbProviderConnection: ``` public class DbProviderConne...

24 Feb at 12:55

NHibernate with Autofac within ASP.NET (MVC): ITransaction

NHibernate with Autofac within ASP.NET (MVC): ITransaction What is the best approach to managing NHibernate transaction using Autofac within web application? My approach to session is For `ITransactio...

Database.BeginTransaction vs Transactions.TransactionScope

Database.BeginTransaction vs Transactions.TransactionScope What is the difference between `System.Transactions.TransactionScope` and EF6's `Database.BeginTransaction`? Could someone give a small examp...

Pros and cons of READ_COMMITTED_SNAPSHOT

Pros and cons of READ_COMMITTED_SNAPSHOT What are the pros and cons of setting `READ_COMMITTED_SNAPSHOT ON` in SQL server 2008? Actually i was running through the the problem of transaction deadlockS,...

24 Oct at 16:40

C# - System.Transactions.TransactionScope

C# - System.Transactions.TransactionScope I was curious about the TransactionScope class. For the most part, I assume it was intended for database connections (which is what I've used it for). My ques...

Does ServiceStack's OrmLite support nested transactions? If so, how?

Does ServiceStack's OrmLite support nested transactions? If so, how? I'm looking for a working example of an outer method containing a transaction calling an inner method which also contains a transac...

17 Mar at 08:10

Use of TransactionScope with read uncommitted - is with (nolock) in SQL necessary?

Use of TransactionScope with read uncommitted - is with (nolock) in SQL necessary? I am using FluentNHibernate, and I have a list of records, mapped to an SQL Server 2008 view. Dirty reads are OK with...

Howto Ambient Transaction in ServiceStack.net

Howto Ambient Transaction in ServiceStack.net I am developing a server application using ServiceStack.net. The Database is accessed via EntityFramwork. Now I would like to have an Ambient Transaction ...

C#/SQL Database listener

C#/SQL Database listener I have a requirement to monitor the Database rows continuously to check for the Changes(updates). If there are some changes or updates from the other sources the Event should ...

8 Jan at 12:52

How to find the Transaction Status

How to find the Transaction Status I am using 'TransactionScope', and I need to just do some DML within the C# Code, which I have successfully. I need to find out that , that is has it completed succe...

Difference Between Transaction and TransactionScope

Difference Between Transaction and TransactionScope I am developing an application which communicates with an SQL Server 2005 database to execute some stored procedures. My client demands that all tra...

Servicestack.redis Transactions and Hashes

Servicestack.redis Transactions and Hashes How can I get all the entries from a hash while in a transaction? I don't see an `onSuccessCallback` with the right type. I tried mapping it as a `byte[][]` ...

15 Apr at 16:28

How to create a class that works with TransactionScope?

How to create a class that works with TransactionScope? Just wondering, if I want to create a class that does something and I want to be able to be used in a TransactionScope, what would I need to imp...

Is Explicit Transaction Rollback Necessary?

Is Explicit Transaction Rollback Necessary? Many examples out there advocate explicit rollback of database transactions, along the lines of: However, I te

17 Feb at 13:24

TransactionScope With Files In C#

TransactionScope With Files In C# I've been using TransactionScope to work with the database and it feels nice. What I'm looking for is the following: but obviously this doesn't work -- if there are 2...

When does "SqlConnection does not support parallel transactions" happen?

When does "SqlConnection does not support parallel transactions" happen? I have a ton of rather working code that's been here for months and today I saw the following exception logged: ``` System.Inva...

24 Oct at 07:34

Is SQL Server Bulk Insert Transactional?

Is SQL Server Bulk Insert Transactional? If I run the following query in SQL Server 2000 Query Analyzer: On a text file that conforms to OurTable's schema for 40 lines, but then changes format for the...

Using NHibernate transaction in SqlBulkCopy

Using NHibernate transaction in SqlBulkCopy I'm storing some data using NHibernate, and I need to insert huge amount of data as a part of this action - i.e. in the same transaction. Code looks like th...

Using Transactions or SaveChanges(false) and AcceptAllChanges()?

Using Transactions or SaveChanges(false) and AcceptAllChanges()? I have been investigating transactions and it appears that they take care of themselves in EF as long as I pass `false` to `SaveChanges...

20 Mar at 11:20

TransactionScope: Avoiding Distributed Transactions

TransactionScope: Avoiding Distributed Transactions I have a parent object (part of a DAL) that contains, amongst other things, a collection (`List`) of child objects. When I'm saving the object back ...

SQL Server - transactions roll back on error?

SQL Server - transactions roll back on error? We have client app that is running some SQL on a SQL Server 2005 such as the following: It is sent by one long string command. If one of t

SQL Server, C#: Timeout exception on Transaction Rollback

SQL Server, C#: Timeout exception on Transaction Rollback I've got a strange problem. I have a .NET program and my process logic needs a long-running transaction (~20min) on a SQL Server 2005 database...

Will a using statement rollback a database transaction if an error occurs?

Will a using statement rollback a database transaction if an error occurs? I've got an IDbTransaction in a using statement but I'm unsure if it will be rolled back if an exception is thrown in a using...

"The operation is not valid for the state of the transaction" error and transaction scope

"The operation is not valid for the state of the transaction" error and transaction scope I am getting the following error when I try to call a stored procedure that contains a SELECT Statement: > The...

SQL Server snapshot isolation level issue

SQL Server snapshot isolation level issue I am studying snapshot isolation level of SQL Server 2008 from the below link. My confusion is, [http://msdn.microsoft.com/en-us/library/ms173763.aspx](http:/...